Re: How can I make a simple "SELECT *" with DB_QueryTool_Query

From: 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:
Hi all Im 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.
setSelect('*') 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,
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.

« previous php.pear.general (#21871) next »