I would recommend you build a stored procedure which accesses the view and
in the stored procedure build your select statement to return the dataset I
the order you desire. This is what I do in my project using a Sybase
database.
If you what to be able to change the sort order on the fly in the stored
procedure, it gets a bit tricky, BUt you can still do it.
Stored procedures would be faster, are easy to manage and if your change
management has difficulty accepting stored procedures, then I would say your
change management crew has some serious misunderstandings on how to properly
build a distributed web application.
Casey Kochmer
[EMAIL PROTECTED]
www.jspinsider.com
>From: Dan Lopez <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: JSP/Array/JDBC
>Date: Fri, 8 Dec 2000 07:22:01 -0800
>
>Need Help!
>
>I had been retrieving data from Sybase databse. This
>was working fine. I was querying views created from
>external db outside my sybase environment. I
>displayed the data on JSP page. The only problem is
>that I cannot sort, since the views that were created
>(which I cannot change, since this is out of my
>control...change management, blah!) do not allow SQL
>functions other than "select * from my_view". I would
>like to know if it is possible to put the data into
>variables and place them into an array. Then sort
>using the array. I have never really used arrays
>before.
>
>So, in short:
>1. Can this be done?
>2. HOW is it done?
>
>
>Thanks All
>
>Dan
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Shopping - Thousands of Stores. Millions of Products.
>http://shopping.yahoo.com/
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
>DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_____________________________________________________________________________________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
