You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Andre Landwehr <an...@gmx.net> on 2002/10/23 17:50:58 UTC

using sql functions with Recordset

Hi,

maybe I'm just to blind but I can't find a way to generate
statements like 
select sum(price) from mytable;
with Recordset. Is that possible?

Andre

--
"The inside of a computer is as dumb as hell, but it goes like mad!"
(Physicist Richard Feynman)


Re: using sql functions with Recordset

Posted by Gerald Richter <ri...@ecos.de>.
Hi,

>maybe I'm just to blind but I can't find a way to generate
>statements like 
>select sum(price) from mytable;
>with Recordset. Is that possible?

$set -> Search({....., '!Fields' => 'sum(price) as sumprice', ...}) ;

Gerald


-------------------------------------------------------------
Gerald Richter    ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting

Post:       Tulpenstrasse 5         D-55276 Dienheim b. Mainz
E-Mail:     richter@ecos.de         Voice:    +49 6133 925131
WWW:        http://www.ecos.de      Fax:      +49 6133 925152
-------------------------------------------------------------


----- Original Message ----- 
From: "Andre Landwehr" <an...@gmx.net>
To: "Embperl List" <em...@perl.apache.org>
Sent: Wednesday, October 23, 2002 4:50 PM
Subject: using sql functions with Recordset




---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org