JPDeni, you have pointed out to me on several occations that I have (sort by) setup wrong.
I understand that sort by should be set to a field number of the database. However, on my databases if I try to use &sb=0 it doesn't appear to work properly. To get my sort to work I have to use &sb=ID which seems to work fine, why I don't know and I think it is time to find out why.
Here is some setup info:
$db_key = 'ID';
$db_key_track = 1;
%db_def = (
ID => [0, 'numer', 3, 5, 1, '', ''],
Headline => [1, 'alpha', 45, 100, 1, '', ''],
Description => [2, 'alpha', '45x10', 5000, 1, ' ', ''],
LinkTitle => [3, 'alpha', 15, 40, 0, '', ''],
LinkURL => [4, 'alpha', 45, 255, 0, '', '^http://'],
PostTime => [5, 'date', 20, 20, 1, &get_date, ''],
PostedBy => [6, 'alpha', 30, 35, 1, 'Larry', ''],
Verified => [7, 'alpha', 0, 3, 1, 'Yes', 'Yes|No'],
UserID => [8, 'alpha', -2, 15, 0, '', '']
);
Try both sorts on this database and you will see why I use &sb=ID instead of &sb=0. I may have a problem elswhere but I am thinking it has something to do with the 0 (zero) being used for some reason it breaks.
http://www.makeitsimple.com/...ec ords=View+Records
Sort by &sb=0 looks like it works but it breaks sort order by descend and changing it to ascend doesn't help.
Very interesting, basicly I quit working on figuring out why because &sb=ID works. Although, I do think it would be a good idea to figure out why this is happening.
------------------
Larry "NgtCrwlr" Mingus
www.makeitsimple.com
I understand that sort by should be set to a field number of the database. However, on my databases if I try to use &sb=0 it doesn't appear to work properly. To get my sort to work I have to use &sb=ID which seems to work fine, why I don't know and I think it is time to find out why.
Here is some setup info:
$db_key = 'ID';
$db_key_track = 1;
%db_def = (
ID => [0, 'numer', 3, 5, 1, '', ''],
Headline => [1, 'alpha', 45, 100, 1, '', ''],
Description => [2, 'alpha', '45x10', 5000, 1, ' ', ''],
LinkTitle => [3, 'alpha', 15, 40, 0, '', ''],
LinkURL => [4, 'alpha', 45, 255, 0, '', '^http://'],
PostTime => [5, 'date', 20, 20, 1, &get_date, ''],
PostedBy => [6, 'alpha', 30, 35, 1, 'Larry', ''],
Verified => [7, 'alpha', 0, 3, 1, 'Yes', 'Yes|No'],
UserID => [8, 'alpha', -2, 15, 0, '', '']
);
Try both sorts on this database and you will see why I use &sb=ID instead of &sb=0. I may have a problem elswhere but I am thinking it has something to do with the 0 (zero) being used for some reason it breaks.
http://www.makeitsimple.com/...ec ords=View+Records
Sort by &sb=0 looks like it works but it breaks sort order by descend and changing it to ascend doesn't help.
Very interesting, basicly I quit working on figuring out why because &sb=ID works. Although, I do think it would be a good idea to figure out why this is happening.
------------------
Larry "NgtCrwlr" Mingus
www.makeitsimple.com