Re: Sorting ADO recordset on a nameless field..?

> In an ASP, I am building a recordset from a stored procedure call which
> returns two fields. The first is a straight call to a table column the
second
> is concatenated by a function from several fields (last name, first name,
mi).
>
> i.e. select distinct db.person_id, ns.getNameByPersonId(db.person_id, 'L')
>
> The problem is that this second field is the one I'd like to sort on and
the
> rs.sort requires field name arguments.

Right. So why not give your composite 2nd field a name in your Stored
Procedure?
You can then refer to it in your recordset and sort by it

Stephen Howe


.

Relevant Pages