[thelist] Update Query not running

[.jeff]

scott,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Scott Brady
>
> > 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.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

put a ton of breaks at the end of your page to push the debugging down the
page.

can you paste in a reply the actual sql string being executed please?

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> > 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.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

you'd think, seeing the sql string should help.

thanks,

.jeff

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