Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Events Calender Problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  17:44:42  Show Profile
Hi I'm having a bit of the problem with my forum atm:
http://www.thetestingground.co.uk/forum/snitz/

The original error was a <br> that I had accidentially inserted and caused the page not to appear..

But now I'm getting this message :
Microsoft JET Database Engine error '80040e14'

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

/forum/snitz/forum.asp, line 331

Now this is what is in line 331 :

rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic

Any ideas? I have no asp knowledge at all!!

Thanks for all the help so far

Steve D.
Average Member

USA
640 Posts
Posted - 13 May 2003 :  17:47:34  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
in between line 331 and 330 paste the following lines and what is the output?

response.write strSql & strSql2 & strSql3 & strSql4
response.end
Swing Dancing Video Clips - It's All Swing! Forum
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 13 May 2003 :  17:47:39  Show Profile
can you post a link to a text version of forum.asp please?
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  17:51:35  Show Profile
Steve this is the reply:

SELECT T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_VIEW_COUNT, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_REPLIES, T.T_UREPLIES, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, T.T_ISEVENT, FROM FORUM_MEMBERS M, FORUM_TOPICS T, FORUM_MEMBERS AS MEMBERS_1 WHERE M.MEMBER_ID = T.T_AUTHOR AND T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND T.FORUM_ID = 3 ORDER BY T.T_LAST_POST DESC
Go to Top of Page

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  17:53:49  Show Profile
Nikkol heres a text link

http://www.thetestingground.co.uk/forum/snitz/forum.txt
Go to Top of Page

red1
Junior Member

355 Posts
Posted - 13 May 2003 :  17:56:30  Show Profile
Just remove the , after T.T_ISEVENT
My Mods:
New Events Calendar
New Non-database Active Users
Go to Top of Page

Steve D.
Average Member

USA
640 Posts
Posted - 13 May 2003 :  17:59:46  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
but I was about to say that
Swing Dancing Video Clips - It's All Swing! Forum
Go to Top of Page

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  18:01:38  Show Profile
Thanks for all the help people!

I cant get over how quickly you boys respond ... especially to a newbie!!

THanks again for all the help. I really do appreciate it.
Go to Top of Page

Steve D.
Average Member

USA
640 Posts
Posted - 13 May 2003 :  18:03:56  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
That's the great thing about Snitz is the users and how helpful and quick they are!
Swing Dancing Video Clips - It's All Swing! Forum
Go to Top of Page

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  18:25:08  Show Profile
Lets just hope you dont get pissed off with me :) I'm going to be testing a lot of stuff over the next while :)
Go to Top of Page

Gay_Burns
Starting Member

12 Posts
Posted - 13 May 2003 :  18:33:42  Show Profile
In fact I've just found a new problem ... probably not at all related to the last .. but here it is anyways:

http://www.thetestingground.co.uk/forum/snitz/topic.asp?TOPIC_ID=4
Go to Top of Page

Steve D.
Average Member

USA
640 Posts
Posted - 13 May 2003 :  20:02:12  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
double check the edits you made to topic.asp... if you can't find it, post a link to a text version of topic.asp.txt
Swing Dancing Video Clips - It's All Swing! Forum
Go to Top of Page

Steve D.
Average Member

USA
640 Posts
Posted - 16 May 2003 :  11:00:37  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
Any luck?
Swing Dancing Video Clips - It's All Swing! Forum
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07