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]
