A little bit of help please :) - Postet den (1267 Views)
Average Member
Webbo
Innlegg: 982
982
   
 Sidestørrelse 
Postet den
Average Member
cripto9t
Innlegg: 881
881
Not sure I understand. Is your sql query coming back empty (0 rows or rsUGMem.eof)?<
    _-/Cripto9t\-_
Postet den
Average Member
Webbo
Innlegg: 982
982
It just displays black cells in the columns<
Postet den
Advanced Member
Carefree
Innlegg: 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.<
Postet den
Average Member
Webbo
Innlegg: 982
982
Nope, that doesn't work. There's two colspans and both relate to displays where there are no members<
Postet den
Advanced Member
Carefree
Innlegg: 4224
4224
Change the instances of CColor to strForumCellColor. That'll fix your black background issue.<
Postet den
Average Member
Webbo
Innlegg: 982
982
Cheers, that's fixed the cell colour which makes life easier smile
The cells aren't displaying the information I need though -


<
Postet den
Advanced Member
Carefree
Innlegg: 4224
4224
Postet den
Average Member
Webbo
Innlegg: 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<
Postet den
Advanced Member
Carefree
Innlegg: 4224
4224
Here you go: SnitzBitz. Install the database modification first.<
Postet den
Average Member
Webbo
Innlegg: 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
<
Du må legge inn en melding