Re: sql hell

2002-11-19 Thread Jochem van Dieten
Tony Weeg wrote: > #Evaluate(’)# > > if i put that in the middle of the sql code in the cfquery tag...i get > this errorare these unicode values for those characters? > > "\u00e2\u20ac\u2122," on line 73, column 71, is not a valid identifer > name. Yes, that is a unicode translation. \ is the

Re: sql hell

2002-11-19 Thread Jochem van Dieten
Tony Weeg wrote: > XP - OS > USA My House - OS locale > SQL Server 2000 - RDBMS > No Idea? - database encoding > CFMX ODBC - driver > No Idea? - charset settings with your driver > CFMX? - template encoding > None. - usage of setEncoding() > None. - usage of cfprocessingdirective > None. - usage o

RE: sql hell

2002-11-18 Thread Tony Weeg
eg [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 8:57 PM To: CF-Talk Subject: RE: sql hell XP - OS USA My House - OS locale SQL Server 2000 - RDBMS No Idea? - database encoding CFMX ODBC - driver No Idea? - charset settings with your driver CFMX? - template encoding None. - usage of s

RE: sql hell

2002-11-18 Thread Tony Weeg
l Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 8:49 PM To: CF-Talk Subject: Re: sql hell Tony Weeg wrote: > > select line, id from seatBeltLaws where line like '%’%' > > > why can i put that same query in q

Re: sql hell

2002-11-18 Thread Jochem van Dieten
Tony Weeg wrote: > > select line, id from seatBeltLaws where line like '%’%' > > > why can i put that same query in query analyzer, get 24 records that > have some of those freakin characters contained within, however when i > run it in a the above cf code, i get nothing? You forgot to m

Re: sql hell

2002-11-18 Thread Antony Sideropoulos
Just a WAG: It maybe that the odbc driver is not passing those characters through to the database correctly. > > > select line, id from seatBeltLaws where line like '%’%' > > >why can i put that same query in query analyzer, get 24 records that >have some >of those freakin characters conta

RE: sql hell

2002-11-18 Thread Rob Rohan
PROTECTED]] Sent: Monday, November 18, 2002 5:35 PM To: CF-Talk Subject: sql hell select line, id from seatBeltLaws where line like '%’%' why can i put that same query in query analyzer, get 24 records that have some of those freakin characters contained within, however when i run i

sql hell

2002-11-18 Thread Tony Weeg
select line, id from seatBeltLaws where line like '%’%' why can i put that same query in query analyzer, get 24 records that have some of those freakin characters contained within, however when i run it in a the above cf code, i get nothing? WTF!! ...tony tony weeg [EM