Thanks, worked like a charm. Cedric
----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 22, 2002 1:36 PM Subject: Re: CFQUERYPARAM and Lists > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
