I'm building a SQL String and I want to choose only the records that are part of the current contractID.

My Variable
Dim contrID = Request.Params("oId"

I put it into the SQL String
WHERE (JS_CRM.dbo.cntrct_cntct.ContractId = '" & contrID & "')

And I get the error message
Syntax error converting from a character string to uniqueidentifier

How do I convert my string to a uniqueidentifier???

Thanks

"Sandy" <(E-Mail Removed)> wrote in message
news:8BE64355-B0AA-4FBA-B09A-(E-Mail Removed)...
> I'm building a SQL String and I want to choose only the records that are
part of the current contractID.
>
> My Variable:
> Dim contrID = Request.Params("oId")
>
> I put it into the SQL String:
> WHERE (JS_CRM.dbo.cntrct_cntct.ContractId = '" & contrID & "')
> And I get the error message:
> Syntax error converting from a character string to uniqueidentifier.

Is ContractId a GUID? If so, I don't think you need the single quotes around
your variable. If that's not the issue, then you need to check the value of
contrID to make sure it is in fact a valid GUID.

HTH
-
Jeremy

Another possiblity is that you need to setup your SqlParamater properly,
giving it a SqlType = UniqueIdentifier.

"Jeremy Cowles" <jeremy.cowles[nosp@m]asifl.com> wrote in message
news:sSt_b.99256$(E-Mail Removed)...
> Another possiblity is that you need to setup your SqlParamater properly,
> giving it a SqlType = UniqueIdentifier.

Looks like you're not using Parameters, so scratch that.

Hi Jeremy, thanks for responding. You are correct, contactId is a GUID. I removed the single quotes and the error message said Incorrect Syntax.

If you have any other ideas that would be great!

I tried using, but it said couldn't convert string to SqlGuid:

Public Function Parse(ByVal s As String) As SqlGuid

Return s
End Function

"Sandra" <(E-Mail Removed)> wrote in message
news:AA258C1D-BFC1-4072-AFE1-(E-Mail Removed)...
> Hi Jeremy, thanks for responding. You are correct, contactId is a GUID.
I removed the single quotes and the error message said Incorrect Syntax.

So if you step through the code, is the value of your string variable infact
a GUID? I am willing to bet that it is empty or missing part of the GUID.

I actually did a Response.Write(myvariable) to output the variable at the top of the screen so I could see what it is putting in there. It displays exactly as it should be: {F4B7FBB9-29A3-4E22-B778-19CCDAAEBB4F

If I replace my variable with that exact output, it works.