Okay, so I am creating an admin page that lists different sets of the database for possible updates. I know i am going to need some kind of loop (i think) to get this to go through each of many fields and update, but I don't know where to begin!
This is what i have for the form (it is repeated twice for the different options)
CODE
<cfform action="admin2.cfm" method="post">
<table width="80%">
<tr>
<td><strong>Status</strong></td>
<td><strong>First Name</strong></td>
<td><strong>Last Name</strong></td>
<td><strong>Email</strong></td>
<td><strong>Position</strong></td>
<td><strong>Telephone</strong></td>
<td><strong>Ext</strong>.</td>
<td><strong>Fax </strong></td>
<td><strong>Login </strong></td>
<td><strong>Password </strong></td>
<td><strong>ASP Wet Chem </strong></td>
<td><strong>ASP Soybean </strong></td>
<td><strong>ASP Soybean Meal </strong></td>
<td><strong>Study Collaborator NIR </strong></td>
<td><strong>Study Collaborator AAM </strong></td>
</tr>
<cfif appearance is "waiting">
<cfoutput query="waiting">
<tr>
<td><input <cfif (#status# EQ 1)>checked="checked"</cfif> type="checkbox" name="status" size="2" value="#status#"></td>
<td><input type="text" name="first_name" size="8" value="#first_name#"></td>
<td><input type="text" name="last_name" size="8" value="#last_name#"></td>
<td><input type="text" name="email" size="15" value="#email#"></td>
<td><input type="text" name="title" size="8" value="#title#"></td>
<td><input type="text" name="phone" size="8" value="#phone#"></td>
<td><input type="text" name="ext" size="2" value="#ext#"></td>
<td><input type="text" name="fax" size="8" value="#fax#"></td>
<td><input type="text" name="uid" size="8" value="#uid#"></td>
<td><input type="text" name="passwd" size="6" value="#passwd#"></td>
<td><input <cfif (#asp_wc# EQ 1)>checked="checked"</cfif> type="checkbox" name="wc" size="2" value="#asp_wc#"></td>
<td><input <cfif (#asp_sb# EQ 1)>checked="checked"</cfif> type="checkbox" name="sb" size="2" value="#asp_sb#"></td>
<td><input <cfif (#asp_sbm# EQ 1)>checked="checked"</cfif> type="checkbox" name="sbm" size="2" value="#asp_sbm#"></td>
<td><input <cfif (#sc_nir# EQ 1)>checked="checked"</cfif> type="checkbox" name="scnir" size="2" value="#sc_nir#">
<td><input<cfif (#sc_aam# EQ 1)>checked= "checked"</cfif> type="checkbox" name="scaam" size="2" value="#sc_aam#">
</tr>
</cfoutput>
<cfelseif appearance is "new">
<cfoutput query="new">
<tr>
and this is my processing page:
CODE
<title>Admin2</title>
<cfif IsDefined("Form.insertcontacts") is True>
<cfquery name="edit" datasource="sqt_access">
UPDATE contacts
SET
first_name = '#form.first_name#',
last_name = '#form.last_name#',
email = '#form.email#',
title = '#form.title#',
phone = '#form.phone#',
ext = '#form.ext#',
fax = '#form.fax#',
uid = '#form.uid#',
asp_sb = '#form.sb#',
asp_sbm = '#form.sbm',
asp_wc = '#form.wc#',
sc_nir = '#form.nir#',
sc_aam = '#form.aam#',
edited = '1',
status = '#form.status#'
WHERE passwd = '#(form.passwd)#'
</cfquery>
</cfif>
<cflocation url = "admin.cfm">
Please help! Thanks
17 Oct, 2007 - 12:19 PM
| 