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/
