Access Database will not update

[KJ Klosson]

I've got CF7 running on WinXP SP2 with Access 2000 database. Very simple table
- 4 fields, all text except the Key. I can view, I can Insert, but I can't
update. No error is thrown. I am using cfupdate with formfields attribute. I
gave up using SQL Update because I kept getting errors from Access ODBC even
though I felt the sentax was correct. I would appreciate any ideas.

Thanks

[mxstu]

Can you post some code?

>I gave up using SQL Update because I kept getting errors from Access ODBC

even

>though I felt the sentax was correct.

That probably means it is not correct ;-) or perhaps you're using reserved
words as column names.

[KJ Klosson]

Thanks, and yes I have tested that the action for is in Edit mode...

FIRST IS THE USER FORM...

<cfset EditMode=IsDefined("form.userid")>
<cfif EditMode>
<cfquery name="getuser" datasource="#application.datasource#">
Select * FROM User WHERE UserID=#form.userid#
</cfquery>

<cfset userid=#getuser.userid#>
<cfset last=TRIM(getuser.last)>
<cfset first=TRIM(getuser.first)>
<cfset telephone=TRIM(getuser.telephone)>
<cfset ext=TRIM(getuser.ext)>
<cfset email=TRIM(getuser.email)>
<cfset role=TRIM(getuser.role)>
<cfset opmnumber=#session.opm#>
<cfset tabtext="Edit-" & #first# & ' ' & #last#>
<cfelse>
<cfset last="">
<cfset first="">
<cfset telephone="">
<cfset ext="">
<cfset email="">
<cfset role="">
<cfset opmnumber=#session.opm#>
<cfset tabtext="New User">
</cfif>

<cfform name="userform" width="400" height="500" format="flash"
action="UserFormAction.cfm"
method="post">
<cfformgroup type="tabnavigator">
<cfformgroup type="page" label="#tabtext#">
<cfinput type="text" name="last" value="#last#" width="150" label="Last
Name:" required="yes">
<cfinput type="text" name="first" value="#first#" width="150" label="First
Name:" required="yes">
<cfinput type="text" name="telephone" value="#telephone#"
label="Telephone:" required="yes"
width="150" tooltip="Example: 800-555-1212 24">
<cfinput type="text" name="ext" value="#ext#" label="Ext.:" required="no"
width="50">
<cfinput type="text" name="email" value="#email#" label="Email:"
width="250" validate="email" message="Must be an email address." required="yes">
<cfinput type="checkbox" name="emailcredentials" checked="true"
label="Email credentials to user">
<cfinput type="hidden" name="opmnumber" value="#opmnumber#">
<cfif EditMode>
<cfinput type="hidden" name="UserID">
</cfif>
</cfformgroup>
</cfformgroup>
<cfinput type="submit" name="submit" value="Save">
</cfform>


THEN THE ACTION FORM...

<cfinclude template="usermenu.cfm">
<cfset EditMode=IsDefined("form.userid")>
<cfif editmode>
<cfupdate datasource="#application.datasource#" tablename="User"
formfields="UserID,Last,First,Telephone,Ext,Email" >
<cfset action="Updated">
<cfelse>
<cfinsert datasource="#application.datasource#" tablename="User"
formfields="Last,First,Telephone,Ext,Email">
<cfset action="Added">
</cfif>

[mxstu]

> <cfinput type="hidden" name="UserID">
Don't you need to give the form field a value?

[KJ Klosson]

Your right. Thank you!