here's my new code. i dont know how to add a "delete" options all i have is edit.. thanks
<cfif IsDefined("URL.From")>
<cfif #URL.From# IS "DoEdit">
<cfquery name="Update" datasource="aileen">
UPDATE sample
SET id = '#form.id#',
first_name='#form.first_name#',
middle_name='#form.middle_name#',
last_name='#form.last_name#',
address='#form.address#',
contact_number='#form.contact_number#',
school='#form.school#'
WHERE id = '#URL.id#'
</cfquery>
</cfif>
</cfif>
<cfif isdefined ("URL.FROM")>
<cfif #URL.FROM# is "DoDelete">
<cfquery name="Delete" datasource="aileen">
Delete id from sample
where id = #URL.id#
</cfquery>
</cfif>
</cfif>
<cfquery name="GetData" datasource="aileen">
SELECT *
FROM sample
ORDER BY id
</cfquery>
<html>
<head>
<title>View Entries</title>
</head>
<body>
<p>Enries are as follows:
<table>
<tr>
<th>ID</th>
<th>first_name</th>
<th>middle_name</th>
<th>last_name</th>
<th>address</th>
<th>contact_number</th>
<th>school</th>
<th></th>
</tr>
<CFIF IsDefined("URL.From")>
<CFIF #URL.From# IS "DoEdit">
<CFOUTPUT QUERY="GetData">
<tr>
<td>#id#</td>
<td>#first_name#</td>
<td>#middle_name#</td>
<td>#last_name#</td>
<td>#address#</td>
<td>#contact_number#</td>
<td>#school#</td>
<td>
<form action="edit.cfm?From=Edit&ID=#ID#" method="post">
<input type="submit" value="Edit">
</form></td>
</tr>
</CFOUTPUT>
<CFELSE>
<CFLOOP QUERY="GetData">
<CFIF #URL.ID# IS #GetData.ID#>
<CFOUTPUT>
<form action="edit.cfm?From=DoEdit&ID=#ID#" method="post">
<tr>
<td><input type="text" name="id" size="4" value="#id#"></td>
<td><input type="text" name="first_name" size="20" value="#first_name#"></td>
<td><input type="text" name="middle_name" size="40" value="#middle_name#"></td>
<td><input type="text" name="last_name" size="20" value="#last_name#"></td>
<td><input type="text" name="address" size="40" value="#address#"></td>
<td><input type="text" name="contact_number" size="20" value="#contact_number#"></td>
<td><input type="text" name="school" size="40" value="#school#"></td>
</tr>
</CFOUTPUT>
<CFELSE>
<CFOUTPUT>
<tr>
<td>#id#</td>
<td>#first_name#</td>
<td>#middle_name#</td>
<td>#last_name#</td>
<td>#address#</td>
<td>#contact_number#</td>
<td>#school#</td>
<td>
</td>
</tr>
</CFOUTPUT>
</CFIF>
</CFLOOP>
</CFIF>
<CFELSE>
<CFOUTPUT QUERY="GetData">
<tr>
<td>#id#</td>
<td>#first_name#</td>
<td>#middle_name#</td>
<td>#last_name#</td>
<td>#address#</td>
<td>#contact_number#</td>
<td>#school#</td>
<td>
<form action="edit.cfm?From=Edit&ID=#ID#" method="post">
<input type="submit" value="Edit">
</form></td>
<td>
<cfform action="edit.cfm?From=Delete&ID=#id#" method="post">
<cfinput name="delete" type="submit" value="Delete" message="are you sure u want to delete?">
</cfform></td>
</tr>
</CFOUTPUT>
</CFIF>
<CFIF IsDefined("URL.From")>
<CFIF #URL.From# IS "Edit">
<tr>
<td colspan="3">
<CFOUTPUT>
<input type="hidden" name="ID" value="#URL.ID#">
</CFOUTPUT>
<input type="submit" value="Update">
</form></td>
</tr>
</CFIF>
</CFIF>
</table>
</body>
</html>
21 Oct, 2007 - 06:41 PM
|