Haha! Great point. I guess it's time for me to call it a day and get
some sleep :-).
Thanks,
Scott.
On Tue, 08 Mar 2005 18:23:24 -0500, Keith Ivey <[EMAIL PROTECTED]> wrote:
> Scott Klarenbach wrote:
>
> > Is there a flag in MYSQL to automatically escape special characters
> > like single q
Scott Klarenbach wrote:
Is there a flag in MYSQL to automatically escape special characters
like single quotes with a backslash? Instead of using a C API or PHP
addslashes() funciton for each field I'd need to escape?
I don't think you've thought that through completely. How would
MySQL know whi
Is there a flag in MYSQL to automatically escape special characters
like single quotes with a backslash? Instead of using a C API or PHP
addslashes() funciton for each field I'd need to escape?
Thanks,
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
It depends on what language you are using to send the query.
If you are using the shell, 'S\'ARENAL' parses to 'S'ARENAL' before it
is sent to the server.
You will need to escape the escape character.
'S\\'Arenal'
or maybe even 'S\\\'Arenal' or 'S'ARENAL'
It depends on how many parsers scan
> Hi, How can I make a query that looks for a city that has a " ' " in
> the name? For instance, I am looking for the name S'ARENAL, but the
> query below does not work:
>
> SELECT intl_localidades.id, intl_localidades.codigo_pais,
> intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es
Hi, How can I make a query that looks for a city that has a " ' " in the name? For
instance, I am looking for the name S'ARENAL, but the query below does not work:
SELECT intl_localidades.id, intl_localidades.codigo_pais,
intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es FROM
in
At 20:38 -0700 4/21/04, John Mistler wrote:
I could be much clearer:
I understand the backtick character, when used on either side of a string
i.e. `Hello there` will allow the string to be accessed as one unit, even
though there is a space in it. Also, it will allow for `Hello-there` to be
acces
At 13:38 -0700 4/21/04, John Mistler wrote:
When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I
understand that if you surround a variable with "\\`" it will allow for
characters such as - and space. Will it also allow for all other
non-alphanumeric characters such as / and * a
TECTED]>
Sent: Wednesday, April 21, 2004 4:38 PM
Subject: Escape characters
> When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I
> understand that if you surround a variable with "\\`" it will allow for
> characters such as - and space. Will it also allow fo
When issuing commands through the terminal (in Mac OS 10.3) to MySQL, I
understand that if you surround a variable with "\\`" it will allow for
characters such as - and space. Will it also allow for all other
non-alphanumeric characters such as / and * and >, etc.?
Thanks,
John
--
MySQL Gener
Yes...
You can just use \' to denote single quotes..
See: http://www.mysql.com/doc/S/t/String_syntax.html
Gurhan
- Original Message -
From: "Theodore Morse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 11:48 AM
Subject: escape ch
Hello everyone!
I have an SQL insert statement that contains "'" symbols in it, however
as I use the "'" symbol to denote the differences between columns in the
VALUES(...) part, I was wondering if there was another way of doing it
so I could include more characters like "'" in the statment, a s
So, then even if you make a quote function that's too much work?
On Monday 19 November 2001 03:21 pm, berndt wrote:
> Problem with this unfortunately though is that i have probably 100+ sql
> queries spread over several hundred cfm pages to find and change. Plus if i
> ever want to go back to ms
Problem with this unfortunately though is that i have probably 100+ sql
queries spread over several hundred cfm pages to find and change. Plus if i
ever want to go back to ms sql i have to switch them all back again.
Dave
At 05:07 PM 11/19/2001 -0500, you wrote:
>>>2. a coldfusion function to ma
>>2. a coldfusion function to make the sql statements "safe".
You only have to escape like 3 characters. ', ", and \. You could just
do 3 string replacements or create your own function to perform 3 string
replacements.
Chris
--
Hi,
I am currently trying to hack some coldfusion code into submission, and
success grows closer and closer by the minute. But what would make my life
INFINITELY easier would be to be able to disable all escape characters in
varchars and other similar column types. Basically I am porting from
16 matches
Mail list logo
