cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <>
Subject Re: How to go about this?
Date Sun, 20 May 2001 01:18:59 GMT
On Sat, 19 May 2001, declan kelly wrote:

> I know this isn't the usual type of question, but I'm
> having trouble coming up with a way to this using XSP.
>  What I have is a DB table containg diary entries,
> which consist of Location, Time, Date etc. What I need
> to be able to do is generate a page with all the
> timeslots for a given date. The times that are in the
> DB (i.e. taken) won't have a link, but the ones that
> aren't taken (not in DB) will have a link to a form to
> take that timeslot.
> My problem is how to generate a table using the
> results from the esql query and fill in the rest of
> the table.
> ie.
> 9.30
> 10.00  <-  Taken (this will show up in my resultset)
> 10.30  <-  the ones that aren't taken won't show up
> 11.00
> 11.30..........
> See what I mean, I need to slot in my esql results
> into a set format, I'm not sure how to go about this.

i would write an xsp page with logic to iterate over a list of timeslots
and do a seperate query for each timeslot. alterately, you could generate
a list of timeslots and a (seperate) list of events and merge them using
some XSLT. there are a number of solutions for this problem.

- donald

Please check that your question has not already been answered in the
FAQ before posting. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message