Writing a GUID to a SQL table



Hi and merry Christmas to everyone!

I create a guid using the following code:

accountguid = server.createobject ("scriptlet.typelib").guid

and get it to response.write OK to the screen. However, when I try to write
the accountguid to a sql table using the following:

writeToTable = "INSERT into tbl_users(fld_firstname, "&_
" fld_surname,"&_
"fld_userGUID) " &_
" VALUES ('"& Request.Form("fld_firstname") & "', " &_
" '"& Request.Form("fld_surname") & "', " &_
" '"&accountguid&"' )"

I receive an error. Can anyone tell me why?

Thanks!

Phil


.


Loading