[Cartoweb-users] Calling PEAR DB functions

[Alexandre Saunier]

No problem, I've forgotten (doh!) to say that the $db/$res objects I've 
quoted in my Utils example are PEAR::DB or PEAR::DB_Result objects => 
you may then use them to call fetchRow() or any other PEAR::DB method.
For instance :

Utils::getDb($db, $someValidDsn, $someOptionsArray);
$res = $db->query($sql);
Utils::checkDbError($res, 'Some error message');
while ($row = $res->fetchRow()) {
     // ...
}

Max Ueda wrote:
> Thanks Alexandre and Yves,
> 
> When I wrote this e-mail, I was intending to use
> Alexandre's approach (calling the methods from the
> Utils static class), with Yves' way of calling the
> functions (I need getAll() from PEARDB). 
> 
> I think the right question shouldn't be the way I've
> written (how to access the PEAR DB Methods), but the
> following: Regarding some DB funcions such as 
> fechRow() (I've been using this with no problem), what
> other PEAR DB functions are avaliable at the Utils
> class?
> 
> Thank you!
> 
> Max Ueda
> 
> 
> 
> --- Alexandre Saunier
> <alexandre.saunier at camptocamp.com> wrote:
> 
> 
>>Hello,
>>
>>the solution described by Yves works indeed.
>>But it's faster to use some CartoWeb built-in static
>>methods from the 
>>Utils class. For instance:
>>
>>$sql = '...';
>>$someValidDsn = '...';
>>$someOptionsArray = array(...); // that's the
>>options array from 
>>DB::connect()
>>Utils::getDb($db, $someValidDsn, $someOptionsArray);
>>$res = $db->query($sql);
>>Utils::checkDbError($res, 'Some error message');
>>//...
>>
>>No need to require() or include() any file: the
>>Utils class is always 
>>available.
>>
>>AS
>>
>>Max Ueda wrote:
>>
>>>Hi,
>>>
>>>I've been trying to call some PEAR functions at my
>>>plugins, with no success. How can I have access to
>>
>>the
>>
>>>functions  getOne(),  getRow(),  getCol(), 
>>
>>getAssoc()
>>
>>>and  getAll()?
>>>
>>>Thanks in advance,
>>>
>>>Max Ueda
>>
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users

-- 
Alexandre Saunier
Camptocamp SA
PSE A
CH-1015 Lausanne

+41 21 619 10 19 (direct)
+41 21 619 10 10 (centrale)
+41 21 619 10 00 (fax)