SELECT from db based on number / ID

[LEICJDN1]

I need to select a recordset by ID number.

Had planned on doing this by sending the ID as a querystring from the requesting link.

Then something like this:

deltarget=Request.Querystring
"SELECT * FROM reftable WHERE ID=" & deltarget & "'"

But this errors out. I guess it is because the ID integer pulled onthe previous page is sent as a 'string' so conflicting with the ID field being autonumber in the db.

Is there a way to turn the string back into an integer to use in the SQL statement or is my SQL statement at fault?

Thanks again.

 

[mattygriff]

You're not delimiting your string correctly - you have an apostrophe at the end but not directly after ID= in your SQL.

 

[FesterSXS]

You need to specify the name of the QueryString item whose value you are trying to read. It is also worth converting it to an Int if it is a number you are sending.

deltarget= CInt(Request.Querystring("deltarget"))

strSQL = "SELECT * FROM reftable WHERE ID=" & deltarget & "';"

Tony

http://www.SpiraxSarco.com

 

[harrysdad]

You haven't specified that the querystring is called - i.e.

deltarget = Request.QueryString("ID")

 

[amorous]

Try this:

A small change to what tony suggested-

deltarget= CInt(Request.Querystring("deltarget"))

strSQL = "SELECT * FROM reftable WHERE ID="&deltarget


VJ

 

[LEICJDN1]

Thanks all - suprised by the flood of responses.

You were kinda all right - managed to work though the suggestions and ended up with this amalgamation that works just fine:

deltarget=CInt(Request.Querystring)
"SELECT * FROM reftable WHERE ID=" & deltarget & ";"

This is turning the querystring into an integer then matching that to the ID delivering the relevant recordset nicely.

Cheers..

 

[amorous]

How come

deltarget=CInt(Request.Querystring)

the above line works??


VJ

 

[LEICJDN1]

Don't know!
Tried the version given but gave an error.
Changed it to the above and it works fine.

 

[FesterSXS]

The Querystring name of "deltarget" that I stated was an example. What is the name of the querystring item you use? Did you substitute my example name for your actual name?

How are you passing the querystring to this page from the previous page?

Tony

http://www.SpiraxSarco.com

 

[LEICJDN1]

The querystring is just a number - there is only one so I did not bother with a name.
The referring link looks like thie something.asp?4 for example.

Sorry for the confusion - I see know that if the querystring was named then your example would work fine.