Yeah, wrap a couple of single quotes around your #trim(url.objectid)#. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -----Original Message----- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 26, 2000 9:29 AM To: CF-Talk Subject: GUUID? 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]
