Grouping and Sub-Totals

QuestionsGrouping and Sub-Totals
Michael Sheppard asked 5 days 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 4 days 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

1 + 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 / 5. Vote count:

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

Let us improve this post!