Re: field reference question

2004-01-12 Thread Tobias Asplund
On Mon, 12 Jan 2004, Ed Lazor wrote: > Is there an abstract way to refer to field names in a result set? > select ID, Name, Price from Products order by field(1) > where "field(1) would be the abstract way of referring to the specific field to sort > on. ORDER BY # Where # is the number of the c

field reference question

2004-01-12 Thread Ed Lazor
Is there an abstract way to refer to field names in a result set? For example: select ID, Name, Price from Products order by field(1) where "field(1) would be the abstract way of referring to the specific field to sort on. It's for a function that allows me to display tables and sort by colum