N
Nick Halfpenny
Hi,
I'm using the database result wizard to extract information from a Access
database. The wizard allows you to enter critera at the top ASP page once
it's created it.
If I create a separate HTML page as a 'critera entry' page, how do I pass
the information from the HTML page to the ASP AND then pass it into 'webbot'
that runs the SQL statement ?
In the HTML page, I call the ASP with the following command:
List.asp?PR=Rooms=2
The ASP page, get the data passed with the following bit of script:
<%session.LCID = 2057
Room_No=request.querystring("Rooms")
%>
In the webbot command, I have the following SQL statment in the s-sql field:
s-sql="SELECT * FROM SOL_Voidlist WHERE (Rooms=' & Room_No & ')"
If I this, it seems that the webbot command complete ignores the value in
the Room_No field. If I amend the SELECT statement and type the value
directly, it works OK !
Can anyone let me know what I'm doing wrong and why webbot ignores extrnal
values held within a field ?
Thanks for your help in advanced.
Regards,
Nick
I'm using the database result wizard to extract information from a Access
database. The wizard allows you to enter critera at the top ASP page once
it's created it.
If I create a separate HTML page as a 'critera entry' page, how do I pass
the information from the HTML page to the ASP AND then pass it into 'webbot'
that runs the SQL statement ?
In the HTML page, I call the ASP with the following command:
List.asp?PR=Rooms=2
The ASP page, get the data passed with the following bit of script:
<%session.LCID = 2057
Room_No=request.querystring("Rooms")
%>
In the webbot command, I have the following SQL statment in the s-sql field:
s-sql="SELECT * FROM SOL_Voidlist WHERE (Rooms=' & Room_No & ')"
If I this, it seems that the webbot command complete ignores the value in
the Room_No field. If I amend the SELECT statement and type the value
directly, it works OK !
Can anyone let me know what I'm doing wrong and why webbot ignores extrnal
values held within a field ?
Thanks for your help in advanced.
Regards,
Nick