RE: quot problem
I have done this before. For the SQL statement I replace all single quotes with ''. To get a selected string to display properly in HTML, I replace double quotes with " and amperstands with &. This eliminates most problems I have had with rendering. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Phim [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 15, 2001 05:34 > To: CF-Talk > Subject: quot problem > > > Is anybody have problem about using sql statement with quot( " ) > and single > quot( ' ) insert or query from database and for retrieve and display in > coldfusion. > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: quot problem
so far nope, but would be more help if you mentioned what database you're using. - Original Message - From: Phim <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, January 15, 2001 7:33 PM Subject: quot problem > Is anybody have problem about using sql statement with quot( " ) and single > quot( ' ) insert or query from database and for retrieve and display in > coldfusion. > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: quot problem
> Is anybody have problem about using sql statement with quot( " ) > and single > quot( ' ) insert or query from database and for retrieve and display in > coldfusion. It's a mixture between a SQL and a ColdFusion problem - to use single quotes you have to escape it, either as '' or as \' With quotes you have to deal with them separately and either treat them as HTML (") or escape them intelligently in the string It's a pain, but you get used to it... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: quot problem
> Is anybody have problem about using sql statement with quot( " ) and single quot( ' ) insert or query from database and for retrieve and display in coldfusion. Check out the PreserveSingleQuotes() function Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: quot problem
There is also a CF Function to deal just with single quotes in data, oddly enough called PreserveSingleQuote. Double quotes inside single-quoted text shouldn't be a problem. The following code bombs... insert into table values ('#var#) This code works: insert into table values ('#PreserveSingleQuotes(var)#') The SQL output is: insert into table values ('Brian''s Book') Brian -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 10:34 AM To: CF-Talk Subject: RE: quot problem I've never had a problem with single or double quotes, am I missing something? I always use CFQUERYPARAM when inserting data, so the data can contain all the single and double quotes it wants. Is there a problem selecting and displaying the data? If you are talking about displaying the data in a form field, then I have experienced that problem: causes problems. I don't allow double quotes at all in my text fields. R ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists