| Author |
 Topic  |
|
rick7165
Senior Member
USA
1094 Posts |
 Posted - 09 April 2001 : 15:54:56
|
I've tried that... It only works with the small calendar.. not the full size one 
The full size one is using the forums color
scheme. white background, lightblue fonts with "White" rollover and the rollover is my
problem.
I've changed the setting in the file as you state above this only changes scheme in the small calendar on the front page.
where else is there a setting?
You can see what I mean here:
http://www.eastpasco.com/events.asp
Notice the rollover is different in the Large calendar then in the Small Calendar.
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 09 April 2001 16:02:02 |
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 09 April 2001 : 16:25:14
|
quote:
I've tried that... It only works with the small calendar.. not the full size one
The full size one is using the forums color
scheme. white background, lightblue fonts with "White" rollover and the rollover is my
problem.
I've changed the setting in the file as you state above this only changes scheme in the small calendar on the front page.
where else is there a setting?
You can see what I mean here:
http://www.eastpasco.com/events.asp
Notice the rollover is different in the Large calendar then in the Small Calendar.
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 09 April 2001 16:02:02
Ah i see your problem now. It has a white link effect on days with events and the events titles themselves huh?
This is because you're default links hover declared in inc_top.asp is white.
<style type=text/css> <!--
a:link {color:#6699CC;text-decoration:underline}
a:visited {color:#6699CC;text-decoration:underline}
a:hover {color:#FFFFFF;text-decoration:underline}
input.radio {background: #191944; color:#000000}
input.select {z-index:0}
The event_styles.asp does not have an over-ride style for this case. It relies on the default link hover and colors. So you can't change anything right now in events_styles.asp.
Let me give you a hot fix for this. Try it out and tell me if it works.
In line 43 of events_functions.asp, change this:
Response.Write "<br><a href=""JavaScript:openWindow3('pop_event.asp?event_id=" & rsEvents("event_id") & "')"" ><font face=" & strDefaultFontFace & " size=" & strFooterFontSize & ">" & sETitle & "</font></a>"
to
Response.Write "<br><a href=""JavaScript:openWindow3('pop_event.asp?event_id=" & rsEvents("event_id") & "')"" CLASS='" & sClass & "'><font face=" & strDefaultFontFace & " size=" & strFooterFontSize & ">" & sETitle & "</font></a>"
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 09 April 2001 : 16:36:52
|
Didn't work... It removed the event, but if you click on the day it will show up.
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
dcarmi
Starting Member
United Kingdom
15 Posts |
Posted - 11 April 2001 : 03:03:46
|
V2 sr1 does not work with MySQL as the database.
top is not supported by MySQL e.g.
SELECT TOP 5 event_id ....
The previous version of Events Calendar works just fine.
Snitz 3.1 sr4
MySQL 3.23.33
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 April 2001 : 05:55:45
|
quote:
V2 sr1 does not work with MySQL as the database.
top is not supported by MySQL e.g.
SELECT TOP 5 event_id ....
The previous version of Events Calendar works just fine.
Snitz 3.1 sr4
MySQL 3.23.33
Top doesn't work with mySQL? hmm that kinda sucks.
An alternative to using "TOP" keyword is to iterative loop up to whatever, but using TOP is better.
if I wanted to display 5 most recent events and didn't use TOP, the sql Querry will select all the events which is not very resourceful thing to do. Whereas top 5 for instance only returns 5 recordsets.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 11 April 2001 : 08:13:38
|
Alan,
Although I agree that not having the TOP predicate is quite inconvenient, I'm sure you could figure out an alternate approach to make it MySQL compatable.
Why not use a counter to take the entire recordset and grab the first 5 after ordering by date?
There are probably a few other approaches... that one just came to me while I was reading it...
Cheers!
(and thanks again for the calendar!)
Rob Poretti 
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
dcarmi
Starting Member
United Kingdom
15 Posts |
Posted - 11 April 2001 : 10:36:35
|
Alan,
quote:
Top doesn't work with mySQL? hmm that kinda sucks.
I think you will find the top predicate was only introduced into Oracle in V8i after goodness knows how many years of development and therefore you cannot be too hard on the MySQL developers. I suspect that top may originally have been an whizzy MS thing, but do not quote me.
In any case, as Calendar V2 sr1 stands it is not usable by MySQL users who will need to stick with the pre-sr1 version.
Dave.
|
|
|
|
rkattan
Starting Member
USA
12 Posts |
Posted - 11 April 2001 : 11:02:57
|
***** BUG *****
The the calendar is not working well !!!
i get for each month number of days as the month, for ex, april will show 4 white days, november 11 white days... only december is OK, this is because i use UK date style, DD/MM/YYYY on my server 
Fix is on events_function.asp line 11:
find this line:
dNextStart = CDate(intMonthNum + 1 & "/01/" & intYearNum)
and replace with this line:
dNextStart = CDate(MonthName(intMonthNum + 1) & " 1," & intYearNum)
Thanks...
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 April 2001 : 16:16:01
|
quote:
***** BUG *****
The the calendar is not working well !!!
i get for each month number of days as the month, for ex, april will show 4 white days, november 11 white days... only december is OK, this is because i use UK date style, DD/MM/YYYY on my server
Fix is on events_function.asp line 11:
find this line:
dNextStart = CDate(intMonthNum + 1 & "/01/" & intYearNum)
and replace with this line:
dNextStart = CDate(MonthName(intMonthNum + 1) & " 1," & intYearNum)
Thanks...
The disclaimer I posted with this mod says:
Repeat: Non US date format is still unsupported in this version
Still need help on this because I can't really test what I'm doing involving non US dates.
That's why you'll have problems.
Still waiting on the help for this. Also I think more changes need to be done than just what you posted, or else it'll be too easy .
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 11 April 2001 : 16:23:54
|
quote:
Although I agree that not having the TOP predicate is quite inconvenient, I'm sure you could figure out an alternate approach to make it MySQL compatable.
Why not use a counter to take the entire recordset and grab the first 5 after ordering by date?
Taking the entire recordset and then grabbing the first 5 is easy. Something like this.
dim i
i = 0
do while not rs.eof or i < 5
'do the events stuff
i = i + 1
rs.movenext
loop
But like I said, this is not very resourceful for calendar with lots of events. All the events will be pulled from the db when you only need just 5.
I guess I can modify it so that it's mySQL friendly as well as keep the original optimized for access/sql server version. I have no way of testing mySQL stuff though and I'm unfamiliar with what it doesn't support. If it's just the TOP keyword than it wouldn't be that bad.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 11 April 2001 16:25:00 |
|
|
|
blackinwhite
Average Member
Turkey
657 Posts |
Posted - 11 April 2001 : 18:19:06
|
I got this error both in events.asp and events_inc.asp :
quote:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/Forum/events_inc.asp, line 187
on my code in line 187 is:
rs.Open ssql, my_Conn
%>
|
|
|
|
Rob Poretti
Junior Member
Canada
435 Posts |
Posted - 12 April 2001 : 00:12:57
|
quote:
quote:
Although I agree that not having the TOP predicate is quite inconvenient, I'm sure you could figure out an alternate approach to make it MySQL compatable.
Why not use a counter to take the entire recordset and grab the first 5 after ordering by date?
Taking the entire recordset and then grabbing the first 5 is easy. Something like this.
dim i
i = 0
do while not rs.eof or i < 5
'do the events stuff
i = i + 1
rs.movenext
loop
But like I said, this is not very resourceful for calendar with lots of events. All the events will be pulled from the db when you only need just 5.
I guess I can modify it so that it's mySQL friendly as well as keep the original optimized for access/sql server version. I have no way of testing mySQL stuff though and I'm unfamiliar with what it doesn't support. If it's just the TOP keyword than it wouldn't be that bad.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Edited by - aznknight on 11 April 2001 16:25:00
Right... use:
if strDBType = "mysql" then 'MySql specific code
but still keep your optimized SQL statements for SQL and Access.
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 12 April 2001 : 02:49:04
|
quote:
Right... use:
if strDBType = "mysql" then 'MySql specific code
but still keep your optimized SQL statements for SQL and Access.
Cheers!
Rob Poretti
Sascom Marketing Group ~ Toronto
vox.905.825.5373 fax.905.825.5960
Yeah I thought about it right after I posted earlier and remembered that's how the Snitz Forum handles mySql issues. No time to do this right now though. I'm working on private messages add-ons.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
rkattan
Starting Member
USA
12 Posts |
Posted - 13 April 2001 : 11:34:04
|
Non US date format is SUPPORTED in this Mod
I was able to make this mod to support non US dates.
get this zip file and try...
http://www.kattanweb.com/webdev/download.asp?file=events_non_us_date.zip
Demo here: http://www.kattanweb.com/forums/events.asp
to fix the US date error in the forum:
1- use the attached events_functions.asp file.
2- in the "inc_functions.asp" file, look for:
function StrToDate(strDateTime)
....
end function
and replace it with this code:
function StrToDate(strDateTime)
if ChkDateFormat(strDateTime) then
StrToDate = cdate("" & MonthName(cint(Mid(strDateTime, 5,2))) & " " & Mid(strDateTime, 7,2) & ", " & Mid(strDateTime, 1,4) & " " & Mid(strDateTime, 9,2) & ":" & Mid(strDateTime, 11,2) & ":" & Mid(strDateTime, 13,2) & "")
else
StrToDate = "" & strForumTimeAdjust
end if
end function
this fix is supposed to work with all date formats, as dates are not used as mm/dd/yyyy or dd/mm/yy, the update makes the dated month dd, yyyy (ex April 12, 2001).
Hope this works for all, i am using dd/mm/yyyy and it works well for me.
Rami Kattan
http://www.kattanweb.com/forums
Edited by - rkattan on 13 April 2001 15:09:47 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 13 April 2001 : 14:50:56
|
way to go rkattan, good job .
I'll add this to the first thread so that other people see this. Then I'll wait for some comments and stuff from other users.
Here's a comment from me:
Also doesn't changing the strToDate function in inc_functions.asp to accomodate the your events calendar mess it up for other parts of the site that uses that function?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Topic |
|
Topic Locked
