Re: Catalyst - SQL query

[one4k4]

As fmerges mentioned above, subselects may not work yet. What about something similar to a multi-step query then?

select max(RecordTime)
from tbl_loan
where UserId = 2
Group By LoanId

...get that $var.

select *
from tbl_loan
where RecordTime = ?

...

$db->execute($var);

Just a few cents, may or may not help. Just offering the idea that maybe you have to workaround it and take it as two steps.

[megaurav2002]

Thanks ! Your answer makes sense to me. It can work for me with little modification. Can you please tell me which module does $db->execute($var) belongs to? Regards

[one4k4]

Oh, I apologize. $db->execute was a reference to your database handle created via the DBI module. But what I was really trying to mention was the idea of using two separate queries. :)