[thelist] Update Query not running

[.jeff]

scott,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Scott Brady
>
> I've got an Access table where the unique ID is a UID
> and I'm trying to run an update query (using ColdFusion
> 5) on it, for example:
>
>  UPDATE
>   #Request.userTbl#
>  SET
>   email = <cfqueryparam value="#attributes.email#"
> cfsqltype="CF_SQL_VARCHAR">,
>   first_name = <cfqueryparam value="#attributes.first_name#"
> cfsqltype="CF_SQL_VARCHAR">,
>   last_name = <cfqueryparam value="#attributes.last_name#"
> cfsqltype="CF_SQL_VARCHAR">
>  WHERE
>   user_id = <cfqueryparam value="#Request.user_id#"
> cfsqltype="CF_SQL_LONGVARCHAR">
>
> If I take the WHERE clause out, the update runs (of
> course, it runs on every row, but it does run).
>
> With the WHERE clause, the query doesn't update any rows
> (I'm not getting any errors).
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

have you verified that request.usertbl is pointing to the correct table?

do you have debugging turned on and can see the full sql string being sent
to the database?  if so, does it look right?

what's the datatype of the user_id column?  is it varchar or numeric?   if
it's numeric, try a cfsqltype of "cf_sql_numeric" instead.

good luck,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/