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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-15 : 07:03:18
|
| Homer writes "Greetings,I have been all over the web, this site, and others, trying to identify how one would query an SQL table where the column contains a specific GUID. I am using Coldfusion to pass the statement to MS SQL 7.0 however I do not receive any result tho I know it exists. Here is an example of the code:<cfquery name="get" datasource="XXXXX" username="XXXXXXXXXX" password="XXXXXXXX">SELECT * FROM sqltable WHERE messageID = '{2D564B6A-BD74-4587-A0BD-FFF7B4BC1C4A}'</cfquery><cfoutput>#get.field#</cfoutput>This does not return an error however it does not return a result either. The specified GUID definitely exists and the link to the table is active.Thanks for any assistance you may be able to provide.Homer Dokes" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-08-15 : 07:34:23
|
| Hi!Lose the {}SELECT * FROM sqltable WHERE messageID = '2D564B6A-BD74-4587-A0BD-FFF7B4BC1C4A'should work. |
 |
|
|
|
|
|
How to query GUID Columns in an SQL table