| Author |
 Topic  |
|
pethson
Starting Member
Sweden
19 Posts |
 Posted - 14 October 2002 : 14:14:58
|
When viewing the calendar in weekly view I see the following error on Tuesday (this done on monday, that is I don't know if it is day two from the day I view or if it is always tuesday)
Microsoft VBScript runtime error '800a01a8'
Object required: 'rs'
/forum/cal.asp, line 333
Thats when I am loged in as a created user with Admin rights or the Forum owner Admin.
When logging in as a regular user it works fine.
The code looks like
326 '### Get the Events for this day only ###
327 if intEventsforWeek > 0 then
328 rs.filter = ""
329 rs.filter="T_EVENT_DATE='" & DateToStr(dateCursor) & "'"
330 end if
331
332 '### Loop through the recordset to find the events for this date ###
333 if rs.EOF then
334 Response.Write "<P><FONT face=" & strDefaultFontFace & " size=" & strDefaultFontSize & " color=" & strForumFontColor & ">"& strCalNoEvents & "</FONT></P>"
335 else do while not(rs.EOF)
336 Topic_ID = rs("TOPIC_ID")
337 Topic_Subject = rs("T_SUBJECT")
338 Topic_Message = rs("T_MESSAGE")
339 Topic_Author = rs("T_AUTHOR")
340 Forum_ID = rs("FORUM_ID")
341 Topic_Status = rs("T_STATUS")
342 Event_Date = StrToDate(rs("T_EVENT_DATE"))
343 Cat_Moderation = rs("CAT_MODERATION")
344 Forum_Moderation = rs("F_MODERATION")
345 Member_Name = rs("M_NAME")
346
347 '########### Check for access ###########
///Peter!
< |
 |
|
|
mcain004
Starting Member
USA
15 Posts |
Posted - 14 October 2002 : 15:05:58
|
I am also getting the error:
Microsoft VBScript runtime error '800a01a8'
Object required
/forum/cal.asp, line 349
I have checked through the forum but none of the previous fixes have worked that I could try. The cal.txt file links are not working.
Line 349 for me is:
347'### Get the Events for this day only ###
348 if intEventsforWeek > 0 then
349 rs.filter = ""
350 rs.filter="T_EVENT_DATE='" & DateToStr(dateCursor) & "'"
351 end if
352
353 '### Loop through the recordset to find the events for this date ###
This is about the last error I can find. Again this only appears when viewing by the week in admin mode.
When i got in with a test account the week views fine.
I downloaded the most recent zip 34-beta_612.zip.< |
|
|
|
red1
Junior Member
355 Posts |
Posted - 15 October 2002 : 09:35:10
|
The fix I posted for this was just a temporary one, because I still can't figure out what's causing the bug  For those of you having problems with weekly view, here's an alternate cal.asp that you can use:
http://b.domaindlx.com/nohoho/cal.txt
It'll be a few months before I can resume working on this mod again. Maybe in a future release I can finally fix all these bugs and add all your suggestions. I'm thinking of finally adding repeating & multi-day events, an admin page, event registrations, and limiting which forums the events can be posted to.
I need a moderator to lock this topic now pls.< |
|
|
|
MichaelA
Junior Member
USA
222 Posts |
Posted - 15 October 2002 : 21:51:09
|
So this is going to stay as a beta with no release? I'd like to use it but I'm concerning about a beta release. This MOD looks great. PLEASE make a BIG announcement when you are back and working on this MOD. Thanks.
Mike
< |
|
|
|
claus_mikkelsen
Starting Member
Denmark
48 Posts |
Posted - 16 October 2002 : 03:31:31
|
Hi' there
Looks fine, you re-scripting of the events calendar mod... and quite easy to install. Except for one little item.. One of the modifications in the post.asp-file somewhat conflicts with previous installed mods.. When you have the Poll mod ver. 2.0 installed one of your modifications should be made in an area that controls the textarea of the posting form. Here the scripts checks whether to make a poll or a posting in general.
So how do make it consider the three posibilities: general posting, an event or a poll
Best regards
Claus< |
This posting have been created entirely by recycled bytes! |
|
|
|
goldfish
New Member
82 Posts |
Posted - 16 October 2002 : 05:40:29
|
Can I just say a big thanks to Red1 for all his help and the mod in general. I don't think he realised what a demanding bunch we all are when he started, but this is an excellent mod, that does exactly what it says on the tin. Hopefully others will be able to help in the community as well to improve it further in Red's absence, but in the meantime, cheers fella! 
Simon< |
|
|
|
padawan
Junior Member
200 Posts |
Posted - 16 October 2002 : 11:40:01
|
quote:
Originally posted by goldfish
Can I just say a big thanks to Red1 for all his help and the mod in general. I don't think he realised what a demanding bunch we all are when he started, but this is an excellent mod, that does exactly what it says on the tin. Hopefully others will be able to help in the community as well to improve it further in Red's absence, but in the meantime, cheers fella!
Simon
Ditto. Thanks and CHEERS!< |
"...be mindful of the SnitzForce..." |
|
|
|
juuso2
Starting Member
19 Posts |
Posted - 16 October 2002 : 14:10:34
|
Weekly view problem is solved
Dim rs <-- insert this
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn, adOpenStatic
Excellent MOD red1 
< |
Edited by - juuso2 on 16 October 2002 14:12:28 |
|
|
|
goldfish
New Member
82 Posts |
Posted - 17 October 2002 : 05:17:09
|
quote:
Originally posted by juuso2
Weekly view problem is solved
Dim rs <-- insert this
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn, adOpenStatic
Excellent MOD red1
Juuso2,
Could you clarify what it is you're correcting and where....?
I don't THINK I'm getting that problem anyway, but it doesn't harm to fix anything that's broken...
Simon< |
|
|
|
juuso2
Starting Member
19 Posts |
Posted - 17 October 2002 : 09:04:02
|
quote:
Originally posted by juuso2
Getting this in Weekly Display....
Microsoft VBScript runtime (0x800A01A8)
Object required: 'rs'
/forum/cal.asp, line 354
Any idea why ?
This problem seems to happen only if I logged in as Admin and trying to view a weekly...
I had no problem viewing weekly along with others if I logged in as a regular member. There was no problem either as a guest or visitor to the site..
Im using SQL2000 if this makes a diff.
Modifications required to be made in cal.asp
Add the following red code at line 330
"AND C.CAT_ID = T.CAT_ID " & _
"ORDER BY T.T_EVENT_DATE Asc"
Dim rs
set rs = Server.CreateObject("ADODB.Recordset")
rs.open StrSql, My_conn, adOpenStatic
< |
Edited by - juuso2 on 20 October 2002 05:17:24 |
|
|
|
red1
Junior Member
355 Posts |
|
|
pethson
Starting Member
Sweden
19 Posts |
Posted - 20 October 2002 : 04:48:29
|
It works for me. I only added the Dim rs but it was on row 309 in my code. But that doesn't matter.
///Peter!< |
|
|
|
Fresdar
Starting Member
19 Posts |
Posted - 21 October 2002 : 12:45:06
|
| Im stilling getting that error as stated on page 7. My fix to this was not to put the calendar on the main page.< |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 22 October 2002 : 16:30:27
|
This is a FANTASTIC mod! Nice job! Couple questions...
1) Anyone have any code (or suggestions on what needs to be done) that will restrict which forums you may post events to?
2) Do any of the cal_style.asp styles identify days where events occur on? I would like to bold those dates in the small calendar so folks can see which days have events. I haven't figured out which style (if any) sets this.
Thanks!< |
Al Bsharah
Aholics.com
Jeepaholics Anonymous
Broncoholics Anonymous
Network Insight
|
Edited by - Jeepaholic on 22 October 2002 16:39:56 |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 22 October 2002 : 16:34:28
|
| YOu can hard-code the drop-down ..... I think that was suggested before as being the easiest way< |
|
|
|
Topic |
|
MOD: New Events Calendar for 3.4.03 beta
