Dumb Order By Question 1

[WB786]

This is what I have:

strSQL = "SELECT * FROM tblItems WHERE [Active]=true and [ClassNumber]= '" & Request.querystring("Id") & " ORDER BY [ItemName]'"

But my items are not coming up and if I remove ORDER BY then the items show on the page. But I need to have this ORDER BY ItemName.

Thanks in advance,

WB

 

[gmmastros]

You had an apostrophe in the wrong place.

strSQL = "SELECT * FROM tblItems WHERE [Active]=true and [ClassNumber]= '" & Request.querystring("Id") & "[!]'[/!] ORDER BY [ItemName]"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[WB786]

WORKED!!! THANK YOU FOR THE QUICK RESPONSE. I need to get my eyes checked again!!!

WB