This topic is locked

Advanced Search returns wrong results

9/24/2007 4:22:13 PM
ASPRunnerPro General questions
R
rickcalder author

Hi all,
I'm using ASPRunner 5.1 build 319
I sufficiently banged my head against a brick wall on this one, and need to ask for some help.
In my project, I have "User can see and edit their own data only" chosen in Advanced Security and this appears to be working correctly except in one area.
As anticipated, in the list view, only those records belonging to the user are displayed.
When I go to Advanced Search from the list view it allows only those records belong to that particular user to be displayed.
When I select my "Report" from List Page, I'm taken to the Report advanced search page, which I have restricted the user's ability to only select = "Return Date" from a date picker or calendar. This produces a correct report. If one chooses a "Return Date" not belonging to the user, the report page comes up empty and that's fine however an error message would be helpful indicating "No Records Found".
NOW, the problem: I have included a "Chart" button also on the List Page.

From the List Page, once the user has picked "Chart", he's taken to the Chart's Advanced Search page, which is set up the same way as the Report Advanced Search page, and if an existing "Return Date" exists, it produces the chart.
The problem is if they pick a "Return Date" not belonging to them, it still prints out a chart based on the selected "Return Date".
This is my last hurdle to finishing up this project and any help is appreciated.
Thanks

Sergey Kornilov admin 9/26/2007

Rick,
please post your application to Demo Account and send the link with instructions to support@xlinesoft.com.

R
rickcalder author 9/26/2007

Rick,

please post your application to Demo Account and send the link with instructions to support@xlinesoft.com.


Thanks for the speedy reply.
I think I have it worked out. It appears that I had a error in my Chart SQL that caused the problem.

It appears to be working properly now.
When a user selects a "Return Date" not belonging to to the user, the Chart Page is displayed without a chart

with just the Legend Headings.
Is there a way of adding a "No Records Found" message to the Chart Advanced Search page when this occurs?
Thanks again Sergey.

Sergey Kornilov admin 9/27/2007

Yes, you can do this using "Insert ASP code" function.