Re: QueryTool questions

On Monday 15 September 2003 3:14, Wolfram Kriesing wrote: > Rob Hutton wrote: > > You would have to do _construct(&$dsn) for this to work, otherwise a copy > > of the DB object is passed, not a reference, and a new connection may or > > may not be created (depending on the state when it was passed). Also, > > this would require that the DSN is a variable which would break BC. I > > would recommend instead that a setDBConnection(&$dbCon) or similar > > function be added and the $dsn parameter to _construct be made > > optional... > > yeah, right. thanks for this hint. i think it would have broken my apps > too :-) It sounds perfect to me. -Jackson > > > Thanks, > > Rob > > > >>-----Original Message----- > >>From: Wolfram Kriesing [mailto:lists@kriesing.de] > >>Sent: Monday, September 15, 2003 2:13 PM > >>To: Jackson Miller > >>Cc: PEAR > >>Subject: Re: [PEAR] QueryTool questions > >> > >>Jackson Miller wrote: > >>>I have two questions about QueryTool > >>> > >>>1) Could a line be added to _construct to allow for using an > >> > >>existing DB > >> > >>>object. > >>>Something along the lines of: > >>>if (DB::isConnection($dsn)) { > >>> // use that connection > >>>} else { > >>> if ($autoConnect) { > >>> $this->connect($dsn); > >>> } > >>>} > >>> > >>>The reason I ask for this is that it would make my life using > >> > >>QueryTool within > >> > >>>my application API classes a lot easier. On a high traffic > >> > >>site I really > >> > >>>want to keep DB connections to a minimum. > >> > >>of course this is possible, i will add it. i remember that that was on > >>my todo anyway. sorry for being so slow :-) > >> > >>>2) how do you set the LIMIT part of a query. Is that the getMultiple > >>>function? I ask becuase the documentation is a little lacking > >> > >>in that area. > >> > >>either use > >> setLimit(<start>,<count>); > >> getAll(); > >>or > >> getAll(<start>,<count>) > >> > >>getMultiple() is actually an extension to get(). > >>get($id) gets the row for the given $id, where $id is compared to the > >>primary column. And getMultiple($ids) works for multiple number of IDs. > >> > >> > >>-- > >>Wolfram > >> > >>http://opensource.visionp.de > >> > >>... authentication system .... > >> http://sf.net/projects/auth > >> > >>-- > >>PEAR General Mailing List (http://pear.php.net/) > >>To unsubscribe, visit: http://www.php.net/unsub.php > > -- > Wolfram > > http://opensource.visionp.de > > ... authentication system .... > http://sf.net/projects/auth -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 jackson@coldfeetcreative.com     cold feet presents Emma the world's easiest email marketing Learn more @  http://www.myemma.com