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
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
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
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
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
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
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
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
8 matches
Mail list logo