Using ASP's QueryString

The QueryString collection, a collection of values of variables in the HTTP query string in the URL, is available to the ViewRecords method of the SQLXML component (Litware.dll) when the Request object (an intrinsic ASP object) is passed to ViewRecords. The following examples are from Group.htm, GroupList.htm, and ActivityList.htm; all *List.htm and *.htm files contain similar code.

The QueryString collection has one of the following formats:

• For full-text search. The term variable contains the search criteria.

   var xml = '../Scripts/viewData.asp?tableName=group&fieldList=GroupId,Name&sortBy=Name&search=' + term;
  

• For search by primary key value. WhereID indicates the query includes a WHERE clause and the value in id is the object of the SELECT statement.

  var xml = '../Scripts/viewData.asp?tableName=group&whereID=' + id;
  

• For retrieval of all table records. The following line of code retrieves all LocationId, Name, and MaxOccupancy columns from the Location table in the Eval database. The fieldList variable contains the names of the columns to return. The QueryString includes a sortBy variable, which the ViewRecords method translates to the T-SQL ORDER BY clause.

  xmldoc.load('../Scripts/viewData.asp?tableName=location&fieldList=LocationId,Name,MaxOccupancy&sortBy=Name');
  

• For executing a stored procedure. The following line of code runs a SQL Server stored procedure (lw_getActivityTypes) and includes the name and value pair groupId=' + id. The id variable contains the value of an input parameter for the stored procedure.

  The following code fragment from activityList.htm gets the activities for a group:

  if (id != null) xml = '../Scripts/viewData.asp?procName=lw_getActivityTypes&groupId=' + id;