| Author |
 Topic  |
|
gpspassion
Junior Member
260 Posts |
 Posted - 04 September 2006 : 20:20:53
|
| ah, thanks for the pointer, although I'm concerned my basic lack of a clue when it comes to ASP will take me very far, but I'll give it a shot ;-)< |
 |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 11 September 2006 : 17:29:39
|
I'm having the MySQL problem with headlines.asp. I'm sure its in here...
quote:
strSql = "SELECT TOP " & intResults
strSql = strSql & " T.T_REPLIES,"
strSql = strSql & " T.T_SUBJECT,"
strSql = strSql & " T.TOPIC_ID,"
strSql = strSql & " T.T_LAST_POST,"
strSql = strSql & " T.T_AUTHOR,"
strSql = strSql & " T.T_DATE,"
strSql = strSql & " T.T_LAST_POST_AUTHOR,"
strSql = strSql & " T.T_LAST_POST_REPLY_ID,"
strSql = strSql & " T.T_MESSAGE"
strSql = strSql & " FROM " & strTablePrefix & "TOPICS T," & strTablePrefix & "FORUM F"
strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID"
strSql = strSql & " AND F.F_PRIVATEFORUMS = 0 AND "
if request.querystring("show") = "weblogs" or request.querystring("show") = "logs" then
strSQL = strSQL & "T.FORUM_ID = " & strWeblogsForum
else
strSQL = strSQL & "(T.FORUM_ID = " & strNewsForum & " OR "
strSQL = strSQL & "T.FORUM_ID = " & strNewsLinksForum & ")"
end if
strSql = strSql & " AND T.T_STATUS = 1"
strSql = strSql & " ORDER BY T_DATE DESC"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
recActiveTopicsCount = ""
else
allActiveTopics = rs.GetRows(adGetRowsRest)
recActiveTopicsCount = UBound(allActiveTopics,2)
end if
rs.close
set rs = nothing
If someone could help I'd appreciate it.
Also, it was said that you must specify a news forum. Where is this done? Is it just a query string on the url or is it in the file somewhere?
Never mind, the content display mod which I already have will output an xml file that suits my purpose. 
< |
Switch the order of your title tags |
Edited by - bobby131313 on 11 September 2006 20:01:27 |
|
|
|
wildfiction
Junior Member
167 Posts |
Posted - 24 November 2006 : 21:46:57
|
| Quick question. In the RSS.ASP mod it puts the <ttl> element inside the <item> element. Should the <ttl> element not be at the same level as the <item> element? i.e. a sibling and not a child?< |
|
|
|
LeeC
Starting Member
36 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 28 November 2006 : 01:39:30
|
LeeC ; http://oxle.com/source.asp?page=rss.asp still works, but does require you to log in first.
Use demo/demo if you do not wish to register.
[updated]
Sorry guys, it turns out source.asp was available only to mods/admins.
It's changed now, so that all logged on members can access the source.
Sorry for that... < |
portfolio - linkshrinker - oxle - twitter |
Edited by - MarcelG on 29 November 2006 05:37:14 |
|
|
|
wildfiction
Junior Member
167 Posts |
Posted - 30 November 2006 : 12:48:45
|
MarcelG: Changing line 78 to this:
strSql = strSql & "FROM (" & strTablePrefix & "TOPICS T INNER JOIN " & strTablePrefix & "FORUM F ON T.FORUM_ID = F.FORUM_ID) LEFT JOIN " & strTablePrefix & "REPLY R ON T.T_LAST_POST_REPLY_ID = R.REPLY_ID"
will make it more robust for some users.
Thanks for all the work you've done on this!< |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 15 January 2007 : 00:59:00
|
I'm using Gelliotts extension mod and I get the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
'mid' is not a recognized function name.
/inc_func_rsslog.asp, line 64
when browsing to the rssfeed
SQL Server, SSL url< |
Edited by - StephenD on 15 January 2007 01:34:01 |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 24 July 2008 : 17:13:12
|
I installed this yesterday and I'm getting some errors. I fixed most of them (things like changing the encoding type to US-ASCII, author details, etc..) but I still have 2 that I need to fix if someone can help me:
1. Invalid HTML: bad end tag: u'</blockquote id="quote">', at line 1, column 426
I don't know what the u means, but '</blockquote id="quote">' is used at the end of every quoted text in my forum
2. 'ascii' codec can't decode byte 0x92 in position 35141: ordinal not in range(128) (maybe a high-bit character?)
The character highlighted is the quote used here: Frank’s car
< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 25 July 2008 : 00:14:08
|
Anyone ?
My users are using quotes -> ` or ' as they usually do and it's screwing up the feed.
It only seems to be the quote and the end blockquote that is upsetting the feed.< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 25 July 2008 : 00:51:21
|
OK, using some online HTML and RSS references (god I hate corporate firewalls, it would be so much easier to just post the link here  ). I've found by using this site: http://validator.w3.org/feed/check.cgi that:
- I can use utf-8, if ...
- </blockquote id="quote"> is changed to </blockquote> and </font id="quote"> is changed to </font>
Where do I change these tages ?
Then I think it will work.< |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 25 July 2008 : 01:14:18
|
0x92 is Microsoft's Smart Quote possibly running a regex 0x92 to 0x27 would solve the problem.
Article about Smart Quotes
Edit: What was I thinking RegEx for that! I think fString = replace(fString, "0x92", "'", 1, -1, 1) will work< |
Edited by - phy1729 on 25 July 2008 01:19:26 |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 25 July 2008 : 01:17:04
|
quote:
Originally posted by pitstraight
OK, using some online HTML and RSS references (god I hate corporate firewalls, it would be so much easier to just post the link here ). I've found by using this site: http://validator.w3.org/feed/check.cgi that:
- I can use utf-8, if ...
- </blockquote id="quote"> is changed to </blockquote> and </font id="quote"> is changed to </font>
Where do I change these tages ?
Then I think it will work.
You can not make those changes. The forum would be unable to translate the HTML back into forum code unless you want to use a slower regex solution.< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 25 July 2008 : 01:17:54
|
| I tried a Replace earlier but I couldn't get it to work properly. Switching back to utf-8 has fixed it though. I'll have a go at regex if I can't get anything else to work.< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 25 July 2008 : 01:27:20
|
quote:
Originally posted by phy1729
Edit: What was I thinking RegEx for that! I think fString = replace(fString, "0x92", "'", 1, -1, 1) will work
Won't that look for the literal "0x92" ?
Would it work without the " ?
I can't change the code atm so just throwing hypotheticals.< |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 25 July 2008 : 01:33:15
|
| I don't know.< |
Edited by - phy1729 on 25 July 2008 01:33:41 |
|
|
|
Topic |
|
RSS Feed (by forum & by cat)
