A little bit of help please :) - Posted (1266 Views)
Average Member
Webbo
Posts: 982
982
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Average Member
cripto9t
Posts: 881
881
Not sure I understand. Is your sql query coming back empty (0 rows or rsUGMem.eof)?<
    _-/Cripto9t\-_
Posted
Average Member
Webbo
Posts: 982
982
It just displays black cells in the columns<
Posted
Advanced Member
Carefree
Posts: 4224
4224
Webbo, look for an entry with
Code:
colspan=""3""
a few lines before the
Code:
Case "ViewUsers"
line. Change the 3 to a 5.<
Posted
Average Member
Webbo
Posts: 982
982
Nope, that doesn't work. There's two colspans and both relate to displays where there are no members<
Posted
Advanced Member
Carefree
Posts: 4224
4224
Change the instances of CColor to strForumCellColor. That'll fix your black background issue.<
Posted
Average Member
Webbo
Posts: 982
982
Cheers, that's fixed the cell colour which makes life easier smile
The cells aren't displaying the information I need though -


<
Posted
Advanced Member
Carefree
Posts: 4224
4224
Posted
Average Member
Webbo
Posts: 982
982
Nice one Carefree - works a treat [^]
...on with the next one now, got to add sorting to the 'Renewal Date' column to show dates from earliest to latest and sorting on the 'member name' column to put it back in alphabetical order

If you get bored and want to give it a go, feel free bigsmile<
Posted
Advanced Member
Carefree
Posts: 4224
4224
Here you go: SnitzBitz. Install the database modification first.<
Posted
Average Member
Webbo
Posts: 982
982
Hi Carefree

I got an error when installign the db mod ....
Code:
Adding Column SORTED...
ALTER TABLE FORUM_USERGROUPS ADD SORTED varchar(25) NOT NULL DEFAULT M.M_NAME ASC
ALTER TABLE FORUM_USERGROUPS ADD SORTED varchar(25) NOT NULL DEFAULT M.M_NAME ASC
-2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt] You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'M.M_NAME ASC' at line 1
<
You Must enter a message