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]
