Hi Claude, What values are in form.posted_transactions_id?
Phil. ----- Original Message ----- From: "Claude Raiola" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 6:49 AM 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/
