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>