Introducing IQUERY© v1.0.2 Engine



Corporation IQUERY Example

I have in the system a CDS/ISIS DataBase called 'CORPOR', and my job consist of developing a search tool that build a query result table with the information of all the employers working in the Corporation, listed by Code, Name, Address and Work Section. The CDS/ISIS 'CORPOR' DataBase have the folowing structure... Tag Name Length Type Rep Delimiters 10 Code 10 X No None 20 Name 40 X No None 30 Address 30 X No None 40 Section 20 X No None As the user don't care if he or she type in uppercase or lowercase, then i pass to IQUERY in the 'HTMLPARAMS' hidden variable '-nocase', and also i do not like a full employers table when somebody type only a space in the KeyWord, that's why i do not use '-nostrict' preferring the strict deletion of spaces at the begining and end of the KeyWord. I have access to put my funny files in the 'httpd/iquery-demo' path under the Isis system path, that's why my 'FILEPRINT' statements have relative files instead of absolute ones, and to pretty print my result i use the 'STRPRINT' statement to output the KeyWord the user enter. I also have a variable 'FIELD' used in a macro substitution in the 'QUERY' variable that give three types of search KeyWords to the users, by Section, Name and Address. Also i keep in my mind that i have to be very carefully with the coding of my IQUERY statments because i want to return HTML code to the result query page, that's why i put the '"' inside 'QUERY' variable; if i do not put it in this form, i really will confuse the WWW Client of the user.

Corporation Test FORM

Enter Search KeyWord Search For Section Name Address