Re: quote and null

2004-11-12 Thread Paul DuBois
At 18:08 -0600 11/10/04, Paul DuBois wrote: At 11:35 +1300 11/11/04, Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data

quote and null

2004-11-10 Thread Toro Hill
Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement. The string is returned surrounded by single quotes

Re: quote and null

2004-11-10 Thread Eric Bergen
. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement. The string is returned surrounded by single quotes and with each

Re: quote and null

2004-11-10 Thread Paul DuBois
At 11:35 +1300 11/11/04, Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement. The string

Re: quote and null

2004-11-10 Thread Michael Stassen
Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement. The string is returned surrounded

Re: quote and null

2004-11-10 Thread Michael Stassen
Paul DuBois wrote: At 11:35 +1300 11/11/04, Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement

Re: quote and null

2004-11-10 Thread Paul DuBois
At 21:11 -0500 11/10/04, Michael Stassen wrote: Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data value in an SQL

Re: quote and null

2004-11-10 Thread Michael Stassen
Paul DuBois wrote: At 21:11 -0500 11/10/04, Michael Stassen wrote: Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result that can be used as a properly escaped data

Re: quote and null

2004-11-10 Thread Paul DuBois
At 21:37 -0500 11/10/04, Michael Stassen wrote: Paul DuBois wrote: At 21:11 -0500 11/10/04, Michael Stassen wrote: Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL values. Here is what the mysql manual say: --- QUOTE(str) Quotes a string to produce a result

Re: quote and null

2004-11-10 Thread Michael Stassen
Ah, I see now. That makes sense. Sorry to have been so dense. Michael Paul DuBois wrote: At 21:37 -0500 11/10/04, Michael Stassen wrote: Paul DuBois wrote: At 21:11 -0500 11/10/04, Michael Stassen wrote: Toro Hill wrote: Hi all. I have question about how the function quote() works with NULL