Brilliant Darryl - thanks!!!
----- Original Message -----
From: "Darryl Lyons" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[email protected]>
Sent: Friday, January 28, 2005 2:49 PM
Subject: [cfaussie] Re: Turning of the auto-escaping of single quotes
> PreserveSingleQuotes() will do it
>
> Darryl Lyons
>
> [EMAIL PROTECTED] wrote on 28/01/2005 01:45:31 PM:
>
> > Hi All,
> >
> > I have code the following code
> >
> > <cfset allowed_status_codes = "'01','99'">
> >
> > ...
> >
> > SELECT *
> > FROM SB_ITEM_STATUS
> > WHERE ITEM_STATUS_CODE IN (#allowed_status_codes#)
> >
> > However when it executes the status codes are all escaped as
> >
> > WHERE ITEM_STATUS_CODE IN (''01'',''99'')
> >
> > and it fails.
> >
> > Is there any way to turn of the auto-escaping of single quotes with an
> > additional single quote within a cfquery?
> >
> > Thanks,
> > Phil.
> >
> >
> > ---
> > You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED]
> > To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> > Aussie Macromedia Developers: http://lists.daemon.com.au/
>
>
>
> To unsubscribe from this email please forward this email to
[EMAIL PROTECTED]
>
> This email message is confidential and may be privileged. If you are not
the intended recipient
> please forward the email to [EMAIL PROTECTED] and delete the
original.
>
> ABN AMRO Morgans Limited and its associates hold or may hold securities in
the companies/trusts mentioned herein.
> Any general advice included in this email has been prepared without taking
into account your objectives, financial situation or needs.
> Before acting on the advice, you should consider its appropriateness or
discuss with one of our investment advisors.
>
> ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of
ASX Group.
> A principal member of the Financial Planning Association.
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
[EMAIL PROTECTED]
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
