[thelist] Update on "Update Query not running"

rudy r937 at interlog.com
Tue Jan 22 17:04:50 CST 2002


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/





More information about the thelist mailing list