| Author |
 Topic  |
|
laser
Advanced Member
Australia
3859 Posts |
 Posted - 07 August 2004 : 17:33:39
|
OK, just as I suspected : nice SQL for Access, but it won't work for mySQL (so says me  I've never used mySQL before), but anyway try these 2 steps and see what happens :
We need to change the SQL statement to work with mySQL. The statement is constructed in the 10-15 lines above your error line. Try this :
1. Find where it says "TOP 15" and remove just those characters.
2. Find where it says "T_LAST_POST DESC" and after that add a space and then "LIMIT 1, 15" making sure there is a space between DESC and LIMIT. There might also be a " directly after DESC, make sure this comes after 15.
Let me know how you go ... |
 |
|
|
ukcw
Junior Member
121 Posts |
Posted - 08 August 2004 : 04:29:03
|
OK,
The format seem all different to how you were describing, so
In the end have deleted this line:
strSql = "SELECT TOP " & intResults
and added
strSql = strSql & " LIMIT 1,15" after the line strSql = strSql & " ORDER BY T_LAST_POST DESC"
There still seems to be the same error - perhaps someone needs to re-write the .asp file to make it work with MySql? Any further thoughts?
Thanks for your help :-) |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 08 August 2004 : 08:46:52
|
Oops !!! .. you REALLY need that SELECT, so just add that line back, but instead of :
strSql = "SELECT TOP " & intResults
add it in as :
strSql = "SELECT " |
|
|
|
ukcw
Junior Member
121 Posts |
Posted - 09 August 2004 : 18:12:13
|
Hi laser
Perhaps a success... :-) I think it seems to be working...take a look now and see what you think - the only problem I have now is that I want to actually format the output to work in with my site - any ideas how I would do that? Is it complicated? Also, does the output look right to you? It looks like it has some HTML tags in there...
One other question....where I changed this code...
quote:
The format seem all different to how you were describing, so
In the end have deleted this line:
strSql = "SELECT TOP " & intResults
and added
strSql = strSql & " LIMIT 1,15" after the line strSql = strSql & " ORDER BY T_LAST_POST DESC"
Is it OK to leave it like that, or should I change it back?
Thank you for your help :-)
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 10 August 2004 : 07:34:55
|
LOL! .. You've caught up to me in the knowledge stakes  I'm just thinking about formatting the output for my site BUT what you have now is the proper format for an RSS reader, which is the whole aim of the file. The HTML tags might be a problem, but grab an RSS reader and you'll see how it should look.
Don't change it back, you now have the mySQL SQL statement correct. |
|
|
|
aspwiz
Junior Member
250 Posts |
Posted - 13 August 2004 : 15:07:11
|
We just whacked RSS all over the place on our forums.... works well!
http://www.webforumz.com
It's on the main forums page, as well as forum.asp
I did slightly modify the code a little!!
Next up.... a feed for articles (RSS Mod for portal mod!!) |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 13 August 2004 : 19:34:35
|
I like the site design  |
|
|
|
aspwiz
Junior Member
250 Posts |
Posted - 13 August 2004 : 20:53:40
|
thanks!
That wasn't my doing though.... that'll be Sirkent (at our forums)... he's pretty ace at design. |
|
|
|
ukcw
Junior Member
121 Posts |
Posted - 30 August 2004 : 10:33:35
|
Hi all again
I've managed to get an rssfeed.asp output...you can see it here: http://www.ukcc.jireh.org/forum/rssfeed.asp
Several things are still a problem...
Firstly, the html code in the descriptions is still appearing as html code for some reason - any ideas?
Secondly, the script times often times out when I try to pull the rssfeed into another website - any ideas...the error is this:
quote:
Active Server Pages error 'ASP 0113'
Script timed out
/index3.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
It seems to be taking a long time to retrieve the information.
Lastly, how do I customize the output for display on the other website?
Any help greatly appreciated :-) |
Edited by - ukcw on 03 September 2004 10:06:03 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 19 September 2004 : 07:24:13
|
Richard,
Is there any way of changing this so it shows the last message with say the f1rst 120 letters of the message. I would like to get the feed happening properly on my front page.quote:
Originally posted by RichardKinser
we have a rss feed here on this forum: http://forum.snitz.com/forum/rssfeed.asp
I have got the rss feed being converted to to be shown, but it will not get the description part happening.
|
Cheers,
David Greening |
|
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
Posted - 18 October 2004 : 19:12:24
|
I'm working a little on this mod.
I was trying to find a piece of code that can format a posting date into the RFC822 date format that must be used in the RSS XML files.
Can anyone help? |
Best regards,
Erik P. Ernst
Microsoft Business Solutions User Group, webmaster,
Microsoft MVP - Navision
|
|
|
|
eernstbmi
Junior Member
Denmark
113 Posts |
|
|
joshua_f
Starting Member
1 Posts |
Posted - 20 October 2004 : 23:43:19
|
hi all
I tried beznas rss feed and it works great. only problem is I want to display all new posts in all forums on my Site.
I've searched and I've searched but I couldn't find it.
Can anybody help me out, please??
Link to my RSS Feed:
http://www.roombaforum.ch/rss.asp
edit: Or could someone please explain what I didn't understand here? |
Edited by - joshua_f on 23 October 2004 02:05:23 |
|
|
|
Gargoyle
Junior Member
USA
280 Posts |
|
|
beznas
Starting Member
Morocco
23 Posts |
Posted - 05 November 2004 : 09:39:46
|
Josh
Find the line that says
sql = "SELECT TOP " & strTop & " * FROM " & strTablePrefix & "TOPICS WHERE FORUM_ID = " & xmlForum & " ORDER BY T_DATE DESC"
Replace it with:
sql = "SELECT TOP " & strTop & " * FROM " & strTablePrefix & "TOPICS WHERE F_STATUS = 1 ORDER BY T_DATE DESC"
This will display the latest topics from all your public forums.
quote:
Originally posted by joshua_f
hi all
I tried beznas rss feed and it works great. only problem is I want to display all new posts in all forums on my Site.
I've searched and I've searched but I couldn't find it.
Can anybody help me out, please??
Link to my RSS Feed:
http://www.roombaforum.ch/rss.asp
edit: Or could someone please explain what I didn't understand here?
|
Free Palestine! |
|
|
|
Topic |
|
Topic Locked
