cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
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. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message