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
