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]

Reply via email to