Ok, I took that out, now my action page is saying the my
recordID is not defined, but it is.
This is what I am using now:
<cfset admin = "False">
<cfparam name="variables.ID" type="integer"
default="#url.RecordID#">
<cfparam name="variables.Fname" default="">
<cfparam name="variables.Lname" default="">
<cfparam name="variables.userName" default="">
<cfparam name="variables.password" default="">
<cfparam name="variables.email" default="">
<cfparam name="variables.admin" default="">
<cfif url.RecordID GT 0>
<cfquery name="useRec"
datasource="#APPLICATION.dataSource#">
SELECT user.Fname, user.Lname, user.userName, user.password,
user.email, user.admin, user.ID
FROM user
WHERE user.ID =<cfqueryparam value="#URL.RecordID#"
cfsqltype="cf_sql_integer">
</cfquery>
<cfif useRec.RecordCount EQ 1>
<cfset variables.RecordID = useRec.ID>
<cfset variables.Fname = useRec.Fname>
<cfset variables.Lname = useRec.Lname>
<cfset variables.userName = useRec.userName>
<cfset variables.password = useRec.password>
<cfset variables.email = useRec.email>
<cfset variables.admin = useRec.admin>
</cfif>
</cfif>
<head>
<body>
<cfoutput>
<cfform action="action.cfm" method="post" name="useRec"
id="useRec" enctype="multipart/form-data">
<input type="hidden" name="variables.ID"
value="#url.RecordID#">
<input type="text" name="Fname" value="#variables.Fname#"
maxLength="150">
<!--- more inputs and submit buttons here --->
</cfform></cfoutput>
</body>
this is my action page now:
<cfif not IsDefined("FORM.admin")>
<cfset IsAdmin= 0>
<cfelse>
<cfset IsAdmin= 1>
</cfif>
<cfif url.RecordID eq 0>
<cfquery datasource="#APPLICATION.dataSource#"
dbtype="ODBC">
INSERT INTO user
(Fname, Lname, userName, password, email, admin)
VALUES (<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Fname#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Lname#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.userName#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.password#">,
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.email#">,
<cfqueryparam value="#IsAdmin#"
CFSQLType="CF_SQL_INTEGER">)
</cfquery>
<cflocation url="indexUser.cfm">
<cfelse>
<cfquery datasource="#APPLICATION.dataSource#"
dbtype="ODBC">
UPDATE user
SET user.Fname=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Fname#">,
user.Lname=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.Lname#">,
user.userName=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.userName#">,
user.password=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.password#">,
user.email=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#form.email#">,
user.admin =<cfqueryparam value="#IsAdmin#"
CFSQLType="CF_SQL_INTEGER">
WHERE ID =<cfqueryparam value="#form.RecordID#"
cfsqlType="CF_SQL_INTEGER">
</cfquery>
<cflocation url="indexUser.cfm?RecordID=#Form.RecordID#"
addtoken="no">
</cfif>
I had it working... but then I made some other changes and it
made things work better, until this issue. here is my error:
Element RECORDID is undefined in URL.
The error occurred on line 17 action.cfm.
What am I doing wrong. This is driving me crazy, Not like it
is my first form I wrote, I am missing something and can't figure
it out.