sort by a null related field problem

[rus]

hi,
I just have the problem with the sort by a null related field problem.

For example in the tasks list page, I sort the tasks list by the contacts fields (there is some records that has a 'NULL' value).
It show up at the first page, but when I want to go to the second page, it shows "SQL Error : Invalid column name 'isnull'."
Is there any solution for this problem ?

I'm using the SQL Server 2005 and Sugar Community Edition Version 5.0.0b (Build 3150).

regards,
rus

[ptemplin7]

Ummm....

Sounds like a bug, maybe.

That SQL error says the column data is getting confused with the table column name. This is probably a dig into the php and fix issues. Hope one of the php guru's can assist further.

Good luck, Paris