Calling querystring

Results 1 to 3 of 3

Thread: Calling querystring

  1. #1
    Join Date
    Dec 1969

    Default Calling querystring

    is it possible to call a query string (ie. "printers") and then use this in the SQL to select the table "printers"

  2. #2
    Join Date
    Dec 1969

    Default RE: Calling querystring

    yes, Its possible. But before that, If you could explain your problem with example, it will be great.<BR><BR>Thx Ani.

  3. #3
    Join Date
    Dec 1969

    Default QUERY STRING

    here you go<BR>&#060;%<BR>dim db<BR>dim rs<BR><BR>tblname=request.querystring("printers")< BR>sqlstring="select * from "&tblname<BR><BR>set db=server.createobject("adodb.connection")<BR>set rs=server.createobject("adodb.recordset")<BR>db.op en "connection string......"<BR> strsql,db<BR>do while not rs.eof<BR>&#039;print your records<BR>rs.movenext<BR>loop<BR>rs.close<BR>set rs=nothing<BR>set db=nothing<BR>%&#062;<BR><BR><BR><BR>%&#062;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts