Writing a GUID to a SQL table
- From: "Phil Kelly" <phil.kelly@xxxxxxxxxxxx>
- Date: Tue, 27 Dec 2005 01:25:46 -0000
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
.
- Follow-Ups:
- Re: Writing a GUID to a SQL table
- From: McKirahan
- Re: Writing a GUID to a SQL table
- Prev by Date: Re: Record Locking
- Next by Date: Re: Writing a GUID to a SQL table
- Previous by thread: SQL - Timout Problem w/ Particular Statement
- Next by thread: Re: Writing a GUID to a SQL table
- Index(es):
Loading