You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by declan kelly <de...@yahoo.com> on 2001/05/20 03:07:42 UTC
How to go about this?
Hi,
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 mightn't have explained myself well. If anyone has
any ideas or has done something like this before (this
is not a commercial thing it's for college) please let
me know, and if this sort of discussion isn't suitable
for the list, reply directly to me, I need to figure
this out ASAP or I'm screwed.
Cheers
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: cocoon 2 download path?
Posted by Denny <dd...@magic.fr>.
i found it!
here's the path
http://xml.apache.org/cocoon/cocoon2/install.html
thanks for everyone's patience
Denny
Denny wrote:
>
> Thanks Caroline...I found this path for the download for the cvs...
> http://xml.apache.org/from-cvs/xml-cocoon/
>
> the install link takes you to the 1.8 version
>
> thanks again
> Denny
>
> Denny wrote:
> >
> > Could someone send me the link for the URL for the download of Cocoon?
> > Mille Merci en avance!
> >
> > Dennis
> >
> > ---------------------------------------------------------------------
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: cocoon 2 download path?
Posted by Denny <dd...@magic.fr>.
Thanks Caroline...I found this path for the download for the cvs...
http://xml.apache.org/from-cvs/xml-cocoon/
the install link takes you to the 1.8 version
thanks again
Denny
Denny wrote:
>
> Could someone send me the link for the URL for the download of Cocoon?
> Mille Merci en avance!
>
> Dennis
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
cocoon 2 download path?
Posted by Denny <dd...@magic.fr>.
Could someone send me the link for the URL for the download of Cocoon?
Mille Merci en avance!
Dennis
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: How to go about this?
Posted by Steve Muench <St...@oracle.com>.
you could also build a second table with one row per valid
time slot, and then do an outer-join with that table to
produce a list of diary entries. For the slots without
specific diary entries, the final query result will just
have NULL's but this is just what you want.
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/
----- Original Message -----
From: "Donald Ball" <ba...@webslingerZ.com>
To: "cocoon" <co...@xml.apache.org>
Sent: Saturday, May 19, 2001 6:18 PM
Subject: Re: How to go about this?
| 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: <co...@xml.apache.org>
| For additional commands, e-mail: <co...@xml.apache.org>
|
|
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: How to go about this?
Posted by Donald Ball <ba...@webslingerZ.com>.
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>