All,
I have a template that performs an insert on my db. This page is called by
another template with some form fields (Duh!). The problem is that IE comes
back with a 404 error, however the update IS performed but the cflocation is
not executed.
code samples (beware of the wrap monster):
Query.cfm
---------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
Inserting....
<CFINSERT tablename="Tbl_Pledge" datasource="TKE" username="xxxxxxxx"
password="xxxxxxxxx" formfields="pFirst_Name, pLast_Name, Address, City,
State, Zip_Code, Phone, Pager, BB_Scroll, Status, Notes, Entered_By,
Date_Entered">
<CFLOCATION url="Officers_Pledge.cfm&Success=True">
Insert Finished, redirecting...
</body>
</html>
Calling Template <Snip>:
-------------------------------------------------
<CFFORM action="Query.cfm" method="POST" name="Add">
<Table cols="3">
<tr>
<td><B>First Name</b></td>
<td><B>:</b></td>
<TD><CFINPUT name="pFirst_Name" type="Text" required="Yes" message="You MUST
enter a FIRST name."></td>
</tr>
<tr>
<td><b>Last Name</b></td>
<td><B>:</b></td>
<td><CFINPUT name="pLast_Name" type="Text" required="Yes" message="You MUST
enter a LAST name."></td>
</tr>
<tr>
<td><B>Address</b></td>
<td><B>:</b></td>
<td><CFINPUT name="Address" type="Text" required="Yes" message="You MUST
enter a STREET ADDRESS."><BR><CFINPUT name="City" type="Text" required="Yes"
message="You MUST enter a CITY." size="10">, <CFINPUT name="State"
type="Text" required="Yes" message="You MUST enter a STATE" size="3"
value="GA"> <CFINPUT name="Zip_Code" type="Text" required="Yes"
message="You MUST enter a ZIP CODE." size="6"></td>
</tr>
<tr>
<td><B>Contact Phone</b></td>
<td><B>:</b></td>
<td><CFINPUT name="Phone" type="Text" required="Yes" message="You MUST enter
a CONTACT PHONE NUMBER."></td>
</tr>
<tr>
<td><B>Pager Number</b></td>
<td><B>:</b></td>
<td><CFINPUT name="Pager" type="Text"></td>
</tr>
<tr>
<td><B>Big Brother's Scroll</b></td>
<td><B>:</b></td>
<td><CFINPUT name="BB_Scroll" type="text" required="Yes" message="You MUST
enter the BIG BROTHER'S SCROLL NUMBER."></td>
</tr>
<tr>
<td><B>Status</b></td>
<td><B>:</b></td>
<td>Active</td>
</tr>
<tr>
<td><B>Notes (200 Char.)</b></td>
<td><B>:</b></td>
<td><CFINPUT name="Notes" type="Text" maxlength="200"></td>
</tr>
<tr>
<td align="left"><INPUT type="Submit" name="Submit" value="Add"></td>
<td></td>
<td align="right"><INPUT type="Reset" name="Reset" value="Clear Form"></td>
</tr>
</table>
<CFOUTPUT>
<INPUT type="Hidden" name="Status" value="Active">
<INPUT type="Hidden" name="Entered_By" value="#Session.User#">
<INPUT type="Hidden" name="Date_Entered" value="#CreateODBCDate(Now())#">
</cfoutput>
</cfform>
Thanks for any sugestions!!!
-Kevin
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
