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]
