| Author |
 Topic  |
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 31 March 2001 : 22:25:19
|
quote:
Well,
I took out the table that would nomally display the calendar, upcoming events, and recent events together.
So my line 160 is this :
rs.Open ssql, my_Conn
And this is lines 150 - 158 in mine :
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE, " & strDBNTSQLName & ", event_details FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strMemberTablePrefix & "Members.Member_ID WHERE " & _
"(Start_Date >='" & dFirstDay & "' AND Start_Date <= '" & dLastDay & "') " & _
"OR " & _
"(End_Date >='" & dFirstDay & "' AND End_Date <= '" & dLastDay & "') " & _
"OR " & _
"(Start_Date < '" & dFirstDay & "' AND End_Date > '" & dLastDay & "' )" & _
"ORDER BY Start_Date"
dim rs
set rs = server.CreateObject("adodb.recordset")
Hope this will help you help me.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=-
another suggestion for what you're doing is to try to include an unedited events_inc.asp along with inc_config.asp and inc_functions.asp in your site's default.
Also make sure you include it in this order. inc_config, inc_functions, then events_inc.asp.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
 |
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 31 March 2001 : 22:43:49
|
I have tried LOTS of things, and none or them are working. I still get the same error. I would really like to have this work. Please help.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 31 March 2001 : 22:57:05
|
another idea for you to try is to check the db to see if you have all the fields that's in the select statement are there.
Also, have you tried just using events_inc.asp as it's intended on the forum default.asp? if it doesn't work like it's intended then you can narrow it down to someelse and not your modifications.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 31 March 2001 : 23:00:37
|
Well,
I will check the database, but I do have it running on my forum for the site, which is not even close to ready yet.
Here are URLS to the main site and forum :
Main Site : http://home.asptools.co.uk
Forum : http://home.asptools.co.uk/forums
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 01 April 2001 : 05:37:49
|
AspTools,
I don't know if it helps, but I have the events_inc working out side the forum directory, I just included it like this
top of my file
<!--#include file="Forum/inc_functions.asp"-->
<!--#include file="Forum/config.asp"-->
<!--#include file="Forum/inc_top.asp"-->
<!-- Begin Content -->
<div align="center">
<!--#include file="forum/events_inc.asp"-->
</div>
You can see it here http://www.magicmushroom.org.uk
|
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 01 April 2001 : 12:21:53
|
HuwR,
I have one question. I was thinking maybe it had something to do with inc_top.asp, but the problem would be that it would display the fourm header on my main page, not good.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 01 April 2001 : 12:29:03
|
HuwR,
It worked, but like I said in my last post, I don't want the header from the forum on my main page. I will see if I can take out the html on my own.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 01 April 2001 : 12:39:53
|
I got it working.
Aznknight,
It seems that the file events_inc.asp does need something from inc_top.asp to work.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
Brent Trevel
Junior Member
Canada
122 Posts |
Posted - 01 April 2001 : 13:03:47
|
ASPTools,
I guess it's kind of late but here goes:
I sent this file to tschive and he is using it to show the calendar and events outside of the forum and his events page and it's working fine, but I haven't tested it with the new version of Alan's Calendar Mod.
You can include the file below anywhere in your site as long as you have the inc_functions.asp and config.asp pages included as well...
http://www1.7host.com/ninjaman/Portal/Calendar.inc
Here is tschive's implementation of the above file:
http://heilpaedagogik.121host.net/portal
Maybe this can help 
Sincerely,
Brent Trevel,
Combat Intelligence
www.combatintelligence.com
Edited by - Brent Trevel on 01 April 2001 13:06:35 |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 01 April 2001 : 13:32:46
|
Brent,
I will look at that. Yeah you to late. Maybe like an hour eariler
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=- |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 01 April 2001 : 14:53:18
|
quote:
I got it working.
Aznknight,
It seems that the file events_inc.asp does need something from inc_top.asp to work.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=-
Oh yeah, it does need inc_top.asp, I forgot about that  ...It uses strSQLDBName and some other variables near the login part of inc_top.
Anyways, glad to see you got it working with the modifications.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 01 April 2001 : 19:26:34
|
and it needs my_conn which is opened in inc_top too.
|
|
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 02 April 2001 : 09:05:35
|
Ok. I just got the new code this morning, and now I am getting this error in events_inc.asp. Any ideas?
ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
/forum/events_inc.asp, line 338
Looks to have something to do with the SQL statement built above. Missing M_NAME field. If I figure it out, I'll post a message..
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/ |
|
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 02 April 2001 : 09:42:06
|
quote:
Ok. I just got the new code this morning, and now I am getting this error in events_inc.asp. Any ideas?
ADODB.Fields error '800a0cc1'
ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.
/forum/events_inc.asp, line 338
Looks to have something to do with the SQL statement built above. Missing M_NAME field. If I figure it out, I'll post a message..
ww.sumofx.com/
Ok. On line 323, I added text in red:
strSql = "SELECT top 5 start_date, event_title, PRIVATE, M_NAME, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = " & strMemberTablePrefix & "Members.Member_ID WHERE start_date >= '" & DateToStr(date()) & "' and start_date < '" & DateToStr(DateAdd("d",30,date())) & "' Order by start_date, event_id ASC"
On line 357, I did the same:
strSql = "SELECT top 5 start_date, event_title, PRIVATE, M_NAME, " & strDBNTSQLName & " FROM " & strTablePrefix & "EVENTS Inner JOIN " & strMemberTablePrefix & "Members ON " & strTablePrefix & "EVENTS.added_by = Forum_Members.Member_ID WHERE start_date < '" & DateToStr(date()) & "' and start_date > '" & DateToStr(DateAdd("d",-30,date())) & "' Order by start_date desc"
This seems to have taken care of it...
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/ |
|
|
|
Big B
Starting Member
USA
49 Posts |
Posted - 03 April 2001 : 22:21:20
|
When I run the mod_dbsetup.asp, I can choose SQL 7.x or SQL 6.x.
I am running Snitz on SQL 2000. If I select SQL 7.x will it work?
Thanks,
|
|
|
|
Topic |
|
Topic Locked
