Re: Order By using related objects

[prev] [thread] [next] [Date index for 2005/04/13]

On Wed, 2005-04-13 at 11:15 -0700, d. Taylor Singletary wrote:
<snip>
> my @vendors =
> Conquent::Parser::express::DBI::VendorCat->search(catid=>$catid,
> { order_by=>'vndrid->busname' }); 
> 
> But that doesn't seem to me that it would work. Is it possible to do
> this with the order_by argument? Or should I just sort it after I've
> filled the array?

You won't be able to use the order_by argument as you will need to use a
join or sub-query to do the sort in sql. If you will only be getting a
small list back the easiest thing would be to sort the array.
If you want to do it in the database you will will need to create a
custom sql query with the join to do the sort. See the docs for
set_sql() and friends.

mark
--



This email (and any attachments) is intended solely for the individual(s) to whom addressed. 
It may contain confidential and/or legally privileged information. 
Any statement or opinions therein are not necessarily those of ITN unless specifically stated. 
Any unauthorised use, disclosure or copying is prohibited. 
If you have received this email in error, please notify the sender and delete it from your system. 
Security and reliability of the e-mail and attachments are not guaranteed. 
You must take full responsibility for virus checking.



Independent Television News Limited, 

Registered No. 548648 England,

VAT Reg. No: GB 756 2995 81, 

200 Gray's Inn Road, London WC1X 8XZ,

Telephone: 020 7833 3000.