First method is to pass a scalar ref as one column (it will fall directly in
SQL).
$rs->search(undef,{
select=>['id', \'round((julianday(date2) - julianday(date1))*86400)'}],
as => [('id',lastdate')],
});
2007/3/19, rahed <[EMAIL PROTECTED]>:
Hi,
I'd like to use a database function from SQLite which should produce
this select:
select id,round((julianday(date2) - julianday(date1))*86400) as 'tdiff'
from mytable;
I know I can search the resultset and specify the source for my column
value as a function but don't know how to use the above more complex
query with several functions.
e.g. $rs->search(undef,{
select=>['id',{somefunction=>'date2'}],
as => [('id',lastdate')],
});
Any suggestions?
Thank you.
--
Radek
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive:
http://www.mail-archive.com/[email protected]/
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
