WHERE ticketID IN (0<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#tickList#" list="Yes">)
How about adding 0 to allow for empty lists... MW > -----Original Message----- > From: paul smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, 23 December 2002 10:58 a.m. > To: CF-Talk > Subject: Re: CFQUERYPARAM and Lists > > > And add ()? > > WHERE ticketID IN (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" > value="#tickList#" list="Yes">) > > best, paul > > At 10:36 PM 12/22/02 +0100, you wrote: > >Quoting Cedric Villat <[EMAIL PROTECTED]>: > > > > > > <cfquery name="updateTicket" datasource="#request.dsn#" > > > username="#request.dbuser#" password="#request.dbpass#"> > > > UPDATE Tickets > > > SET folder = <cfqueryparam cfsqltype="CF_SQL_INTEGER" > > > value="#getEscalationInfo.eFolder#">, > > > dateUpdated = <cfqueryparam cfsqltype="CF_SQL_TIMESTAMP" > > > value="#CreateODBCDateTime(Now())#"> > > > WHERE ticketID = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" > > > value="#tickList#" list="Yes"> > > > >Change = to IN. > > > >Jochem > > > >-- > >Friends don't let friends use table-based layouts. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
