[Openroad-users] Sorting an array on an object column

[Bloomfield, Martin (PSD)]

Fellow OR gurus,

I am building an application that contains an array of data.  One of the
attributes of this array is Company details (Name, address etc).  This
information is stored in a User Class (it's used in lots of places in
the application).  In order to produce a report, I need to be able to
sort the array on one of its "normal" attributes (a varchar) and the
Company name.  I know that this cannot be done directly as I get an
error when I try to sort on the column (specified as either
column.co_name or just column).

I thought I've done this before, but cannot remember how I did it.  Is
there any clever workaround, or am I going to have to create a dummy
column in my array to store a duplicate of the company name purely for
sorting?  Obviously I don't want to do this if I can avoid it due to the
overhead in keeping the data synchronised.

Any ideas gratefully received,
Martin Bloomfield. 
_________________________________________________ 
Application Developer & Database Administrator 
IT Branch, 
Pesticides Safety Directorate, 
Mallard House, 
Kings Pool, 
3 Peasholme Green, 
YORK, 
YO1 7PX 
Email: martin.bloomfield at psd.hse.gsi.gov.uk 
Tel: (01904) 455783     GTN: 5138 5783 
Fax: (01904) 455711 
Website: www.pesticides.gov.uk <http://www.pesticides.gov.uk/>  
P Save a tree... please don't print this e-mail unless you really need
to 



 

PSD joined the Health and Safety Executive on 1st April 2008. All email addresses changed to firstname.surname at psd.hse.gsi.gov.uk from that date.  Email sent to the previous addresses will continue to be delivered until at least September 2008, but please update your mailing lists or contacts as soon as you can to reflect the change.
__________________________________________________________________

**********************************************************************************************
Please Note: Incoming and Outgoing E-mail messages are routinely monitored for compliance with our policy on the use of electronic communications.

Interested in Occupational Health & Safety information?
Please visit the HSE website at the following address to keep yourself up to date

www.hse.gov.uk

Or contact HSE Infoline on 0845 345 0055 or email hse.infoline at natbrit.com

**********************************************************************************************


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080519/7e271ca1/attachment.html