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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 Portal Mod add-on (events calendar)
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

kev0153
Starting Member

14 Posts

Posted - 07 February 2004 :  12:07:31  Show Profile
I'm getting this error as well.

icrosoft VBScript compilation error '800a0411'

Name redefined

/messageboard/inc_adovbs.asp, line 14
Const adOpenForwardOnly = 0
------^


Any world on this?

Thanks
Go to Top of Page

Beano_ie
Junior Member

Ireland
328 Posts

Posted - 08 February 2004 :  10:04:30  Show Profile  Visit Beano_ie's Homepage  Send Beano_ie an ICQ Message
This means is that you have declared the constant adOpenForwardOnly twice. One place it was declared was in the file inc_adovbs.asp on line 14. Now you need to find out where the other one is since you have not provided all the code. Once you find it, you can probably omit it or comment it out.

Courtesy of dayve

Steve
Drogheda, Ireland @ www.droghedatown.com
Go to Top of Page

kev0153
Starting Member

14 Posts

Posted - 08 February 2004 :  11:32:03  Show Profile
Thanks for tips. I think from looking are previous posts. The problem arises from including config.asp in cal_style.asp and in portal.asp. I not really an asp guy (php is more my thing ).

Removing the callout to cal_style.asp in portal.asp solves the problem but it gives other nasty errors on the portal page.
Go to Top of Page

kev0153
Starting Member

14 Posts

Posted - 08 February 2004 :  23:07:21  Show Profile
Ugh, well I got the new calendar to display the way I want it to. It was ugly. Here is a link:

http://nissanoffroad.net/messageboard/portal.asp

The page is still under construction and not live yet.

I'm almost afraid to show how I did it, like I said it was kind of ugly. If anybody is interested I can post it.
Go to Top of Page

stwilson
Junior Member

USA
385 Posts

Posted - 22 February 2004 :  12:32:09  Show Profile  Visit stwilson's Homepage
quote:
Originally posted by kev0153

I'm getting this error as well.

icrosoft VBScript compilation error '800a0411'

Name redefined

/messageboard/inc_adovbs.asp, line 14
Const adOpenForwardOnly = 0
------^



I have the same problem. I just converted to the new reoccurring events mod and it does include a link to config.asp. Any have a solution to this they are willing to share?

Shannon
RidingArizona.com
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts

Posted - 22 February 2004 :  12:49:38  Show Profile  Visit PeeWee.Inc's Homepage
"Const adOpenForwardOnly = 0" is defined twice. Make sure you dont have config.asp included twice, or inc_adovbs.asp and config.asp on the same page.

De Priofundus Calmo Ad Te Damine
Go to Top of Page

pokemon
Junior Member

151 Posts

Posted - 12 March 2004 :  16:10:30  Show Profile
kev0153,

would you mind to share how you implement the calendar into david's portal?. Your site is look great.
Go to Top of Page

keng38
New Member

United Kingdom
80 Posts

Posted - 18 March 2004 :  07:24:14  Show Profile  Visit keng38's Homepage
I'm having a problem with the events cal MOD - recurring dates.
The cal.asp page doesn't show any upcoming dates - even though they have been added.
Have any of you had a similar problem?
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 30 March 2004 :  16:21:09  Show Profile  Visit MarcelG's Homepage
Keng38 ; same for me here....
Also, the way it's displayed in a topic is not as it should be...

portfolio - linkshrinker - oxle - twitter

Edited by - MarcelG on 30 March 2004 16:21:42
Go to Top of Page

s80ts0465
Junior Member

Italy
290 Posts

Posted - 21 April 2004 :  07:39:04  Show Profile  Send s80ts0465 an ICQ Message
i've the same problem "Const adOpenForwardOnly = 0".
I checked the portal.asp file, but i didn't have include config.asp twice, nor inc_adovbs.asp and config.asp on the same page.
I've have the new mod calendar

what have i to do???

bye stefano

Edited by - s80ts0465 on 21 April 2004 08:03:21
Go to Top of Page

Radianation
Junior Member

