Craig,
Can you explain more on what you are trying to do. Are you
selecting multi items in a select box and trying to write multi records in a
database.
If so then the select box will have a value like 23,45,66,34.
All you need to do is loop through the form field i.e.
<cfloop list="form.field" index="counter">
insert record here
</cfloop>
When you are inside the loop the form value is refereed to as counter. So
the first time it loops counter = 23, the second time counter = 45, etc. So
you just insert counter as your record.
Brian Knott
> -----Original Message-----
> From: Chris Ellem [SMTP:[EMAIL PROTECTED]
> Sent: Wednesday, 3 March 2004 8:37
> To: CFAussie Mailing List
> Subject: [cfaussie] U P D A T E Multiple Records
>
> General
> Does anyone know how to update multiple records from a form?
>
> Specific
> Does any know how to update multiple records where there is a select box
> in the form?
>
> Currently the value entered into the database in the required field
> displays every entry in the select box with commas between, for every
> record that is to be updated..
>
> Pulling Hair OUT!!!
>
> Any Takers
>
> If you have the answer you can email or call me
>
> [EMAIL PROTECTED]
>
> 1300 302 349
>
> Chris E
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
-----------------------------------------------------------------------------------
The contents of this message are the views of the Author and do not necessarily
reflect the views of SUNCORP METWAY LTD ABN 66 010 831 722.
The content of this e-mail, including attachments is a confidential communication
between the Suncorp Metway Group and the intended addressee. Any unauthorised use of
the contents is expressly prohibited. If you have received this e-mail in error please
contact the sender immediately and then delete the message and any attachment(s).
http://www.suncorp.com.au
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
