I have an input box called test_text.  I enter in ''some text''. 
Insert that into the db
insert into table (some_text)
values('#preservesinglequotes(test_text)#')

When I output that I get 'some text'

I then tried '''some text''' and got back ''some text''

It seems as if cf internally just changes '' to ' before it ever gets
to preservesinglequotes.


On Wed, 10 Nov 2004 14:03:10 -0500, Claude Schneegans
<[EMAIL PROTECTED]> wrote:
> >>I tried preservesinglequotes and it didn't change anything.
> 
> PreserveSingleQuotes() will only work on a variable, not directly on a string.
> It might be your problem.
> 
> --
> _______________________________________
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183897
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to