Re: Update Query syntax

2008-10-23 Thread Ben Conner
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

Re: Update Query syntax

2008-10-23 Thread Charlie Griefer
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' >

Update Query syntax

2008-10-23 Thread Ben Conner
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,