2. ASPRunnerPro General questions
  3. Rows not displaying
This topic is locked

Rows not displaying

 		4/30/2009 8:06:20 PM
ASPRunnerPro General questions
R
 Rhoffman author

I have just moved to a new server. Same OS, etc as the old server.
One of my views is not displaying all the rows returned from the query. It shows 3,695 records found. On the first page 2 rows will be displayed even though it is to be listing 20. The next pages can show anywhere from 0 to 20 records.
The data is there and looking at the results I cannot see where any significant differences are between records displaying and those that are not.
Any thoughts?
J
 		Jane 5/5/2009

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
R
 		Rhoffman author 5/15/2009

Actually, I have noticed that it only happens on our production server. Windows 2003 with IIS 6 and SQL Server 2005.
R
 		Rhoffman author 5/23/2009

I have determined the issue, but not a resolution.
I am using an SQL View that has a join to a table that does NOT have matching records to the parent table. A trigger in the SQL Server takes care of creating the record if any fields in the child table are edited.
What I have noticed is that the rows not displaying do not have a record in the child table. The view works on our old server and on the development server, but not our new production server. The only difference I see is that we are running a 64 bit version of windows 2003 as opposed to a 32 bit version.
Any thoughts as to why ASP would not display those records?
Rudy
Sergey Kornilov admin 5/25/2009

Rudy,
ASPRunnerPro doesn't know anything about triggers. It displays all data SQL query returns.
I believe this is the matter of finding and installing proper SQL Server drivers on your new box.
R
 		Rhoffman author 5/26/2009

I know the issue is not the triggers and not the driver (same on all servers). The issue is ASP. It gives the correct count of records returned, but only displays the rows where records are in both tables. Again, works fine on all but this one server.
Sergey Kornilov admin 5/27/2009

64bit Windows probably requires you to install a 64bit driver.
I believe you need to contact Microsoft support directly. Probably this is a common issue with 64bit Windows ASP/SQL Server applications.