-----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.

Reply via email to