Now Now Paul, no need to be condecending!.....just cos you've risen to the dizzy heights of talking at a CFUG!.....which reminds me...I'll see you there later!...make sure you tell em everything we taught you at TB! ------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 26 October 2000 14:54 To: CF-Talk Subject: RE: GUUID? - The only reply that needs to happen Oh, let me see... Tough one... Oh! Have you tried putting apostophes round the variable (it being a varchar and all!)? Paul PS Expect about 20 more replies like this one! > -----Original Message----- > From: Neil Clark [mailto:[EMAIL PROTECTED]] > Sent: 26 October 2000 14:29 > 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] ------------------------------------------------------------------------------------------------ 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]
