A little bit of help please :) - نوشته شده در (1268 Views)
Average Member
Webbo
مطلب: 982
982
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Average Member
cripto9t
مطلب: 881
881
Not sure I understand. Is your sql query coming back empty (0 rows or rsUGMem.eof)?<
    _-/Cripto9t\-_
نوشته شده در
Average Member
Webbo
مطلب: 982
982
It just displays black cells in the columns<
نوشته شده در
Advanced Member
Carefree
مطلب: 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.<
نوشته شده در
Average Member
Webbo
مطلب: 982
982
Nope, that doesn't work. There's two colspans and both relate to displays where there are no members<
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
Change the instances of CColor to strForumCellColor. That'll fix your black background issue.<
نوشته شده در
Average Member
Webbo
مطلب: 982
982
Cheers, that's fixed the cell colour which makes life easier smile
The cells aren't displaying the information I need though -


<
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
نوشته شده در
Average Member
Webbo
مطلب: 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<
نوشته شده در
Advanced Member
Carefree
مطلب: 4224
4224
Here you go: SnitzBitz. Install the database modification first.<
نوشته شده در
Average Member
Webbo
مطلب: 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
<
شما باید یک متن وارد کنید