Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringA little bit of help please :)

Author : Webbo
Subject : A little bit of help please :)
Posted : 06 February 2009, 18:52
Message :

Reply Author: cripto9t
Replied on: 07 February 2009, 16:40
Message:

Not sure I understand. Is your sql query coming back empty (0 rows or rsUGMem.eof)?<

Reply Author: Webbo
Replied on: 07 February 2009, 16:55
Message:

It just displays black cells in the columns<

Reply Author: Carefree
Replied on: 07 February 2009, 17:03
Message:

Webbo, look for an entry with

Code:

colspan=""3""

a few lines before the

Code:

Case "ViewUsers"

line. Change the 3 to a 5.<

Reply Author: Webbo
Replied on: 07 February 2009, 17:18
Message:

Nope, that doesn't work. There's two colspans and both relate to displays where there are no members<

Reply Author: Carefree
Replied on: 07 February 2009, 17:40
Message:

Change the instances of CColor to strForumCellColor. That'll fix your black background issue.<

Reply Author: Webbo
Replied on: 07 February 2009, 17:54
Message:

Cheers, that's fixed the cell colour which makes life easier

The cells aren't displaying the information I need though -

<

Reply Author: Carefree
Replied on: 07 February 2009, 18:36
Message:

Reply Author: Webbo
Replied on: 07 February 2009, 18:50
Message:

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

<

Reply Author: Carefree
Replied on: 08 February 2009, 15:40
Message:

Here you go: SnitzBitz. Install the database modification first.<

Reply Author: Webbo
Replied on: 08 February 2009, 17:22
Message:

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

<

Reply Author: Carefree
Replied on: 08 February 2009, 18:06
Message:

Put apostrophes around the 'M.M_NAME ASC' for MySql.<

Reply Author: Webbo
Replied on: 09 February 2009, 04:02
Message:

It works a treat Carefree - thanks very much [^]<

Reply Author: Webbo
Replied on: 09 February 2009, 04:27
Message:

Hi Carefree,

If you modifiy your usergroups.asp file, lines 221:222 inclusive with the following code, it will add the ability to private message a member from that page (ideal for notifying when supporters subscription is up for renewal )

Code:


        "             <td nowrap valign=""top"" align=""center"" bgcolor=""" & strForumCellColor & """>" & vbNewline
      Response.Write "                <a href=""privatesend.asp?method=Topic&mname=" & ChkString(arUGMem1(1,UCnt),"display") & """>" & getCurrentIcon(strIconPmprivatemessage,"Send " & ChkString(arUGMem1(1,UCnt),"display") & " a Private Message","align=""absmiddle"" hspace=""0""") & "</a>" & vbNewLine
      Response.Write      "                    <a href=""pop_profile.asp?mode=display&id=" & arUGMem1(0,UCnt) & """ alt=""View Member's Profile"">" & getCurrentIcon(strIconProfile,"View Member's Profile","hspace=""0""") & "</a>" & vbNewline

It just makes life a bit easier

<

A little bit of help please :)

Topic

Replies ...