Grouping and Sub-Totals

QuestionsGrouping and Sub-Totals
Michael Sheppard asked 1 month ago

I’ve just upgraded to the latest version of Grid4PHP and switched from a WAMP-based server to Ubuntu (Apache and PHP 7.3). I am still connecting to a Microsoft SQLServer, however.

I’m now using the¬†Microsoft ODBC Driver 17 for SQL Server. Just about everything is working with minimal changes except for grouping with sub-totals.

I am getting an error (below) and the query seems to be applying a second field to the Order by (a 1).

Error Message:

Microsoft][ODBC Driver 17 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

The end of the query has this:

WHERE 1=1 ORDER BY PROJECT_ID ASC,1 ASC

It appears as though the second order-by clause “1 ASC” is throwing the error and I’m not sure where it is coming-from or how to remove-it. I am also using this on a multiple grid layout, if that makes any difference.

Please let me know if you have any ideas.

Thanks

Mike

1 Answers
Abu Ghufran Staff answered 1 month ago

Hi,

I’ve emailed you latest build to test with, If issue is not resovled, email me code for review.

_________________________
Abu Ghufran - Dev Team
PHP Grid Framework
 
Your Answer

18 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?