two thoughts
1. What about checking to see if they have already voted during the voting
process and put up a message saying they have already voted. You could then
show them their current vote and ask if they want to change it.
2. If you don't do option 1, can you use a SELECT DISTINCT in your query
based on EmployeeID so you end up with only one vote per employee?
HTH
Stephen
-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 9:03 AM
To: CF-Talk
Subject: CFIF & Conditional Code.
Ok i have a repeat region that shows every one that has voted on an admin
page.
If some one hase vote twice, i want there to be a delete button next to
there name,
for the admin to only delete duplicate data.
i am trying to understand conditional cfif staments to do this.
IF EmployeeID = EmployeedID & AwardsID <> AwardsID then show a delete
button.
that seems simple to me.
but in the master record every empID would Be equal to itself.
so then i should see if its primamry key 'AwardsID' is equal to itself?
IF not show the delete button'?
sounds right.
i am probably missing the logic here.
any advice, would be great.
quickly searching through the wack book.
Thank You
-paul
<!--- All i want to do is to show a DELETE button if the Record has a
Duplicate entry. --->
<CFIF (TotalNum.EmployeeID EQ #TotalNum.EmployeeID#) AND (TotalNum.Awards_ID
NEQ #TotalNum.Awards_ID#)>
<form name="form1" method="POST" action="#MM_editAction#">
<input type="submit" name="Submit" value="Delete Duplicate
Vote">
<input type="hidden" name="MM_delete" value="true">
<input type="hidden" name="MM_recordId"
value="#TotalNum.Awards_ID#">
</form>
</CFIF>
-paul
Web Developer, NBBJ
Work: [EMAIL PROTECTED]
614 241-3534
fax: 614 485-5534
Home: [EMAIL PROTECTED]
614 449-1681
> icq: 47658358
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
