That did it. Thank you very much.
On Wed, 10 Nov 2004 12:18:38 -0700, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> 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:183901
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
