Thank you Clint and Rodney for your answers!
Melissa
"Bruce, Rodney" wrote:
> Melissa
>
> I haven't seen an answer back to you yet, so here is one possibly way.
> IF (assuming here) you are displaying all items for sale, with a text box to
> enter number of each item customer wants to buy: i.e (123, Shovels,
> garden, []) (side comment you may want to display price):
>
> <!--small change here, I would set default to 0(ZERO), for control and add a
> hidden to pass idnumber --->
> <INPUT type="text" name="Item_#equipment.id#" SIZE="5" WIDTH="10" value="0"
> CLASS="monospace">
>
> <INPUT type="hidden" name="Itemid_#equipment.id# value="#equipment.id#>
>
> sample code for ACTION PAGE:
>
> <CFQUERY name="equipment" datasource="DSN">
> SELECT ID
> FROM Equipment
> ORDER BY ID
> </CFQUERY>
>
> <CFOUTPUT query="equipment">
> <CFSET quanity = "#EVALUATE("item_#equipment.id#")#">
> <CFSET idnum = "#EVALUATE("itemid_#equipment.id#")#">
> <CFIF quanity GT 0>
> <CFSET soldequipment= #quanity#>
> <CFSET eqiuipmentid = #idnum#>
> </CFIF>
> </CFOUTPUT>
>
> This will get you the to vars for use on your action page, you can expand
> on this to pass other vars you would want to work with.
> you might want to look at using a <CFLOOP> index instead of the id from the
> query.
>
> let me know if this helps, if someone has given you a better way, please let
> me know. I have been working with this type of thing for awhile now and
> haven't gotten very far myself.
>
> -----Original Message-----
> From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 1:32 PM
> To: CF-Talk
> Subject: Newbie question -- Dynamic form processing
>
> Hello everyone.
> How do you handle processing dynamic forms?
>
> Here is my example code:
>
> <CFQUERY name="equipment" datasource="DSN">
> SELECT ID, Category, Item
> FROM Equipment
> ORDER BY ID
> </CFQUERY>
>
> <HTML>
> <BODY>
>
> <FORM METHOD="post" action="ActionPage.cfm" >
>
> <TABLE>
>
> <TR>
> <TD CLASS="title" WIDTH="141" HEIGHT="13">ID</TD>
> <TD CLASS="title" WIDTH="141" HEIGHT="13">Category</TD>
> <TD CLASS="title" WIDTH="248" HEIGHT="13">Item</TD>
> <TD CLASS="title" WIDTH="91" HEIGHT="13">Quantity
> </TD>
> </TR>
>
> <CFOUTPUT query="equipment">
> <TR>
> <TD CLASS="text" HEIGHT="5">#equipment.ID#</TD>
> <TD CLASS="text" HEIGHT="5">#equipment.category#</TD>
> <TD CLASS="text" HEIGHT="5">#equipment.item#</TD>
> <TD CLASS="text" HEIGHT="5">
>
> <INPUT type="text" name="Item_#id#" SIZE="5" WIDTH="10" value=""
> CLASS="monospace">
>
> </TD>
> </TR>
> </CFOUTPUT>
>
> </FORM>
> </BODY>
> </HTML>
>
> This code will generate a form with over 150 text boxes. The user
> should be able to order more than one item.
>
> Any suggestions on a clever way to process this form would be greatly
> appreciated.
>
> I would hate to hard code Item_1, Item_2, Item_3.....Item_150.
>
> Thanks in advance.
>
> Melisas
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
