uniqueidentifier query

surajnshah · #1 (**permalink**) 04-15-10, 14:03

hi there. i need some help with a query please. my table has two fields:

family_id {identity} - uniqueidentifier

family_name - nvarchar

I have a query in my ASP.NET code (in VB.NET) that should compare a family_id as supplied by the user as a string with the family_id in the table and output the corresponding family_name.

My query is as follows:

Code:

Dim UserID As String = New String(Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString())
Dim queryString As String = "SELECT [family_name] FROM tblFamily WHERE ' & [family_id] & ' = ' & UserID & ' ;"

The problem is, that whenever I execute this, it never returns anything.

Thanks in advance for any help you can give me.

gvee · #2 (**permalink**) 04-21-10, 07:56

The issue is your SQL statement - try printing it to screen to see it's value prior to execution.

What you want should be something closer to this...

Code:

"SELECT [family_name] FROM tblFamily WHERE [family_id] = '" & UserID & "'"

P.S. don't forget about SQL injection and what not!

Internet Services

Web Development

Digital Marketing

Consumer Tech