Re: DBIx::Recordset and functions

2002-11-09 Thread Kee Hinckley
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"; --

Re: DBIx::Recordset and functions

2002-11-09 Thread Gerald Richter
> 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

DBIx::Recordset and functions

2002-11-09 Thread Kaare Rasmussen
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 Datatshirts, merchandize Fax:3816 2501 Howitzvej 75