Hi Mike, I have found in the past a value such as 42" wheels is _inserted_ into the database without any problem. However, when the "update" form is used with the same value the html is rendered as:
<input type="text" name="myField" value="42" wheels" /> Notice that the value attribute is prematurely ended.. but seems to still render in the browser. The solution was to use the #htmlEditFormat()# function on the value attribute of your form field eg: <input type="text" name="myField" value="#htmlEditFormat(myField)#" /> Hope this helps. Cheers, Adam -----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, 7 January 2008 3:39 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Problem with double quotes and SQLServer Well when i add a description like 42" wheels myself on the production server, it stores in the database just fine. But when the client does it, it doesn't. So there's something different about what the client's doing. The client's not what you'd call computer savvy, and isn't cutting and pasting from a word document so I dont think the problem is they're using the MS Word smart quotes (66/99) and I'm not. That's why I assumed the problem must be that they're using Vista (their computer is brand new) and it's putting a different character in the field for the double quote character. But i'm open to any suggestions. It's very frustrating trying to fix a problem when i can't reproduce it myself. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 1/7/08, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Are there any other differences with the server? Or maybe the browser? > > The OS should not make a difference... > > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone:+613 9015 8628 > Mobile: 0404 998 273 > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---