Thanks I will try that. For some reason I thought they would over write
eachother...
i'll let ya know if it works. :)
---------------------------------------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---------------------------------------
> -----Original Message-----
> From: Zachary Bedell [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 10:08 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Tricky one for you...
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> > <input type="checkbox" name="?" value="1">Item Name
> > These are all built on the fly from the item table. So first
> > I can't NAME
> > THEM ALL
> > Item_ID because then the last one checked over rides all the
> > others.
>
> Nope. You should be able to name them all Item_ID. Make the VALUE
> of each check box the particular Item_ID. Then on the template that
> receives the form post, Item_ID will be a nice comma delimited list
> of all the ItemID's that were checked.
>
> The code in your receiving template would look something like:
>
> <cfquery name="Whatever" datasource="#DSN#">
> <cfloop list="#Item_ID#" index="TheItem">
> INSERT INTO SI_ITEMS
> (Report_ID, Item_ID)
> VALUES(#Report_ID#, #TheItem#)
> </cfloop>
> </cfquery>
>
> Hope that helps.
>
> Best regards,
> Zac Bedell
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
> Comment: Please use PGP!!!
>
> iQA/AwUBOYgrUQraVoMWBwRBEQJXigCg/rIPuGHHWZ7XEoM5pb/i16gZ/DIAn0Je
> 9bx94RpBJt5ooBUKrKjC6bQ0
> =jVtn
> -----END PGP SIGNATURE-----
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.