Alex, others have posted string quoting syntax advice that may solve your problem. If it doesn't, is there a chance that field name "Catagory" has been properly spelled "Category" in the new Oracle database?
HTH -----Original Message----- From: Alex Elger [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 11: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]
