Author |
Topic |
kev0153
Starting Member
14 Posts |
Posted - 07 February 2004 : 12:07:31
|
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 |
|
|
Beano_ie
Junior Member
Ireland
328 Posts |
Posted - 08 February 2004 : 10:04:30
|
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 |
|
|
kev0153
Starting Member
14 Posts |
Posted - 08 February 2004 : 11:32:03
|
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. |
|
|
kev0153
Starting Member
14 Posts |
Posted - 08 February 2004 : 23:07:21
|
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. |
|
|
stwilson
Junior Member
USA
385 Posts |
Posted - 22 February 2004 : 12:32:09
|
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 |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 22 February 2004 : 12:49:38
|
"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 |
|
|
pokemon
Junior Member
151 Posts |
Posted - 12 March 2004 : 16:10:30
|
kev0153,
would you mind to share how you implement the calendar into david's portal?. Your site is look great. |
|
|
keng38
New Member
United Kingdom
80 Posts |
Posted - 18 March 2004 : 07:24:14
|
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? |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 30 March 2004 : 16:21:09
|
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 |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 21 April 2004 : 07:39:04
|
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 |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 27 April 2004 : 03:23:01
|
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 |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 27 April 2004 : 03:30:26
|
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 |
|
|
Chrispix
Starting Member
USA
6 Posts |
Posted - 06 May 2004 : 17:36:00
|
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 |
|
|
tefalXP
Starting Member
1 Posts |
Posted - 07 May 2004 : 12:07:55
|
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. |
|
|
Topic |
|