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)  minor asp problem with GUID's

Author  Topic  huge Starting Member 31 Posts Posted - 2001-08-16 : 14:21:59 Hey guys, OK I have this asp page that has an include file which basically logs the user in. If he is not logged in (currently) it takes his unique GUID (which is fetched and generated from another include page) and logs him in based on his username and password. So basically here are the different variables: 1) SID (GUID) all users regitered or not get this on the home page from an include file. This same include file is attached on every page to make sure the SID is there and is right, if not it fetches the right one. 2) UserID, every registered user gets a unique UserID that identifies his record. 3) username / password all users have one and is in a relationship with UserID. I could have used only username and SID but this way is more practical (even longer story, heh) Now here comes the problem in my registration page, again, it has an incldue file to the page that assigns and verifys SID and an include that checks if userID is logged in. To ckeck if the user if logged the page passes the SID to a sproc and it verifys. However Everytime I access the page this error comes up: Syntax error converting from a character string to uniqueidentifier. If I refresh the page it works fine, its only on the first time accessing when your not logged in. I hope I didnt confuse anyone thanks for any help I will clarify anything that needs to be. Thanks again Mike M