Re: To quote or not to quote?
| From: | Unknown Sender | Date: | Mon, 09 Oct 2000 19:02:45 +0000 |
| Subject: | Re: To quote or not to quote? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3439@lists.php.net to get a copy of this message | ||
On Mon, 9 Oct 2000 joe@jWebMedia.com wrote:
> Why won't addslashes() work?
Thanks for the tip, but I don't see how that helps. I'm not trying to
escape the special characters here. I'm trying to determine whether a
field is of a type whose values need quotes.
For instance, fields of type CHAR(20) need quotes, as in
select price from products where code = "abc-123"
However, fields of type INTEGER don't need quotes:
select name from employees where id = 123
I'd like a reliable way to tell whether or not I need to quotes.
--
Patrick Doyle
doylep@eecg.utoronto.ca