Why not put the single quotes within your txtSQL string immediately before and after you concatenate your variable?
i.e: txtSQL = "SELECT * FROM DocRep Where CATAGORY = '" + Catagory + + "' ORDER BY DOCNO;" Does that help? And, not to be picky, but CATAGORY is spelled CATEGORY....obviously this does not affect your app, but should someone come along after you to maintain it, they may pull their hair out trying to debug their SQL statement that spells CATEGORY correctly... -ns -----Original Message----- From: Alex Elger [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 10:53 AM To: ActiveServerPages Subject: ASP and Oracle I am starting to use asp with oracle and i am having some problems. This code used to work with Access; txtSQL = "SELECT * FROM DocRep Where CATAGORY = " + chr(34) + Catagory + chr(34) + " ORDER BY DOCNO;" When i run it with oracle (After removing the trailing ;) I get an invalid column name. It is to do with the single/double quotes arround the variable/string. if i run; txtSQL = "SELECT * FROM DocRep Where CATAGORY = '3a' ORDER BY DOCNO" It returns th proper results. If anyone can help me i would be greatful. Alex Elger Micronage Ltd [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
