spot the deliberate error! but you get the general idea i hope.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- duncan.cumming@alienationde sign.co.uk To: <[EMAIL PROTECTED]> cc: 01/07/03 04:04 PM Subject: Re: [ cf-dev ] checked radio boxes in a loop... Please respond to dev also if you're submitting form fields with the same name, they don't get put into an array; they get put into a list, eg as the code currently is, you might have something like: signed: yes, no, yes, no, yes, yes, no, no if you give each field a unique name based on your loop counter i, you'd instead have: signed1: yes signed2: no etc. could then loop through based on the form.performances field. <cfloop index="i" from="1" to="#Form.Performances#"> <cfquery> INSERT INTO performancesTable (field1, field2, field3, signed) VALUES ('#form.field1#', '#form.field2#', '#form.field3#', ' #form.signed##i#') </cfquery> </cfloop> Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Ian Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]> <ian@futuredr cc: eam.net> Subject: [ cf-dev ] checked radio boxes in a loop... 01/07/03 03:49 PM Please respond to dev Hi. I'm experimenting with loops: you can take a look at the experiment at http://www.artsoutheast.co.uk/diarytest.cfm if you choose more than '1' for the number of performances, you'll notice that only the last set of radio boxes are checked (the 'no' option should be checked for each)... the code's a bit long, but the relevant bit is: <cfloop...> ... Is this performance audio-decribed? Yes: <input type="radio" name="audio" value="yes"> No: <input type="radio" name="audio" value="no" checked> <br><br> Is this performance signed? Yes: <input type="radio" name="signed" value ="yes"> No: <input type="radio" name="signed" value="no" checked> ... </cfloop> any way of getting them all to come out as checked? also, when I submit these performance records, they're going to be turned into an array, no? (don't bother submitting the form - haven't done that bit yet ;-) anyone any ideas how I iterate through the array to write each performence record to a db table? full code below, for anyone that's interested... TIA, any ideas welcome. Ian W <cfset todaydate = Now()> <cfset testday = Day(todaydate)> <cfset testmonth = Month(todaydate)> <html> <head> <title>Untitled</title> </head> <body> <cfif IsDefined("form.perfnumber")> <cfoutput> <form action="#cgi.SCRIPT_NAME#" method="post"> <cfloop from="1" to="#form.perfnumber#" index="i"> Performance: <b>#i#</b> <br><br> Date: <select> <option value="null">month</option> <cfloop from="1" to="12" index="m"> <option value="#m#" <cfif m IS #variables.testmonth#>selected</cfif>> #monthasstring(m)#</option> </cfloop> </select> <select> <option value="null">day</option> <cfloop from="1" to="31" index="d"> <option value="#d#" <cfif d IS #variables.testday#>selected</cfif>> #d#</option> </cfloop> </select> <select> <option value="null">year</option> <cfloop from="2003" to="2005" index="y"> <option value="#y#" <cfif y IS '2003'>selected</cfif>>#y#</option> </cfloop> </select> <br><br> Ticket price: <select> <option value="null">pounds</option> <cfloop from="1" to="30" index="p"> <option value="#p#">#p#</option> </cfloop> </select> <select> <option value="null">pence</option> <cfloop from="01" to="99" index="c"> <option value="#c#">#c#</option> </cfloop> </select> <br><br> Concessions: <select> <option value="null">pounds</option> <cfloop from="1" to="50" index="p"> <option value="#p#">#p#</option> </cfloop> </select> <select> <option value="null">pence</option> <cfloop from="01" to="99" index="c"> <option value="#c#">#c#</option> </cfloop> </select> <br><br> Time: <select> <option value="null">hour</option> <cfloop from="1" to="24" index="hh"> <option value="#hh#">#hh#</option> </cfloop> </select> <select> <option value="null">minutes</option> <cfloop from="1" to="60" index="mm"> <option value="#mm#">#mm#</option> </cfloop> </select> <br><br> Is this performance audio-decribed? Yes: <input type="radio" name="audio" value="yes"> No: <input type="radio" name="audio" value="no" checked> <br><br> Is this performance signed? Yes: <input type="radio" name="signed" value ="yes"> No: <input type="radio" name="signed" value="no" checked> <br><br><br><br> </cfloop> <input type="hidden" name="performances" value="#form.perfnumber#"> <input type="submit" value="submit"> </form> </cfoutput> <cfelse> <form action="#cgi.SCRIPT_NAME#" method="post"> Number of performances: <br> <select name="perfnumber"> <cfloop from="1" to="20" index="m"> <cfoutput> <option value="#m#">#m#</option> </cfoutput> </cfloop> </select> <br> <input type="submit" value="submit"> </form> </cfif> </body> </html> Ian Westbrook, FutureDream Media Limited, (W): www.futuredream.net (E): [EMAIL PROTECTED] (T): +44 (0) 1303 258 985 (M): 07939 510 812 This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding any comments, opinions, information or conclusions expressed in this message are those of the originator, not of FutureDream Media Ltd, unless otherwise explicitly and independently indicated by an authorised representative of FutureDream Media Ltd. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
