Re: How can I make a simple "SELECT *" with DB_QueryTool_Query
| From: | Antonio Luis Batista | Date: | Thu, 10 Nov 2005 16:30:52 +0000 |
| Subject: | Re: How can I make a simple "SELECT *" with DB_QueryTool_Query | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-21871@lists.php.net to get a copy of this message | ||
Lorenzo Alberton wrote:
Antonio Luis Batista wrote:Thanks a lot for the response, I'm using the DB_Querytool just as a SQL generator, I dont connect to the database across it (empty constructor), I use it to create dinamicaly SQL strings and my conection to the DB is carried out by one handle class. I suposse that I will get the all the table fields dinamicaly too when I need the star. Thanks again.Hi all IsetSelect('*') is expanded to the full list of "table.field" values. That's by design, to allow further table joins. There's no "official" way to have "SELECT * FROM foo" back from getQueryString(), apart from the trick you've found (and it may not work in the future). Anyway, why do you need the star? Doesn't the expanded query return the same resultset? Best regards,m using DB_QueryTool_Query to make my sql strings, Ive make some experiments but one thing that I can't do is to put a simple "SELECT * FROM foo" , using $baa->setSelect('*'); dont work, I have achieved to do this with $baa->setSelect(' *') but I want to know if there is other less "tricky" way , more official to do it.