Gregory Machin wrote:
I tried the following
UPDATE temp SET 'file_content' = REPLACE(file_content, '' ,
'');
but it didn't work, i think thing problem is that the string i need to
replace / null has quotation marks .. how can i work around this
You
#x27; ,
'');
but it didn't work, i think thing problem is that the string i need to
replace / null has quotation marks .. how can i work around this
Many Thanks
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
Web Hosting Solutions
Scalable Linux Solu
4.1.1, if -1 is not put between a quottation mark:
>
> create table testTable (name varchar(10), age smallint default -1);
>
> If the value -1 is changed into '-1', the command works. Is this the
> correct behaviour in 4.1.1 ?
>
> An application here (written by a c
varchar(10), age smallint default -1);
If the value -1 is changed into '-1', the command works. Is this the
correct behaviour in 4.1.1 ?
An application here (written by a colleague) was using numbers
without quotation marks as default values in the create command. The
application
Bill:
What about the DBI's quote() method... isn't this what its for?
http://www.mysql.com/doc/P/e/Perl_DBI_Class.html
Keith
-Original Message-
From: Bill Platt [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 2:25 AM
To: [EMAIL PROTECTED]
Subject: Quotation Mark
On Saturday, 2. March 2002 08:24, Bill Platt wrote:
> Now, my question is this. How do I get the database to accept
> the quotation marks and apostrophes?? The kind of data I am
> entering into the tables is better with these items left in
> rather than left out.
>
Hello Bill,
all
quotation
marks into nulls to get the software to quit triggering the
error.
Now, my question is this. How do I get the database to accept
the quotation marks and apostrophes?? The kind of data I am
entering into the tables is better with these items left in
rather than left out.
Thanks,
Bill
> What is the best way to deal with both single and double quotation marks
> ' "
> when using php and mysql? I seem to be generating a lot of errors due to
> these special characters.
use functions addslashes and stripslashes when inserting and
retrieving, resp.
See ht
What is the best way to deal with both single and double quotation marks
' "
when using php and mysql? I seem to be generating a lot of errors due to
these special characters.
Pieter De Temmerman
[EMAIL PROTECTED]
--