The SQL itself looks fine to me. The most likely problem is the content and format of form.posted_transactions_id It should be a comma delimited list.
If id is a text field, each value will need to be enclosed with single quotes. HTH Phil. ----- Original Message ----- From: "Claude Raiola" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 9:01 AM Subject: [cfaussie] Re: Help Using ValueList > record id numbers > > > > > 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]> > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Phil Evans > Sent: Wednesday, 16 July 2003 7:12 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Help Using ValueList > > > 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/ > > > > --- > 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/
