[thelist] Update Query not running

Scott Brady evolt at scottbrady.net
Tue Jan 22 14:41:05 CST 2002


Jeff wrote:

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

Yeah, and I've been doing plenty of selects and an insert on this table
already and they work fine (of course, I don't know that any of them used
the user_id in the WHERE clause).

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

I turn debugging on when I'm encountering a problem (because I'm using div's
for the layout, the debugging info [and error messages] show up behind the
content, so it's hard to read), but the query output looks 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.

It's an Auto-Number with a "field size" of "Replication ID" [which is a
GUID].  In the SELECT statements, calling it a cfsqltype of
"cf_sql_longvarchar" seems to work, so you'd think it should work with the
update statement.

Scott
----------------------------------------------
Scott Brady
http://www.scottbrady.net/






More information about the thelist mailing list