×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DSOs to display Oracle queries in HTML dataviews...

DSOs to display Oracle queries in HTML dataviews...

DSOs to display Oracle queries in HTML dataviews...

(OP)
I'm trying to use Silverstream (3.1) datasource business objects to execute large custom SELECTs on an Oracle 8i (8.1.5) server, displaying the results in an HTML dataview on a page. My SELECT is constructed by user input of criteria, and passed to a results page, where the dataview invokes the DSO with the SELECT. The results are displayed in the dataview, which has a rows-per-page limit activated and scrolling emulation ON. The user should be able to scroll down through their query results page by page.

The problem is that the data view can only ever display two pages of result rows, no matter the number of rows which should be returned by my query. Further scroll-down clicks repeatedly display the second page of rows and go no further. The view seems to fetch from the DSO only enough rows to fill two pages, whether the row-per-page limit is set to 50, 1000, whatever.

I can't find any property or method (of either the dataview class or the DSO class/interfaces) in the documentation which increases the rows available for paging by the view. Anyone had similar problems ?

Thanks in advance...

RE: DSOs to display Oracle queries in HTML dataviews...

Hi,

I've had this problem and it's certainly a bug. You have to program yourself the navigation in the HTML View !

Ciao

RE: DSOs to display Oracle queries in HTML dataviews...

I ran into this issue as well.  However, we found that it is not a problem with the view but an issue of where you invoke the DSO.  If you are invoking the DSO in your PageRequestBegin method it will initialize the dataset EVERY time your page is redrawn.  Move the invocation to the PageLoaded method or any event driven method and the problem will be resolved.

Hope that helps

tone

RE: DSOs to display Oracle queries in HTML dataviews...

You're right, it's not a bug ! But invoke the query in the page loaded event doesn't make the data very dynamic ...

Ciao

RE: DSOs to display Oracle queries in HTML dataviews...

No it does not make it very dynamic, that is why I said "or any event driven method."  This will make the data dynamic.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close