Hi. I know that the ampersand (&) character, when in an insert statement in SQL*PLUS, causes a problem, because it's a special character. I am guessing that there is a way to escape this out, but I can't figure it. Here is the statement:
INSERT INTO DEPARTMENTS VALUES (1,2,3,'Mergers & Acquisitions'); Anyone know how to escape the &? I am sure that this is the problem: removing it fixes it, and it runs fine in a CFQUERY. It's in SQL*PLUS alone that there is a problem. Thanks, Matthieu ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
