I am creating a web poll. I need assistance with putting poll result vote
count values in MS Access.
Already got the database created with one record & all I need is a count for
each option they pick. Option1, Option2, Option3, and etc. No other records
need to be added. Just need the one row record to be updated with the + 1
increment count based on which option they choose. Below is the code that I
have so far........
Access Demo Fields
Option1 Option 2 Option 3
Vote Count 0 2 5
When user chooses Option1 I want code to make option1 field to +1 to the vote
to make it 1, 3 for option2 if selected and etc.
<form name="tshirt_poll" action="" method="post">
<table width="349" height="281" align="center" cellpadding="10" cellspacing="0">
<tr>
<td width="282"> <div align="center">T-Shirt #1 </div></td>
<td width="25"><input type="radio" name="TshirtOption" value="T-Shirt 1">
</td>
</tr>
<tr>
<td> <div align="center">T-Shirt #2 </div></td>
<td><input type="radio" name="TshirtOption" value="T-Shirt 2"> </td>
</tr>
<tr>
<td> <div align="center">T-Shirt #3 </div></td>
<td><input type="radio" name="TshirtOption" value="T-Shirt 3"> </td>
</tr>
<tr>
<td> <div align="center">T-Shirt #4 </div></td>
<td><input type="radio" name="TshirtOption" value="T-Shirt 4"> </td>
</tr>
<tr>
<td> <div align="center">T-Shirt #5 </div></td>
<td><input type="radio" name="TshirtOption" value="T-Shirt 5"> </td>
</tr>
<div align="center">
<div align="center"></div>
<tr>
<td align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</div>
</table>
</form>
<cfif TshirtOption IS "T-Shirt 1">
T-Shirt #1 is Selected
</cfif>
<cfif TshirtOption IS "T-Shirt 2">
T-Shirt #2 is Selected
</cfif>
<cfif TshirtOption IS "T-Shirt 3">
T-Shirt #3 is Selected
</cfif>
<cfif TshirtOption IS "T-Shirt 4">
T-Shirt #4 is Selected
</cfif>
<cfif TshirtOption IS "T-Shirt 5">
T-Shirt #5 is Selected
</cfif>
</body>
</html>
Thanks!
Scott Clayton
Programmer/Analyst
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5347
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
