Hi William,
Thanks for the input. I'm not familiar with using a variable list. Maybe I'm
making my life difficult by not doing so.
I took your advice and modified my form to:
<form
action="#cgi.SCRIPT_NAME#"
method="post"
enctype="multipart/form-data">
<!--- Our form submission flag. --->
<input type="hidden" name="submitted" value="1" />
<input type="hidden" name="poemID" value="#id#" />
<label class="block" for="Judge"><input name="judge"
id="judge1" type="checkbox" value="judge1">Judge One</label>
<label class="block" for="Judge"><input name="judge"
id="judge2" type="checkbox" value="judge2">Judge Two</label>
<label class="block" for="Judge"><input name="judge"
id="judge3" type="checkbox" value="judge3">Judge Three</label>
<div align="center">
<input class="dlgButton" value="Done" type="submit">
/div>
</form>
This form is submitted and runs this query:
<cfquery name="UpdateJudge" datasource="#request.dsn#">
INSERT INTO PoetryJudges (poemID, judgeID)
VALUES (#form.poemid#, '#form.judge#')
</cfquery>
The database record then captures poemID = 5 and judgeID = judge1, judge2,
judge3 if I select all three judges.
How would I implement a variable list to create an individual record for each
judge? Such as:
poemID=5, judgeID=judge1
poemID=5, judgeID=judge2
poemID=5, judgeID=judge3
Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5215
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
