| Author |
 Topic  |
|
ardsfc
Starting Member
29 Posts |
 Posted - 25 February 2004 : 04:57:14
|
Thanks Gremlin, that's the mistake I made. I created an system DSN and changed the include to simple_slash.asp but now I'm getting this error
ADODB.Recordset error '800a0e7d'
Operation is not allowed on an object referencing a closed or invalid connection.
/comber/forum/inc_func_common.asp, line 214
I'm definitely connecting to the db ok cos the forum works fine.
|
Edited by - ardsfc on 25 February 2004 04:58:34 |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 25 February 2004 : 07:06:33
|
If your using simple_slash.asp you don't need a dsn connection created, it already includes the config.asp file which has your database connection string in it. providing it's loading that config file properly you shouldn't be getting the above error (I think).
is your inc_func_common.asp a standard unmodifed one? |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 25 February 2004 07:08:39 |
|
|
|
ardsfc
Starting Member
29 Posts |
Posted - 25 February 2004 : 08:21:00
|
I had to edit the config file cos I was using a DSN less connection. The config file is in a subfolder (forum) and from the home page it can't find the db unless I use a system DSN.
inc_func_common.asp has never been modified. |
|
|
|
ardsfc
Starting Member
29 Posts |
Posted - 25 February 2004 : 11:18:23
|
Strange, now I get this
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/comber/forum/inc_func_common.asp, line 214
Referencing the 2nd line here
set rsBadWord = Server.CreateObject("ADODB.Recordset")
rsBadWord.open strSqlb, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
|
|
|
|
ardsfc
Starting Member
29 Posts |
Posted - 02 March 2004 : 10:59:00
|
| anyone have any idea? :) |
|
|
|
BoatCaptain
Starting Member
1 Posts |
Posted - 30 March 2004 : 01:59:35
|
I really liked the idea and execution for this mod. Only problem I ran into was the
"Response.End" at the end of the page. Since my entire site is dynamic, it ended responses from the rest of the page early. That was easy to hunt down.
Next, I decided that it did not fit my site format being in the middle so I redid it with a right hand nav bar look. Now my problem was that the mod shows the latest topics, not the most recently posted to topics, so I have to modify the SQL query to include the TOPICS.T_LAST_POST field (which is the last time the topic was responded to). This way I could ORDER BY TOPICS.T_LAST_POST. This game me the last topics that had been replied to instead of the last created topics. Just another way to organize it. You can get take a look the code on my server http://www.pcairsoft.com
The code can be picked up there as well at http://www.pcairsoft.com/inc_posts.txt
I have added some comments to detail what I have done to it that is different from the original. Beware, this may not be what a new person wants to go by. I recommend you know at least a little ASP to understand it. Any questions can be directed to me. Any ideas for a better version can be fired my way as well. Also, I stripped all of the forum specific colors and such since my colors are slightly different from one to the other.
|
"The only stupid question is the one that you didn't ask" - Grand Master John Byrn |
|
|
|
twentythree
Starting Member
USA
22 Posts |
Posted - 11 April 2004 : 22:35:06
|
I'm having the same problem as ardsfc. Basically I made a test page and included simple_slash.asp into it. And it gives me this error: ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forums/inc_func_common.asp, line 406
Here is the link:
http://www.bodyartforms.com/testtopics.asp
Any ideas? This seems fairly simple to implement so I don't know why it's not working for me |
Amanda
Bodyartforms.com |
|
|
|
Oasis2005
Starting Member
3 Posts |
Posted - 20 April 2004 : 02:04:24
|
Hi guys,
I stumbled upon this thread and it appears to answer all of what I have wanted. I basically have a front page I want to show stuff like latest news(from a forum on the board). Also latest posts is a nice feature. I copied the files to my server and put the include file into my frontpage. i kept gewtting a line 47 error. i then tried the Simpleslash file (not inc) and it worked fine and displayed as in:
http://www.imagefile.net/TFTRWebsite/
I still have to change the table values and format it how I want yet though. I cant put the include line in the middle column of my table as it loses the 3rd column and stuffs my formatting. here it is fine though. Also if I change 'Const ForumID' line to anything but 'ANY' I get a 'Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression '(FORUM_FORUM.F_PRIVATEFORUMS = 0) WHERE FORUM_TOPICS.FORUM_ID = 5'.
/TFTRWebsite/forum/simple_slash.asp, line 47
Can anyone help with this. Id like to just display one topic instead of just latest topics also. As for why I cant include the inc_SimpleSlash file i am not sure. |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 20 April 2004 : 04:09:51
|
| Double check your forum ID's looking at your forums your lowest one is about 34 and they go up from there .. just hover your mouse over each forum and lock to see what the forum_id= number is. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Oasis2005
Starting Member
3 Posts |
Posted - 20 April 2004 : 22:39:30
|
You are absoluteluy right-im an idiot.
Thanks for that. Ill check it out and test it. Its a nice little feature though this mod |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 21 April 2004 : 02:44:40
|
| Your welcome :) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Oasis2005
Starting Member
3 Posts |
Posted - 21 April 2004 : 08:12:51
|
I just tried it and get the following error. I just use an access database so its weird
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression '(FORUM_FORUM.F_PRIVATEFORUMS = 0) WHERE FORUM_TOPICS.FORUM_ID = 43'.
/TFTRWebsite/forum/simple_slash.asp, line 47
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 18 May 2004 : 05:05:26
|
sorry to drag this back up, but im trying to add this mod to a page outside of the forum directory, and i thought i had got it after following all of the steps in this thread, but its still giving me an error message, the page is here
http://www.36-degrees.co.uk/index2.asp
|
http://36-degrees.co.uk |
Edited by - stuF on 18 May 2004 07:17:28 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 18 May 2004 : 06:21:43
|
| I don't see any error message? I've actually got a little spare time and have started creating a newer version of this mod (well actually it was never really a mod, i just gave some starter code for people to use and it ended up being fairly popular). |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 18 May 2004 : 07:12:36
|
sorry, i updated that page to be the homepage, try this one: http://www.36-degrees.co.uk/index2.asp
on the last version of my website, i had 7 different pages, all of which pulled data from different forums, one for reviews, one for articles etc. it worked as a decent content management system, and required very little work on my side! |
http://36-degrees.co.uk |
Edited by - stuF on 18 May 2004 07:16:54 |
|
|
|
Topic |
|
Topic Locked
