Re: Quote String

Paul DuBois wrote: > > At 11:19 AM +0200 7/3/01, Tomas V.V.Cox wrote: > >Sorry for not to follow the thread but I recently have suscribed to the > >list. Please test this patch to the pear/DB/mysql.php, so if works I'll > >commit the change to the quote string behavoir. The same for the sybase > >extension. > > > >For the question about null values I don't see any way for inserting > >them, but the needed change in executeEmulateQuery() for supporting it > >is trivial. What do you think to add the unquoted NULL string when the > >null (constant) value is given? > > Personally, I think that's the corrrect behavior. But on the other hand, > it wouldn't be so difficult to make quoteString() do that to, such that: > > quoteString("a") => "'a'" > quoteString (null) => "NULL" > Yeah, great idea, but it will require a little more work. Hope to have some time in the next days to start with it, if noone have anything more to say. > That's how the quote() method in DBI works. (Am I allowed to say that > here? :-) Sure Pear DB has taken many ideas from DBI. But remember what people say about perl: "Perl is the only language that looks the same before and after a RC5 encryption" ;) Tomas V.V.Cox