Catagory = replace(Category, "'", "''") txtSQL = "SELECT * FROM DocRep Where CATAGORY = '" + Catagory + "' ORDER BY DOCNO;"
By the way that type of data is it? Char? Integer? Also, as somebody else suggested it, it's "category", not "catagory". -----Original Message----- From: Bill [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 10:06 AM To: ActiveServerPages Subject: RE: ASP and Oracle Alex, Any compelling reason for you not to do: txtSQL = "SELECT * FROM DocRep Where CATAGORY = '" + Catagory + "' ORDER BY DOCNO;" >-----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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
