| Author |
 Topic  |
|
rick7165
Senior Member
USA
1094 Posts |
 Posted - 29 March 2001 : 20:21:57
|
Ok.. got it up and running on my test site...
I need to know how to change the font colors manually
and mouse over. And for some reason the mouse cursor
is not working right on the mouse over.
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 29 March 2001 : 20:25:57
|
events calendar uses styles for the mouseovers and background effects in ie. for netscape the styles will only effect the background which is fine.
To Change this, goto the events_styles.asp and change colors and stuff accordingly.
- Alan
www.iamviet.com |
 |
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 30 March 2001 : 14:07:28
|
I get this error after adding an event, then going to month view in the month that it was posted in. It views the event just fine in View by Week mode or if I'm looking at the specific day it was posted on, but not Month View.
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.asp, line 946
Any ideas? I'm sorry, but I can't give a link to the forums. It's on an intranet...
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Edited by - sumo on 30 March 2001 15:41:43 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 30 March 2001 : 16:35:15
|
quote:
I get this error after adding an event, then going to month view in the month that it was posted in. It views the event just fine in View by Week mode or if I'm looking at the specific day it was posted on, but not Month View.
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.asp, line 946
Any ideas? I'm sorry, but I can't give a link to the forums. It's on an intranet...
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Edited by - sumo on 30 March 2001 15:41:43
line 946 reads
If ((rs("PRIVATE") <> 1) or ((rs("PRIVATE") = 1) and (lcase(rs(strDBNTSQLNAME)) = lcase(strDBNTUSerName)))) and (dToday >= strToDate(Rs("Start_Date")) AND dToday <= strToDate(Rs("End_Date"))) then
make sure that there are fields called private, start_date, and end_date in the forum_events table of your db.
I think the error might be due to this part: (lcase(rs(strDBNTSQLNAME))
This deals with Private messages added by Huwr. I'll look into it later tonight. Maybe Huwr can enlighten us on this.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 30 March 2001 : 19:26:38
|
Strange one...
It's March... I switch to April then tell it to view by Week. It switches back to March's week view.
Any Clues?
Also I need to change the rollover in the month view because it's white and blends into the white background. I need to set this manually.
Thanks,
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 30 March 2001 : 19:43:36
|
quote:
Strange one...
It's March... I switch to April then tell it to view by Week. It switches back to March's week view.
Any Clues?
Hi rick,
this is how it's suppose to work. Because you're viewing by month and then click view by week, it views the current week by default which happens to be in march.
However if you select like a date in april, and then click view by week, it will view the week the contains that date. Get it?
What did you expect it to show when you were in April's Month view? the first week of april? 2nd week? etc..? I guess first week of current month visitor is viewing would work as an alternative...will need a code change for that.
quote:
Also I need to change the rollover in the month view because it's white and blends into the white background. I need to set this manually.
Change the styles in events_styles.asp. I don't know which one you're talking about specificly, but for the rollover color it's one of the styles that has :hover in it.
One more thing, use newer events.asp file in the zip. Made a minor layout fix to upcoming and recent events display right after you downloaded it since you're the first to do it  .
Noticed how 2 events on same day display like two events on same day as
3/6/01
event 1
3/6/01
event 2
the layout fix displays it under 1 day
3/6/01
event 1
event 2
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 30 March 2001 19:47:08 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 March 2001 : 20:25:33
|
quote:
quote:
I get this error after adding an event, then going to month view in the month that it was posted in. It views the event just fine in View by Week mode or if I'm looking at the specific day it was posted on, but not Month View.
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.asp, line 946
Any ideas? I'm sorry, but I can't give a link to the forums. It's on an intranet...
Mike
http://www.sumovw.com/
http://www.sumovw.com/forum/
http://www.sumofx.com/
Edited by - sumo on 30 March 2001 15:41:43
line 946 reads
If ((rs("PRIVATE") <> 1) or ((rs("PRIVATE") = 1) and (lcase(rs(strDBNTSQLNAME)) = lcase(strDBNTUSerName)))) and (dToday >= strToDate(Rs("Start_Date")) AND dToday <= strToDate(Rs("End_Date"))) then
make sure that there are fields called private, start_date, and end_date in the forum_events table of your db.
I think the error might be due to this part: (lcase(rs(strDBNTSQLNAME))
This deals with Private messages added by Huwr. I'll look into it later tonight. Maybe Huwr can enlighten us on this.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
The problem is on line 833
this
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE, M_Name, event_details FROM "
Should be
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE," & strDBNTSQLName & ", event_details FROM "
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 30 March 2001 : 20:32:37
|
quote:
The problem is on line 833
this
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE, M_Name, event_details FROM "
Should be
sSQL = "SELECT event_id, start_date, end_date, event_title, PRIVATE," & strDBNTSQLName & ", event_details FROM "
Ah okay, I will fix this in the zip as well. Thanks again Huwr.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 30 March 2001 20:33:10 |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 30 March 2001 : 22:16:46
|
This is a question about the events_inc.asp file.
I want to be able to include that file in my main site page, not the main forum page. Could someone pleas help em do this. I have tried and got some errors. Even if you could point me in the right diredtion I can do the rest.
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 : 01:05:53
|
quote:
This is a question about the events_inc.asp file.
I want to be able to include that file in my main site page, not the main forum page. Could someone pleas help em do this. I have tried and got some errors. Even if you could point me in the right diredtion I can do the rest.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=-
Hi asptools,
the events_inc.asp file use some variables from the forum's config.asp as well as inc_functions.asp. You will need to include theses too your main site, if you want it to do that.
If you use slash mod on your main site, it should already have included those files so you're fine  . And good luck with it.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 31 March 2001 : 12:33:37
|
OK,
I will tray that.
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 - 31 March 2001 : 12:42:57
|
OK,
When I call the calender, it give me this error :
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/events_inc.asp, line 160
I used this to call just the calender :
<%DisplayMonth_small()%>
Is that right, or is this why the error is coming up? I have sat and tried to fixit myself, but I couldn't.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=-
Edited by - asptools on 31 March 2001 12:44:17
Edited by - asptools on 31 March 2001 12:47:56 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 31 March 2001 : 19:18:39
|
quote:
OK,
When I call the calender, it give me this error :
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/events_inc.asp, line 160
I used this to call just the calender :
<%DisplayMonth_small()%>
Is that right, or is this why the error is coming up? I have sat and tried to fixit myself, but I couldn't.
Matt
-=*=--=*=--=*=-
Please help me not to be so busy making a living,
That I forget to make a life,
AMEN
-=*=--=*=--=*=-
Edited by - asptools on 31 March 2001 12:44:17
Edited by - asptools on 31 March 2001 12:47:56
Just for clarification purposes to others reading this, ASPTOOLS is trying to extend the events_inc.asp so that he can use it on his own default page and not just the forum default.
AspTools,
You are trying to call the display_monthsmall function without including events_inc.asp? that won't work. that functions requires other function that are included in the events_inc.asp as well as functions from inc_functions.asp and variables from config.asp standard to forum pages.
My suggestion for going about this is to create a new events_inc.asp, name it my_events_inc.asp or something and just it include that in your own default page.
In my_events_inc.asp, You will include forum/config.asp and forum/functions.asp.
Then just change the layout around the section in my_events_inc.asp that calls the display_monthsmall function.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 31 March 2001 : 19:22:53
|
Aznknight,
I already have the events_inc.asp, config.asp, and inc_functions.asp included.
And I have made sure to remove the Table that displays it in the events_inc.asp, where it displays the calender, upcoming events, and recent events, not anything from the functions.
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 : 19:28:18
|
and you're still getting the error when you're attempting what you're doing?
Have a link where I can take a look?
also what is on line 160 of the events_inc that you've edited?
mines read '###################### Added above on 1/11/2001
so i don't think that's it 
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
ASPTools
New Member
USA
89 Posts |
Posted - 31 March 2001 : 19:34:59
|
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
-=*=--=*=--=*=- |
|
|
|
Topic |
|
Topic Locked
