Thanks much, Charlie!
--Ben
>WHERE itemno IN (#preserveSingleQuotes(itemnos)#)
>or even better:
>
>WHERE itemno IN (list="true" />)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the
WHERE itemno IN (#preserveSingleQuotes(itemnos)#)
or even better:
WHERE itemno IN ()
On Thu, Oct 23, 2008 at 12:21 PM, Ben Conner <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a simple update query that is throwing an error:
>
>update icitem
>set lastchanged = '1/1/2008'
>
Hi,
I have a simple update query that is throwing an error:
update icitem
set lastchanged = '1/1/2008'
where itemno in (#itemnos#)
The itemnos variable has the value:
'1A703239', '1A703240', '1A703241', '1A703242', '1A703243'
If I paste that value in between the parens,
3 matches
Mail list logo