Re: Writing a GUID to a SQL table

Tech-Archive recommends: Speed Up your PC by fixing your registry

Bob Barrows [MVP] wrote:
> Phil Kelly wrote:
>>> What do you see when you do this:
>>>
>>> Response.Write vartype(accountguid)
>>
>>
>> This returns an 8 character - a string value?
>>
>>> I'm thinking that you may need to explicitly cast accountguid as a
>>> string before attempting to concatenate it into your dynamic sql
>>> (ugh!) statement. Like this:
>>> accountguid=cstr(accountguid)
>>
>> The problem remains the same when I attempt this!
>>
>>> My suspicion is that an error is occurring when attempting to do
>>> that final concatenation, an error that is being masked by an "on
>>> error resume next" statement, which explains why the ending quote
>>> and closing parenthesis are missing from the result.
>>
>> No 'on error resume next' exists in this code. :(
>
> I've just done some testing and realized you need to trim the final
> two characters from the guid before attempting to use it, like this:
>
> accountguid = left(accountguid,38)

And I suspect this is the reason:
http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/17f9befc31631ca0


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Quantcast