Liberum Help Desk
The free, open source solution for the web-based help desk.

Only 100 problems displayed

rated by 0 users
Not Answered This post has 0 verified answers | 2 Replies | 1 Follower

Top 50 Contributor
6 Posts
Lothian313 posted on 07-02-2009 8:26 AM

MS Server 2003 and MS SQL Server (both standard installs).  Reps only see 100 problems, even when they have more.  Problem pages display the latest problems with the oldest ones not displayed at all.

Is this a helpdesk issue or a SQL Server config problem.  Any help would be appreciated.


All Replies

Top 10 Contributor
75 Posts

I'd start by looking for some setting in sql server that's restricting the number of returned rows.


Doug G

Top 50 Contributor
6 Posts

Hi Doug,

Thanks for the reply.

I decided to look at the asp code myself, since no-one seemed to be interested in the problem (this is the second time I have posted this problem).

In the rep folder, the view.asp file contains the following code at Line 59

 listStr = "SELECT TOP 100, p.title, p.start_date, p.uid, p.uemail, r.uid AS ruid, pri.pname, s.sname " & _

Amending the code to

 listStr = "SELECT, p.title, p.start_date, p.uid, p.uemail, r.uid AS ruid, pri.pname, s.sname " & _

allowed all of the problems to be displayed.

The users view.asp file also contains this code, although the TOP 100 reads TOP 50

Amending the code allows users to see all of the problems they have submitted.

Perhaps the configuration page could be updated to give the administrator the option to change the listStr value?

Thanks again,



Page 1 of 1 (3 items) | RSS
Copyright © Doug Luxem 2000-2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems