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

[Michael Singman-Aste]

Martin, have you tried using "value" in place of the named attribute on
the sort, ie. "Array.Sort(value = AS_ASC)"?

 

Regards,

 

Michael Singman-Aste
Product Manager, OpenROAD
OpenROAD Development
Ingres Corporation 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Bloomfield,
Martin (PSD)
Sent: Monday, May 19, 2008 1:00 AM
To: International OpenROAD Users
Subject: [Openroad-users] Sorting an array on an object column

 

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
<mailto: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/f77ebbb6/attachment.html