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/
