G
Guest
Hi. I'm a sorta novice ASP programmer, so I sure could use some help
from of you more experienced gurus....
I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'
It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW.
The 15 blank
3A
3B
5B
6A
7D
I would like it to show as:
3A
3B
5B
6A
7D
The 15 blank
I tried using the DESC keyword, but as I imagined, the results were:
7D
6A
5B
3B
3A
The 15 blank
So, can anyone help me out here? I hope I've made everything clear
enough.
from of you more experienced gurus....
I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'
It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW.
The 15 blank
3A
3B
5B
6A
7D
I would like it to show as:
3A
3B
5B
6A
7D
The 15 blank
I tried using the DESC keyword, but as I imagined, the results were:
7D
6A
5B
3B
3A
The 15 blank
So, can anyone help me out here? I hope I've made everything clear
enough.