<cfqueryparam cfsqltype="..."
value="#preservesinglequotes(form.variable)#">
Doesn;t help for all those records where theres already a load of single
quotes - but it should be easy enough to write an update query to get
rid of those.
Alex
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 10 December 2003 03:18
To: CF-Talk
Subject: Ever growing single quotes (')
Has anybody ever experienced a problem, where if you update a
string in a SQL 2000 database with a <cfqueryparam> tag, each time the
string is updated, an additional single quote is appended to each single
quote in the string?
Start with the string
I'll just run to the store and get some milk.
Update it once and you get
I''ll just run .....
Update it a second time you get
I''''ll just run ....
After not too many reputations of this, you can get an a
awefully long series of single quotes.
I can't see anyplace where this is obviouslly happening. The
form that contains the string doesn't show the new quotes, but it will
show the quotes the next time the record in viewed.
_______________________________________
Ian Skinner
Web Developer
Sierra Outdoor Recreation
(http://www.SierraOutdoorRecreation.com)
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
