According to http://pear.php.net/manual/en/package.database.db-dataobject.db-dataobject.se lectadd.php, you can define which columns you want to return :- "By default a select query will request all items (eg. SELECT * FROM table), to change this behavior you can first call selectAdd() without any arguments to clear the current request and then add the specific items you require. You can also set up a default selection query by adding SelectAdd() method calls in the object constructor method (the one with the same name as the class)" Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Larry Helms Sent: 05 November 2007 11:14 To: php-objects@xxxxxxxxxxxxxxx Subject: Re: PEAR DB_DataObject Pete, I don't use PEAR / DB_DataObject, but it seems to me that that is a logical behavior, since all it seems that you passed to the class/object is the name of a table. Is there a way of specifying columns, and selection criterion by passing those values into the class/object?? ? JUST GUESSING at Syntax here, but something like: $record = DB_DataObject::factory( 'mytable', 'column1, column2, column3', 'column1 <> "0" and column2 <> "" '); You have to think along the lines of how much information you have passed TO the class/object and how it would construct a select statement based on what you have passed to it. Larr. *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
