[thelist] Update on "Update Query not running"

[rudy]

hi chris

today was the first time i'd heard of Replication IDs as datatype for an
msaccess autonumber field, but just bouncing around the help file leads me
to suggest that you try one of the functions defined for converting between
GUIDs and strings

so instead of

   WHERE  user_id
           = <cfqueryparam value="#Request.user_id#"
              cfsqltype="CF_SQL_VARCHAR">

you might try

   WHERE  StringFromGUID(user_id)
           = <cfqueryparam value="#Request.user_id#"
              cfsqltype="CF_SQL_VARCHAR">

i am totally guessing here

but StringFromGUID does work in msaccess (i tested it) so it should work
when built into the query string you pass in through your cf call

rudy
http://rudy.ca/