" is for object identifiers (schemas, tables, columns, etc) ' is for strings
These are ANSI standards, and people that use them interchangeably really should stick to the standard. It gets confusing when you switch from db to db. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Alex Elger [mailto:[EMAIL PROTECTED]] 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]
