Using a guid in a SQL SELECT statement
Posted on 2006-06-11
I am trying to do a search for records in SQL that have a userID of the current logged in user. I have set the SessionUID to the GUID of the user logged in. When I use this select statment I get
Operator '&' is not defined for string " SELECT count(PhotoId) AS imagec" and type 'Guid'.
SELECT count(PhotoId) AS imagecount FROM Photos WHERE UserID = '" & Session("SessionUID") & "'"