what about using <cfqueryparam>?
<cfqueryparam value="#form.test_text#" cfsqltype="cf_sql_char">
On Wed, 10 Nov 2004 11:14:36 -0800, JB McMichael <[EMAIL PROTECTED]> wrote:
> 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:183899
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
