My FeedDiscussionsHashnode Enterprise
New
Sign in
Log inSign up
Learn more about Hashnode Headless CMSHashnode Headless CMS
Collaborate seamlessly with Hashnode Headless CMS for Enterprise.
Upgrade ✨Learn more
Travis Horn

3.6K reads

1 comment

Mark
Mark
Jan 6, 2022

Thanks for the article.

How would one read a column that is a uniqueidentifier

example I have the following ;

objRS.open "select * from [dbo].[tblSMSVerify] where UID = '"& xUID &"' AND SMSGenned = '"& smscode &"'",connObj,2,3,1

UID is a uniqueidentifier column in mssql xUID is a GUID

however I am getting a message as follows ;

Conversion failed when converting from a character string to uniqueidentifier.

Cheers

·