Huh you know it's CATEGORY, right? Not that it matters, software-wise, but another person might tick.
-----Original Message----- From: Alex Elger [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 8: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]
