CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Calendar with DateEventBegin and DateEventEnd

Print topic Send  topic

Author Message
Igor

Posts: 3
Posted: 05/13/2007, 12:16 AM

I use 2 dates in my event table DateEventBegin and DateEventEnd. How to show in a calendar all the days long when there is an event?
For example conference will be from May, 13th to May, 16th. This one record in event table.
How to show 13,14,15,16 May in calendar?
Use mysql, php.
View profile  Send private message
Wkempees
Posted: 05/14/2007, 2:50 AM

As the Calendar is record oriented, meaning it will display an event per
record, your current approach I have no instant answer for.

The way I implemented this was to have an event record (booking).
The event record has a unique ID and a start_date end_date
event_description.
Upon add /update I would then create a calendar record for each day.
This calendar record would carry a fk__ to the eventID.
See example here www.dubbellul.nl/calendar

The add/update/delete is explained on the main page.
Walter
sappie

Posts: 13
Posted: 11/16/2007, 7:59 AM

Hello Walter,

Very neat solution for periods in a calendar.
Can you give some extra explenation (preferably coding) for the add/update/delete.
I don't succeed in reproducing this.

Kind regards,
Harold
View profile  Send private message
yoleonard

Posts: 6
Posted: 05/09/2008, 7:49 AM

Very nice calendar. I'd also be interested in seeing the project code.

I'm wanting to do similar, but more for conference room scheduling, where it can do a color block of the length of a meeting to show booked and open times.

Any other examples out there?

Thanks,
Roger
_________________
Rogmo
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.