You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Kaare Rasmussen <ka...@kakidata.dk> on 2002/11/09 15:49:33 UTC
DBIx::Recordset and functions
Can I select a function with DBIx::Recordset?
E.g.:
SELECT updateRow(1,2,3,4);
??
I would hate to mix DBD with DBIx::Recordset...
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 12.00-18.00 Email: kar@kakidata.dk
2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: DBIx::Recordset and functions
Posted by Gerald Richter <ri...@ecos.de>.
> Can I select a function with DBIx::Recordset?
>
> E.g.:
>
> SELECT updateRow(1,2,3,4);
>
You can do this as long as a table is involed, e.g.
select max(a) as b from foo ;
.... Serach ({...., '!Fields' => 'max(a) as b', ...}) ;
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
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: DBIx::Recordset and functions
Posted by Kee Hinckley <na...@somewhere.com>.
At 3:49 PM +0100 11/9/02, Kaare Rasmussen wrote:
>Can I select a function with DBIx::Recordset?
>
>E.g.:
>
>SELECT updateRow(1,2,3,4);
I don't know if you can do it without setting a table, but this
certainly works:
$$result->Search({'$fields' => 'now() as now'});
print $result->{now}, "\n";
--
Kee Hinckley - Somewhere.Com, LLC
http://consulting.somewhere.com/
I'm not sure which upsets me more; that people are so unwilling to accept
responsibility for their own actions, or that they are so eager to regulate
everyone else's.
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org