I have a stupid little problem:
I have two fields in my database, studio and name. Studio can be emtpy, name can't. The sort order I want is the following: first all entries where studio is not empty, those sorted by studio ASC. Second all entries where studio is empty, those sorted by name ASC.
The problem is that if I do ORDER BY studio ASC, name ASC, it will put the entries with empty studio fields first, the rest is OK.
Ivan
-----
Iyengar Yoga Resources / GT Plugins
I have two fields in my database, studio and name. Studio can be emtpy, name can't. The sort order I want is the following: first all entries where studio is not empty, those sorted by studio ASC. Second all entries where studio is empty, those sorted by name ASC.
The problem is that if I do ORDER BY studio ASC, name ASC, it will put the entries with empty studio fields first, the rest is OK.
Ivan
-----
Iyengar Yoga Resources / GT Plugins