Re: sort web screen 16 different ways

We do this exact thing and use dbms_sql. Works fine. I set it up so that the Order by is done using the position of the field (ex ORDER BY 2 ) that is passed as a parameter to the procedure. We don't create an intermediate table, we just cycle through each record and dump it to HTML. In article <c5ec7t4lfblc629uqk9596u92jk5kt0lpe_at_4ax.com>,   David Rawding <daverawding_at_mediaone.net> wrote:
> My business user wants to show 16 columns of data on a web screen with
> each column able to be the sort field. I am using plsql in a 7.3.4
> database to generate the web pages. I have been using cursors each
> with a different order by clause with the same "select field1, field2,
> etc from ..... where...." part in other screens with less sort
> options..
>
> Is there a "best" way to code this so I don't have to have 16 cursors
> all defined the same except for the order by clause and 16 if
> statements to open the right one and 16 if statements to fetch the
> right one and so on?
>
> -Dynamic dbms_sql doesn't seem too good since there are so many fields
> to bind to.
> -A plsql table to hold the data would still need to be sorted on the
> right field unless there is a sort function for plsql tables.
>
> Any ideas?
>
> thanks, Dave Rawding
>
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 30 2001 - 16:15:21 CST