Goal: Create a page that will fill a dynamic table with past certificates the
user has passed. The user can then have the certificate resent if needed.
Problem: I am running a test where the user has all ready passed 3
certificates, we will call them A, B, and C. When I click on the "resend"
button on the first certificate, the output is ABC, when I click on the
"resend" button on the second certificate, the output is BC, and when I click
on the "resend" button on the third certificate, the output is C. I need only
one certificate output for each button. Then I will be able to pull that
record from the database and resend it to the user.
Ideas: The reason it is doing it is because it is in a loop of some sort by
the dynamic table. I just don't have any idea how to get around it.
Code:
<cfquery name="qRetrieveCertificate" datasource="sonocme">
SELECT primaryKey, nameIssued, eMail, issueDate, testName,
testCategory, namePDF
FROM certificates
WHERE eMail='#COOKIE.Login#'
</cfquery>
<div align="center">
<table width="900" border="0">
<tr>
<th colspan="12"><div align="center">Cerificate
Retrieval</div></th>
</tr>
<tr>
<td><div align="left"><strong><u>Name
Issued</u></strong></div></td><td> </td>
<td><div align="left"><strong><u>Sent
To</u></strong></div></td><td> </td>
<td><div align="left"><strong><u>Issued
on</u></strong></div></td><td> </td>
<td><div align="left"><strong><u>Test
Name</u></strong></div></td><td> </td>
<td><div
align="left"><strong><u>Category</u></strong></div></td><td> </td>
<td><div
align="left"><strong><u>Resend</u></strong></div></td><td> </td>
</tr>
<cfoutput query="qRetrieveCertificate">
<tr>
<td><div
align="left">#qRetrieveCertificate.nameIssued#</div></td><td> </td>
<td><div
align="left">#qRetrieveCertificate.eMail#</div></td><td> </td>
<td><div
align="left">#qRetrieveCertificate.issueDate#</div></td><td> </td>
<td><div
align="left">#qRetrieveCertificate.testName#</div></td><td> </td>
<td><div
align="left">#qRetrieveCertificate.testCategory#</div></td><td> </td>
<td><div align="left">
<cfform name="submitBtns"
preserveData="yes"><cfinput type="submit" name="#qRetrieveCertificate.namePDF#"
value="Resend" />
</cfform>
<cfif
isDefined("FORM.#qRetrieveCertificate.namePDF#")>
<cfoutput>#qRetrieveCertificate.namePDF#</cfoutput>
</cfif>
</div></td></tr><td> </td>
</tr>
</cfoutput>
</table>
</div>
Any ideas on how to get around this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2049
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
