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/
