next »

[Sarah]

Hello All,

I am in the midst of my first installation of Matt's excellent CalendarScript.  DanO's DoubleCal mod was exactly what I needed for this site, so I purchased it(well worth the price)yesterday.

The problem I am having is that the list of events is displaying sorted by the time, ignoring am and pm.  In other words, the event scheduled for 7 p.m. is showing before the one scheduled for 11 a.m., apparently because 7 comes before 11, without regard for the a.m. or p.m.

Based upon another post to these forums, I've added this code, all on one line immediately above the two places in default.html (formerly doublecal.html) that read <%FOREACH EVENT%> :

<% @$EVENTS = sort {$a->{schedule}->{start_time} <=> $b->{schedule}->{start_time} } @$EVENTS; %>

You can see the results (please look at October 2, as an example)here:   http://www.campbellsmazedaze.com/cgi-bin/calendar.pl

It is entirely possible that I've missed changing a preference somewhere, or that I can't see the forest for the trees, not an uncommon occurrence, especially when I'm fighting deadlines and learning curves concurrently.

I'm grateful for any help,
Sarah

P.S. BTW, as soon as I get this working so the client is satisfied with the sort, I will get paid, and as soon as I get paid, I will glady forward the payment I owe to Matt.  

[DanO]

** apparently because 7 comes before 11, without regard for the a.m. or p.m. **

The schedule times are stored as 24 hour notation (eg. 0900, 1100, etc.) so they should sort properly on that field. Maybe your system is dropping the leading 0 and causing the problem?

You can try changing your added line to the following to sort them as strings which should maintain the leading zero if present:

<% @$EVENTS = sort {$a->{schedule}->{start_time} cmp $b->{schedule}->{start_time} } @$EVENTS; %>

The only difference is cmp in place of <=>

Dan O.

[This message has been edited by DanO (edited August 29, 2004).]

[Sarah]

Dan O.,

Replacing <=> with cmp did the trick.  I very carefully entered the leading 0's where appropriate so am not sure why the string comparison is necessary to sort correctly.  Thank you VERY much for the prompt response, and on a weekend, too!  

Now I can see about getting Matt Paid!

Sarah

**You can try changing your added line to the following to sort them as strings which should maintain the leading zero if present:

<% @$EVENTS = sort {$a->{schedule}->{start_time} cmp $b->{schedule}->{start_time} } @$EVENTS; %>

The only difference is cmp in place of <=>

------------------

[DanO]

** Replacing <=> with cmp did the trick. **

Glad to hear it.

Dan O.

------------------