ASP SQL Statement

[Justin Meyer]

Can anyone see what is wrong with this?

'declare variables
Dim ID2
Dim connection, sSQL, sConnString
ID2 = Trim(Request.QueryString("ID"))
'SQL statement
sSQL="DELETE * FROM Results WHERE ID='" & ID2 & "'"

 

[Kevin Spencer]

Hi Justin,

What data type is ID in the database? If it's numeric, you need to lose the
single quotes around the value in your SQL Statement:

sSQL="DELETE * FROM Results WHERE ID=" & ID2

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[Justin Meyer]

'declare variables
Dim ID2
Dim connection, sSQL, sConnString
ID2 = Trim(Request.QueryString("ID"))
'SQL statement
sSQL="DELETE * FROM Results WHERE ID=('" & ID2 & "')"


This give the following Error Message?

 

[Justin Meyer]

Its an Auto Number in a Access Database

Hi Justin,

What data type is ID in the database? If it's numeric, you need to lose the
single quotes around the value in your SQL Statement:

sSQL="DELETE * FROM Results WHERE ID=" & ID2

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[Justin Meyer]

Good Idea, but I tried that also and get the following message.
Does this give any additional Info?

 

[Kevin Spencer]

Apparently, there is no "ID" value in the QueryString. Do you see one in
your browser?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

 

[Justin Meyer]

Thanks you so much, the link was were the problem was.
If only I would have seeked you out sooner. You could have saved me a great
deal of frustration.

Thanks again.
Justin

 

[Kevin Spencer]

I'll be here, Justin!

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.