Thats not even very good If nothing gets passed witht he form, then the query will error because it will be looking at (0,)
Be better doing it thisway <cfquery name="Hirum_status" datasource="#ds#" username="#username#" password="#password#"> update s8_Building_Maintenance_Activity set Hirum_Posted ='yes' where id IN (#ListAppend(form.posted_transactions_id,0)#) </cfquery> Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joel Nath Sent: Wednesday, 16 July 2003 10:26 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Help Using ValueList Hi, assuming your posted_transactions_id has holds values like . .eg 23,65,43,1,89,65 i have added the 0, infront of the list value, just incase the posted_transactions_id field comes back empty so it wont break your query. you dont have to use the ValueList function in this case... ValueList function is used for queries.. <cfquery name="Hirum_status" datasource="#ds#" username="#username#" password="#password#"> update s8_Building_Maintenance_Activity set Hirum_Posted ='yes' where (id in (0,#form.posted_transactions_id#)) </cfquery> hth joel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claude Raiola Sent: Wednesday, 16 July 2003 6:50 To: CFAussie Mailing List Subject: [cfaussie] Help Using ValueList I am using a form page that is outputting a set of records for each outputted record of the results set I have a hidden variable called id present when submitting the form page I wish to update a database take only those records who's id's values have been passed by the form by the hidden form variable "id" how best do I get this working I have tried using value list however it seems that only works when the value list has a query referenced within it rather than a set of hidden values from the form page the code I am trying to get working is : <cfquery name="Hirum_status" datasource="#ds#" username="#username#" password="#password#"> update s8_Building_Maintenance_Activity set Hirum_Posted ='yes' where (id in (#valuelist(form.posted_transactions_id)#)) </cfquery> your assistance would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Mobile: 0414 228 948 Fax: 07 3319 6444 Websites: www.AustralianAccommodation.com <http://www.australianaccommodation.com/> www.AccommodationNewZealand.com <http://www.accommodationnewzealand.com/> www.HospitalityPurchasing.net <http://www.hospitalitypurchasing.net/> <mailto:[EMAIL PROTECTED]> --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
