Did you try WHERE ObjectID = '#Trim(url.ObjectID)#'
best, paul
At 02:29 PM 10/26/00 +0100, you wrote:
>Okay, strange behaviour with a GUUID in a WHERE clause.
>
>I have a GUUID (varname = url.ObjectID) :
>BBD17F3C-9ED3-11D4-845B00E0293D68BB which is in a SQLServer 7 table with
>varchar as a type - length 50 (it is trimmed on return, though not needed)
>
>In my CFQUERY I have thus :
>
> SELECT *
> FROM Objects
> WHERE ObjectID = #Trim(url.ObjectID)#
>
>when it runs, I get this error:
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near
>'D3'.
>
>anyone?
>
>It is probably staring me in the face - like a data type is wrong or an
>apostrophe missing here and there, but I can't see it.
>
>Neil
>
><! -----------------------------------
>Neil Clark
>Senior Web Applications Engineer
>mcb digital
>Tel. +44 (0)20 8941 3232
>Tel. +44 (0)20 8408 8131 [Direct]
>http://www.mcbdigital.com
>----------------------------------->
>
>
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
