Database results wizard query

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

Stefan
Thu Nov 11 03:28:24 CST 2004

Remove the PR=
- not used in your query or s-sql

List.asp?Rooms=2

Then
s-sql="SELECT * FROM SOL_Voidlist WHERE Rooms=" & Room_No & """

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Nick Halfpenny" <NickHalfpenny@discussions.microsoft.com> wrote in message
news:E81CC1D3-FC37-4226-9F49-6457D4BD67D2@microsoft.com...
| 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