USA
186 Posts

Posted - 27 April 2004 :  03:23:01  Show Profile  Visit Radianation's Homepage  Send Radianation an ICQ Message
What do I need to change in order to make some of the content end up on the left instead of all of it bunching up on the right? Am I overlooking an obvious admin page or something?


Nevermind, I see the comments in portal.asp - it sure would be nice to be able to adjust this like you do category order on the forum page. Checking for mods

Edited by - Radianation on 27 April 2004 03:26:21
Go to Top of Page

Radianation
Junior Member

USA
186 Posts

Posted - 27 April 2004 :  03:30:26  Show Profile  Visit Radianation's Homepage  Send Radianation an ICQ Message
quote:
Originally posted by Beano_ie

I just removed the call TableSpacer in the end;

sub DisplayCalender(byval Width)

dateHolder = dateValue(strForumTimeAdjust)
call DrawMonth(dateHolder,1,1,1)
' call TableSpacer(TABLE_SPACER_WIDTH, TABLE_SPACER_HEIGHT)
call StartTable(Width, "Upcoming Events")
call WriteUpcomingEvents()
call EndTable()
' call TableSpacer(TABLE_SPACER_WIDTH, TABLE_SPACER_HEIGHT)

end sub




This worked for me too, but I noticed that I have two locations where this sub routine is listed in the portal.asp ?? also, how can I get the actual cal centered now that this is removed?

This is what I did...


sub DisplayCalender(byval Width)

	dateHolder = dateValue(strForumTimeAdjust)
	response.write "<center>"
	call DrawMonth(dateHolder,1,1,1)
	response.write "</center><br>" 
	'call TableSpacer(TABLE_SPACER_WIDTH, TABLE_SPACER_HEIGHT)
	call StartTable(Width, "Upcoming Events")
	call WriteUpcomingEvents()	
	call EndTable()				
	'call TableSpacer(TABLE_SPACER_WIDTH, TABLE_SPACER_HEIGHT)

end sub

Edited by - Radianation on 27 April 2004 03:33:28
Go to Top of Page

Chrispix
Starting Member

USA
6 Posts

Posted - 06 May 2004 :  17:36:00  Show Profile  Visit Chrispix's Homepage  Send Chrispix an AOL message  Send Chrispix an ICQ Message  Send Chrispix a Yahoo! Message
I get the following message
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.

/forum/cal_functions.asp, line 76

Turns out this is the output of the offending SQL
SELECT E.EVENT_DATE,
T.FORUM_ID
FROM FORUM_TOPICS T INNER JOIN FORUM_CAL_EVENTS E ON T.TOPIC_ID = E.TOPIC_ID
WHERE T.FORUM_ID IN () AND E.EVENT_DATE BETWEEN '20040501000000' AND '20040531000000' GROUP BY E.EVENT_DATE, T.FORUM_ID ORDER BY EVENT_DATE Asc
The problem is that the () does not have a value, and I can't figure out why not. I can't seem to find where the variable that populates the () gets populated.
The variable is. arrRqCalForumID


Any thoughts would be great.. Thanks.

Chrispix a.k.a. Bonez
Go to Top of Page

tefalXP
Starting Member

1 Posts

Posted - 07 May 2004 :  12:07:55  Show Profile
Chrispix

The variable your after would normally be set when cal_default.asp gets called, if you put the bit between the hash's in your portal.asp file it should work.

%>

<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="inc_sha256.asp"-->
<!--#INCLUDE FILE="inc_header_portal.asp" -->
<!--#INCLUDE FILE="inc_func_secure.asp" -->
<!--#INCLUDE FILE="cal_functions.asp"-->
<LINK rel="stylesheet" href="cal_style.asp" type="text/css">
<%
'################################################################################
'This line of code is needed to display the event calendar on the portal screen
'Reset the Forum_ID
arrRqCalForumID = Trim(ChkString(Join(arrCalForumID, ","), "SQLString"))
'################################################################################

HTH

To alcohol! The cause of - and solution to - all of life's problems.
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 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.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07