Syntax looks right, but not writing to data base??: msg#00096 cms.cold-fusion.user.azcfug

I must be missing something, the syntax looks right, but obviously there is
something wrong. Need another set of educated eyes. I added the HEY
YOU!! to the code to see if the "CFIF" statement was being satisfied. I
get the HEY YOU!! and my page TITLE on my page where I query and display
the data, but the query for the data just entered is empty. The update
works. It is the CFINSERT for the new record that is not writing. In the
LOCATION for the URL calling and passing the data for the ADDNEW.CFM all
the formfields with the correct data are showing up.

LOCATION:
http://www.az.blm.gov/plats/addnew.cfm?ID=449&RID=37&Receiver=Ravnikar&Requestor=BIA
&Received=02%2F27%2F98&CostCode=1910&ProjectNo=4144&GrpNo=851&T=28&N=N&R=19&E=E
&Projectname=Blue+Bird+Canyon&Specials=2%2F19%2F2000&Assignments=2%2F19%2F2000
&SupAssignments=&Surveyor=Bubel

ADDNEW.CFM

<CFQUERY DATASOURCE="SurveyStatus">
UPDATE request
SET assign='YES'
WHERE ID = #RID#
</CFQUERY>
</CFIF>

<CFIF IsDefined("Receiver")>
<H3>HEY YOU!!</H3>
<CFINSERT DATASOURCE="SurveyStatus" TABLENAME="status"
FORMFIELDS="Receiver, Received, Requestor, CostCode, ProjectNo, GrpNo, T, N, R,
E, ProjectName, Specials, Assignments, SupAssignments, Surveyor">
</CFIF>

<HTML>

<HEAD>
<TITLE>New Project Added</TITLE>

Previous by Date:	ColdFusion Server Pro 4.5 for sale: 00096, Andres Heuberger
Previous by Thread:	ColdFusion Server Pro 4.5 for salei: 00096, Andres Heuberger
Indexes:	[Date] [Thread] [Top] [All Lists]

<Prev in Thread]	Current Thread	[Next in Thread>

Syntax looks right, but not writing to data base???: msg#00096

cms.cold-fusion.user.azcfug