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 PROTECTED]
