Re: how escape special in a field - fixed ( null plus something = ? )

2004-12-13 Thread Wolfram Kraus
arenko > <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Mon, 13 > Dec 2004 13:44:42 +0200 Subject: Re: how escape special in a field > > >> Hello. >> >> See: >> http://dev.mysql.com/doc/mysql/en/mysql_real_escape_string.html >> >> Can you sen

Re: how escape special in a field - fixed ( null plus something = ? )

2004-12-13 Thread YW CHAN (Cai Lun e-Business)
hing equal null.. -- Original Message --- From: Gleb Paharenko <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Mon, 13 Dec 2004 13:44:42 +0200 Subject: Re: how escape special in a field > Hello. > > See: > http://dev.mysql.com/doc/mysql/en/mysql_real_escape_string.html &g

Re: how escape special in a field

2004-12-13 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/mysql_real_escape_string.html Can you send complete test for your problem? "YW CHAN (Cai Lun e-Business)" <[EMAIL PROTECTED]> wrote: > Hi, > > I find there seems problem with this select statement when there is a special > character i

how escape special in a field

2004-12-12 Thread YW CHAN (Cai Lun e-Business)
Hi, I find there seems problem with this select statement when there is a special character inside the table. i.e. select concat(field_1, ',', field_2) as name where ... field_2 actually is something like 'George, Banson' ( with a comma in between ) i guess this , destroy the SQL syntax. I