smb1384
06-15-2006, 04:59 AM
hello, i'm new in coldfusion. now i need a help, how to make an update data using form?
i've tried but have an error said not specify the id, how to specify it.
the code:
<cfif NOT IsDefined("idemployee")><h1>You did not specify the idemployee</h1> <cfabort></cfif>
<cfquery datasource="mysql_info">
SELECT idemployee,stafflogin,email,staff_name,phone,position
FROM employee
WHERE idemployee=#idemployee#
</cfquery>
<table align="center" bgcolor="##99FFCC">
<cfform name="form" action="update_data.cfm" method="post">
<cfoutput>
<input type="hidden" value="#employee.idemployee#">
</cfoutput>
<tr>
<td>Stafflogin:</td>
<td><cfinput type="text" name="stafflogin" value="#Trim(employee.stafflogin)#" required="yes"></td><tr>
<tr>
<td>Email:</td>
<td><cfinput type="text" name="email" value="#Trim(employee.email)#"></td></tr>
<tr><td>Name:</td>
<td> <cfinput type="text" name="staff_name" value="#Trim(employee.staff_name)#"></td></tr>
<tr><td>Phone:</td>
<td> <cfinput type="text" name="phone" value="#Trim(employee.phone)#"></td></tr>
<tr><td>Position:</td>
<td> <cfinput type="text" name="position" value="#Trim(employee.position)#"></td></tr>
<tr><td colspan="2" align="center"> <cfinput type="submit" value="Update" name="update"></td></tr>
</table></cfform> [/COLOR]
i've tried but have an error said not specify the id, how to specify it.
the code:
<cfif NOT IsDefined("idemployee")><h1>You did not specify the idemployee</h1> <cfabort></cfif>
<cfquery datasource="mysql_info">
SELECT idemployee,stafflogin,email,staff_name,phone,position
FROM employee
WHERE idemployee=#idemployee#
</cfquery>
<table align="center" bgcolor="##99FFCC">
<cfform name="form" action="update_data.cfm" method="post">
<cfoutput>
<input type="hidden" value="#employee.idemployee#">
</cfoutput>
<tr>
<td>Stafflogin:</td>
<td><cfinput type="text" name="stafflogin" value="#Trim(employee.stafflogin)#" required="yes"></td><tr>
<tr>
<td>Email:</td>
<td><cfinput type="text" name="email" value="#Trim(employee.email)#"></td></tr>
<tr><td>Name:</td>
<td> <cfinput type="text" name="staff_name" value="#Trim(employee.staff_name)#"></td></tr>
<tr><td>Phone:</td>
<td> <cfinput type="text" name="phone" value="#Trim(employee.phone)#"></td></tr>
<tr><td>Position:</td>
<td> <cfinput type="text" name="position" value="#Trim(employee.position)#"></td></tr>
<tr><td colspan="2" align="center"> <cfinput type="submit" value="Update" name="update"></td></tr>
</table></cfform> [/COLOR]