| Author |
 Topic  |
|
funinbc
Junior Member
245 Posts |
 Posted - 15 December 2002 : 17:04:44
|
ok done but now it reads
strSql: 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_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, T.T_ISEVENT strSql2: FROM FORUM_MEMBERS M, FORUM_TOPICS T, FORUM_MEMBERS AS MEMBERS_1 strSql3: WHERE M.MEMBER_ID = T.T_AUTHOR AND T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND T.FORUM_ID = 11 AND (T.T_LAST_POST > '20021115140102' OR T.T_STICKY = 1)strSql4: ORDER BY T.T_STICKY DESC, T.T_LAST_POST DESC
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.
/funforum/forum.asp, line 337
< |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 17:09:03
|
Line 238 needs a comma at the end :
Your code :
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "
should read
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, "
< |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 17:29:05
|
I really appreciate the help but now I get:
strSql: 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_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, T.T_ISEVENT strSql2: FROM FORUM_MEMBERS M, FORUM_TOPICS T, FORUM_MEMBERS AS MEMBERS_1 strSql3: WHERE M.MEMBER_ID = T.T_AUTHOR AND T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND T.FORUM_ID = 11 AND (T.T_LAST_POST > '20021115142223' OR T.T_STICKY = 1)strSql4: ORDER BY T.T_STICKY DESC, T.T_LAST_POST DESC
Microsoft JET Database Engine error '80040e14'
Duplicate output alias 'LAST_POST_AUTHOR_NAME'.
/funforum/forum.asp, line 337
< |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 17:33:40
|
Just for fun after you told me to add the coma I took out your first
suggestion and I got the following error
Microsoft JET Database Engine error '80040e14'
Duplicate output alias 'LAST_POST_AUTHOR_NAME'.
/funforum/forum.asp, line 334
quote:
Originally posted by laser
Oops, sorry about that 
OK, try this .... (it's debugging, no fix yet)
Just before line 333 insert these and paste the output here :
Response.Write("strSql: " & strSql)
Response.Write("strSql2: " & strSql2)
Response.Write("strSql3: " & strSql3)
Response.Write("strSql4: " & strSql4)
< |
|
|
|
funinbc
Junior Member
245 Posts |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 17:41:05
|
OOps, I didn't see the two 'LAST_POST_AUTHOR_NAME' there, sorry !
It looks like you're getting the changes to strSql mucked up, I've gotta run (can't be online 24/7 ), but here's my code for that statement
'## Forum_SQL - Get all topics from DB
strSql ="SELECT T.T_STATUS, T.CAT_ID, T.FORUM_ID, T.TOPIC_ID, T.T_VIEW_COUNT, T.T_SUBJECT, "
strSql = strSql & "T.T_AUTHOR, T.T_STICKY, T.T_REPLIES, T.T_UREPLIES, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, "
strSql = strSql & "T.T_LAST_POST_REPLY_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "
strSql = strSql & ", T.T_ISEVENT "
I will reply when I can ... could be a few hours though< |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 18:02:52
|
ok the board comes up now but it looks odd and I get this error
Microsoft VBScript runtime error '800a0009'
Subscript out of range: 'tT_MSGICON'
/funforum/forum.asp, line 485
have a look
http://www.funinbc.com/funforum/forum.asp?FORUM_ID=11
this is what the line looks like:
line 483 Topic_LastPostAuthorName = arrTopicData tLAST_POST_AUTHOR_NAME, iTopic)
line 484 Isevent = arrTopicData(tT_ISEVENT, iTopic)
line 485 Topic_MsgIcon = arrTopicData(tT_MSGICON, iTopic)
I think we are getting close :-)
< |
Edited by - funinbc on 15 December 2002 18:09:09 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 15 December 2002 : 18:13:14
|
| Looks like the MsgIcon MOD is interfering with this MOD, I can't see the reason at the moment, maybe someone else can help ?< |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 18:57:11
|
one more thing. If I click on topic then I can see the post and reply. looks like everything is working ok.
BUT
if I click on any topic that is when I get the error
< |
|
|
|
red1
Junior Member
355 Posts |
|
|
funinbc
Junior Member
245 Posts |
Posted - 15 December 2002 : 19:28:55
|
Ok I have moved this to the other Mod Help
almost done.............
Thanks Red< |
Edited by - funinbc on 15 December 2002 19:50:03 |
|
|
|
TERM
New Member
82 Posts |
Posted - 16 December 2002 : 22:56:38
|
quote:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/testboard/cal_functions.asp, line 51
I have this error on lots of lines on this page, and cal.asp. Basically anytime I click on anything with the event calendar it tells me another error line or page, but when I look at them, every single line with the error is this
quote:
rs.open StrSql, My_conn
Im sorry if it was answered in this thread, but there is 12 pages and I am pretty busy and dont have too much time to read through it all. Please someone help me.< |
|
|
|
hmmm
Starting Member
35 Posts |
Posted - 23 December 2002 : 21:07:37
|
I would like to be able to turn off the events calendar if you are in a particular group of catagories. How hard would it be to implement this?
There is a session variable for the category group you are in - GROUP_NAME maybe you could just set up a little test that if its one group you include the cal_default page if its another you don't. you could turn off the events for all the forums in the categories that you dont' want it involved with.
Any Ideas? I might like to try to do this one if someone could point me in the write direction?
YAY -I figured out a way. I am running 2 groups - #1 is all the categories not grouped, #2 is the first group, #3 is the second group .in default.asp where is calls up the cal_default.asp -
if (Group = "1") or (Group = "2") then
%>
<!--#include file="cal_default.asp" -->
<%
else
response.write "" & vbNewline
end if
you could set it up for any # of groups to either show or not show.< |
Edited by - hmmm on 24 December 2002 11:49:28 |
|
|
|
jmarkling
Starting Member
Denmark
34 Posts |
Posted - 09 January 2003 : 12:04:20
|
After only an hour I got your Mod Working good job Red1 and u have done a hell of a job in writing an understandble Readme file... love those redlines...
*****************************************************************
Well I would love to expand your calendar... Because I have an other kind of calendar where the data is hidden in a ordinary access-db, Do u think its possible for me to withdraw data from an other table and show it as upcomming events?
BTW my forum is running on a MsSql server...
hp: www.pw3.dk
< |
JEM |
|
|
|
simonduz
Junior Member
161 Posts |
Posted - 09 January 2003 : 16:22:52
|
I read about two thirds of this informative topic.
Does anyone know if you can scubscribe to an event with this MOD.
Thanks.< |
Edited by - simonduz on 09 January 2003 16:23:27 |
|
|
|
Topic |
|
MOD: New Events Calendar for 3.4.03 beta
