Representing events calendar

Report · Oct 22, 2008

I'm trying to build a page that shows diferent events. I've spend the full
day experimenting with Spry but I'm not sure if this is the best way to
achieve this.

Basically I want to represent the events divided by months or using a
calendar so users can select the month and see the related events.

I've tryied many things...

I've created an HTML table with the events to feed a Spry DataSet. This is
nice but doesn't totally feed my needs. I've not found a way to do a query
as in a database. For exemple create a DataSet where the event month is only
October.

Then I've tryied the Spry Tabbed Panel. This is a nice way to show all the
information in a reduced space creating 12 tabs for each month. But I have
to create 12 static HTML tables inside for all the events.

I was excited about Spry and wanted to learn something new. But now I'm not
sure if it's better to build an Access database and use ASP to represent it.

I'm still not sure of the best way to do this.

Can somebody point me in some direction or show me some examples of similar
pages with this functionality?

Regards,
Angel

Report · Oct 23, 2008

I would suggest that no matter your choice of displaying them, they would be better at least coming from a recordset so that you can enter them all in one location. You can use the tabs and place different recordsets in each for example, or even create a search form that lets somebody select a month and have a results page that populates based upon that selection.

Report · Oct 24, 2008

Thanks for the suggestion.

After working with ASP and databases for some time I wanted to experiment
with Spry and I've found it very frustrating.

With a recordset is very easy to send parameters to filter the information
and get the desired results and even do searches. With a Spry dataset
everything seems to be very static. The Spry dataset wizard only allows to
choose a source HTML or XML so the information is static. I've found no way
to pass parameters to rebuild the XML or HTML to get different information.

Regards,
Angel

>I would suggest that no matter your choice of displaying them, they would
>be
> better at least coming from a recordset so that you can enter them all in
> one
> location. You can use the tabs and place different recordsets in each for
> example, or even create a search form that lets somebody select a month
> and
> have a results page that populates based upon that selection.
>