Re: cfinsert/cfupdate and double quotes

2007-02-26 Thread Steve Bryant
>It's just not *displaying* when looking at the above. > >So >value="#htmleditformat(getapp.ID_app_owner)#" > > >Or is there a better way? That is what I do. This also helps with security. ~| Upgrade to Adobe ColdFusion MX7 E

Re: cfinsert/cfupdate and double quotes

2007-02-26 Thread Les Mizzell
Steve Bryant wrote: > Are you sure that the problem isn't that you are > using instead of ? After looking at it a little closer - my bad. The value Bob "Bubba" Jones *is* getting recorded correctly on insert/update. It's just not *displaying* when looking at the above. So value="#html

Re: cfinsert/cfupdate and double quotes

2007-02-26 Thread Steve Bryant
Are you sure that the problem isn't that you are using instead of ? I just ran a test on cfinsert with quoted values in CF7 against SQL Server 2000 and it inserted the quoted values without any problem. If you load values with quotes into an input box, then the value will be loaded into an at

cfinsert/cfupdate and double quotes

2007-02-26 Thread Les Mizzell
I thought cfinsert and cfupdate escaped double quotes? SQL Server vchar fields - seems the answer is NOPE. CFINSERT will not accept Bob "Bubba" Jones as input into SQL Server vchar field. No problem with an nTEXT field though. Any way around this without rewriting all my queries to use SQL inser