Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 UniqueIdentifier Datatype

Author  Topic 

portrman
Starting Member

24 Posts

Posted - 2001-04-21 : 23:39:31
I am using ASP to query information from SS2k. Using QueryString I grab a number from the url and try to grab a record of info based off a column of type uniqueidentifier. The problem is that the querystring is making it of type tinyint and I get an error message about trying to compare the 2 types. Here is my select statement.

strGeneral = "SELECT PageHeading FROM tblPages WHERE PageUID = " & vPage


"vPage" is the variable from the querystring and "PageUID" is in "tblPages" and is of type uniqueidentifier.

Any ideas? Thanks alot for the help
-Chad



Edited by - portrman on 04/21/2001 23:40:38
   

- Advertisement -