Hi,

I have DNN3.0.13 running and have installed SQLView for DNN3.

Everything appears to work fine with the grid apart from Paging.

The simple query I am running, based on the Northwind Traders database,  is:

SELECT TOP 100 FirstName, LastName, Title
FROM Employees
ORDER BY LastName ASC

I can sort fine and apply/change the CSS but can't get the grid to page.

Something else I've noticed is that the grid does not display more than 9 rows per page even. It does, however, display the correct no of rows for a row setting less or equal to 9.

Any help would be greatly appreciated.

Saaki

PS: Does anyone have an example of how to run a SQL stored procedure using SQLView?

 

Saaki,

I'll look into that issue you are having. Make sure if you use sorting, that you provide the ORDER BY clause in the separate Order by field and not directly in your SQL query.

In your example, your query should be: SELECT TOP 100 FirstName, LastName, Title FROM Employees
and the order by portion should be LastName ASC. Perhaps this is affecting the paging.


Here's a sample of how to run a stored procedure using SQLView,

GetSiteLog8 [dnn:portalid],'','2005-1-1','2005-12-31'

Yes, I'm sure the ORDER BY statement goes in the ORDER BY clause and not at the end of the SELECT statement.

 

The other thing I've noticed is that setting the SQL View to numeric paging only returns a value 1. Should return 10 if selecting the TOP 100 and rows per page is set to 10.

Saaki

Saaki,

The Employees table in my Northwind database only has 9 rows in it, so you will never get more than 9 rows returned :)

Try running against the Customers table. It has 91 records and you'll see the paging works fine. Phew, you had me worried there for a moment.

Richard

Hi Richard,

I can't tell you how foolish I look now.

Thanks for pointing that out to me & apologies for taking up your time.

Saaki