RE: ESQL help

2003-06-24 Thread Scherler, Thorsten
Hello Tim,

first hint:
http://wiki.cocoondev.org/Search.jsp?query=esql

I think what you are looking for:
http://wiki.cocoondev.org/Wiki.jsp?page=DatabaseConnectionOverview

Hope that helps
/Thorsten

-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 24, 2003 6:08 PM
To: [EMAIL PROTECTED]
Subject: ESQL help

Does anyone know of a good place to get help with esql issues?  I am
having a very difficult time finding any information regarding how to
correctly call a MS SQL stored procedure.  I have looked at the official
cocoon documentation and have the Cocoon developers handbook, neither
have much useful information.  I am in desperate need of help.

 

Thank you

 

Tim Bachta

 

 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Woody

2003-06-23 Thread Scherler, Thorsten
Title: Woody






Hello group,

I am looking for some information of and experience with woody.

I had a look @ the wikki and I find it very usefull but I would like some use-cases.

I am planning to the following with it:

In my thesis a friend and I develop a web based consulting system. We use a highly structured method. The core elements of the method are based on more or less standardised questionnaires. This questionnaire has to be answered for different category groups and from different parties. 

We use the 9 elements of Porters value chain as category groups (I wrote this for better understanding, only). So the same questionnaire has to be used for 9 different categories. That means the questionnaire has to be highly reusable. 

After the questionnaire has been answered we have to use business logic to get the result. This result has to be finally write into a database.

I think woody is doing that but what is the main advantage in comparison with e.g. struts.

I know this are just some basic information about what we are planning to do but maybe it is enough to get some input from the group.

If somebody have experience with the use of woody please let me know.

King Regards

/Thorsten

Mit freundlichen Grüßen

Thorsten Scherler






RE: database forms

2003-03-26 Thread Scherler, Thorsten
Hi Stefan, hi Lorenzo,

The solution to go with an action seems to be quite practical because both of you have 
proposed that.
While I had a glance on the book Professional XML Schema I was think that our 
validation is existent but quite rudimental.

1) The select problem
 xsl:template match=dbf:listbox
   esql:connection
 esql:poolxsp:exprdbfpool/xsp:expr/esql:pool
 esql:execute-query
   esql:querySELECT xsl:value-of select=@entries-column/ FROM
 xsl:value-of select=@entries-table//esql:query
   esql:results
  select
   esql:row-results
 option
   esql:get-string column=name/
 /option
   /esql:row-results
/select
   /esql:results
 /esql:execute-query
   /esql:connection
 /xsl:template
 
 note: dbfpool is a variable that might be set by a sitemap-parameter
 
 Then use it in an xsp-page like:
 dbf:listbox entries-table=author entries-column=name/
 
 That get's you in one line a  listbox filled with all the names in the
 author-table. Defining another parameter like ref=authorid 
 you could then
 bind it to a field in the book table.
 

I had the same approach when I was coding the selectoption - block. I think that 
is your (Stefan) solution of The select problem

2) The Lorenzo approach
 
 2. Reply to Lorenzo
 That is quite close to what I was talking about. However I 
 don't like having
 to write an extensive configuration file. For example, I 
 don't like having
 to define listboxes using a block of esql every time. I'd 
 very much prefer
 something like I outlined above.
 Besides I don't need to use the same form elements again and again in
 different contexts (which your system seems to be very useful 
 for), it's
 more about being able to write one single form really quickly 
 and directly
 without loads of support code (like the esql) around it.
 
 
Stefan got a point there! Your example (Lorenzo) is very good and advanced. The only 
problem was mentioned by Stefan. If we use your example for further development we 
have to simplify the structure. Especially if I keep in mind that I have a block of 
question were I do not know the name. 

3) XMLFormXindice

 3. More thoughts: XMLForms
 I'd been looking into XMLForms before and reading Lorenzo's 
 note at the end
 of his last message I took another deeper look. I found a 
 quite interesting
 tutorial that describes how to replace the form model (currently
 incorporated by a JavaBean) by a model defined by an XML-File 
 that is linked
 to an XIndice database:
 http://wiki.cocoondev.org/Wiki.jsp?page=XMLFormXindice
 
 I was wondering whether this would be worth a thought in this 
 case as well,
 since XML may be generated from any ordinary relational database, too.
 
 You would generate an XML-Model from the database, use it to 
 keep the form
 data and in the end send the data back to the database. That 
 would also have
 the advantage that you could build multi-page forms to gather 
 the data for
 one table (for example one form to gather the book data and a 
 separate one
 to select the author from a long list) and then in the end 
 send it to the
 database altogether (otherwise you would have to store the 
 book data without
 the author being filled in which wouldn't be possible, cause 
 the author
 field can't be empty...)
 
 So I am currently pondering about what to go for: an XSP 
 logicsheet approach
 as outlined above - that might be easier to implement right 
 now - or try to
 use XMLForms which would be a lot more flexible.

The problem with the logicsheet is the missing validation. 
The problem with the XMLFormXindice approach is the custom programming. If I compare 
your reference I find the ArtistAction.java that I have to edit and fill that with my 
fields. But like I stated before what will happen if I don't know this fields.

I am a bit confused, Stefan, do you want to use Xindice to store the options? Do you 
consider Xindice only as tool or do you want to use it?

4) Thought: DTD/Schema approach (in the spirit of DB2XML)
Some time ago I found this tool 
http://www.informatik.fh-wiesbaden.de/~turau/DB2XML/index.html DB2XML. The nice thing 
on it that the dtd will be generate on the fly. Using that this could give us the 
validation input. I admit it is quite similar to the Xindice approach. But the problem 
with Xindice is (in my opinion) the validation of dynamic data. 

The question remain whether DTD is enough or do we have to use schemas?

King regards
Thorsten

 
 Any advice is highly appreciated.
 Stefan
 
 
 
 AGAINST THE WAR!
 

Against Cesar Bush and the war!

 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, 

Re: Antwort: Multiple pdf with one match?

2003-03-24 Thread Scherler
hi Matthias,

that is a good way!

Thank you for the tip!

My problem is a little bit different because actually I want to send 
this e.g. 4 files to a printer! That I could not to wirth a zip, or 
could I?

King regards
Thorsten
Stoeckel, Matthias wrote:

Hi Thorsten,

another solution would be the ZipArchiveSerializer.  If your users have an
zip client you could put all your pdf's into one zip file. This would avoid
a javascript hack. One problem with opening windows (assuming that you use
IE on Windows) is that you can have a maximum of 4 requests per browser. So
you will get serious trouble with timeouts as soon as you have to send more
than 4 pdfs.
Cheers
 Matthias
 

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 21. März 2003 14:31
An: Cocoon-Users (E-Mail)
Betreff: Multiple pdf with one match?
Hello group,

I want to do the following:
I have on html-Form where I put the date. With this date 
there should be called 3 different piplines resulting 3 
DIFFERENT pdf files.

Some thoughts:
I thought about open 3 different browser windows where each 
is for one resulting pdf.
I can do that with JavaScript but would prefer to do it server sided.

Any ideas or links or hints?

King regards
Thorsten
   

Mit freundlichem Gruss,

Thorsten Scherler
Marketing / Telefonmarketing
Weidmüller GmbH  Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: content management systems - who is using a cms with cocoon?

2003-03-22 Thread Scherler
Chris Dietz wrote:

Anybody using a CMS(content management system) with Cocoon?

I would like to hear what you are using.

I am using lenya.

I am looking into Wyona/Lenya and forrest.
 

forrest is not a cms.

-chris

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: XSL and script code - please help

2003-03-22 Thread Scherler
http://www.w3schools.com/
they have all elements and functions on a page!
[EMAIL PROTECTED] wrote:

Hi,

I recommend:

http://www.zvon.org/
(very short, very useful and informative tutorials on XSLT)
http://www.w3.org/TR/xpath#corelib - list of functions.
http://www.mulberrytech.com/xsl/xsl-list/
hope it  helps, cheers, A.

 

-is there a fract() function ? I know that a floor
function exists. 

- But what about the loop ?

- What about passing variables to this code (and
getting them back into the XSL script) ?
- Do I need further (script-)extensions to XSL to do
this ?
   

 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: Cocoon and database example

2003-03-22 Thread Scherler
http://wiki.cocoondev.org/Wiki.jsp?page=HowTos
section database!
regards
Thorsten
p.s. there is a similar example of what you are planing to do in 
Cocoon: Building XML Application from Ziegler and langham! ISBN have 
to search this list for it:
http://marc.theaimsgroup.com/?l=xml-cocoon-usersr=1w=2

karthikeyan wrote:

Hi,

 I want to create simple news posting script.  Just wondering which is
 the best way to go for this.
If i go with ESQL way what are the necessary jar to place in my lib
folder.  I just dont want to place lots of jar files for something which
i may not use for right now.
 If you can point my out some tutorial of cocoon working with database
 that would be great.  I saw the one which comes with cocoon but i want
 something BARE MINIMUM.  

 Something like 

 XSQLselect * from news/XSQL

 Now I presume that the above tag will return xml data, i need to use
 XSLT and produce the output.
 How should i go about this.

 Have a great day.

Karthikeyan.
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: How to serialize a XML file to disk?

2003-03-22 Thread Scherler
Hi ,

I have not read the whole thread and I am in a hurry right now, but it 
sounds you should try Xindice a XML Database. There you could store your 
grabed data and merge them easy!

King regards
Thorsten
[EMAIL PROTECTED] wrote:

Hi :)

First of all thanks for your answer, but the requirements of the project is
that the search form is a http based client and all the results must be
displayed to it.
The idea to create an XML repository with all the XML data that we grab. And
then create several reports based on the data retrieved, using XSL
transformations to SVG/PDF etc..
So what's the best way to store the grabbed XML into local hardrive, and
merge the existing repository with the new id grabbed ( that corresponds to
the new XML created).
TIA



- Original Message -
From: Charles Yates [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, March 22, 2003 5:04 PM
Subject: Re: How to serialize a XML file to disk?
 

   Cocoon is a server application, what you have described is a http
client application.  Cocoon does have http client functionality and you
can customize it all you like, so the answer to your question is yes,
but from what you have described it does not sound like the best tool
for the job.
Charles

[EMAIL PROTECTED] wrote:

   

Hi all :)

We're doing a college work on cocoon and xml harvester potencial, and
we would like to know if we can grab a given XML file (on the web) to
a location on harddisk for a repository then work with it..
TIA



 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: Using XSP in XSL

2003-03-21 Thread Scherler
First read:
http://xml.apache.org/cocoon/userdocs/concepts/index.html
then:
http://wiki.cocoondev.org/Wiki.jsp
shankar wrote:
Hello,
I am new to cocoon.
I need  have a xsp file with element say test.
I like to get the value of the element in my XSL..?
How to do ti?
I searched the net and I didn't find proper examples.
Thanks in Advance



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


AW: database forms

2003-03-21 Thread Scherler, Thorsten
hi Stephan,

by the way are you in Spain right now?

see my answer below:

-Ursprüngliche Nachricht-
Von: Stefan Klein [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 21. März 2003 10:48
An: [EMAIL PROTECTED]
Betreff: Re: database forms


Hi Thorsten,

thanks for your reply. I've been pondering about your mail for a little
while now. The xsl looks like a clever idea. A few things remain unclear to
me:

What way do you use to get the data out of the DB. SQL-Transformer?

- No, because I need more logic (e.g. date format ...) [#1]! I use esql and xsp!
a)cocoon.xconf.snippet
jdbc name=D200301Insta
pool-controller min=5 max=10/
dburljdbc:odbc:MyDB/dburl
user/
password/
/jdbc

b) sitemap.snippet
  map:match pattern=report-info-*.xml
map:generate type=serverpages src=global/reports/xsp/info.xsp
  map:parameter name=pool value={1}/
/map:generate
map:serialize type=xml/
  /map:match

c) xsp.snippet compare [#1]
xsp:logic.../xsp:logic
esql:connection
esql:poolxsp:exprGETpool/xsp:expr/esql:pool
esql:execute-query
esql:query
select * from IDM_info_xml Where info1_date = #xsp:exprtimeOfDay/xsp:expr#
/esql:query
...

d) I call it like that: 
http://localhost:8080/myapp/report-info-D200301Insta.xml?date=13.03.2003


What do you refer to by static and variable data?
Like I stated I am working with call agent db. For me the adress and the contact 
person are static because they have always the same format. I have to write a 
xsl:template match=.../ for each of this field. 
e.g. 
address
  bname1Weidmüller GmbH  Co./bname1 
  bname2 / 
  bname3 / 
  streetP.O. Box 2807/street 
  ZIP33058/ZIP 
  CityPaderborn/City 
  country / 
  telephone_number05252-960-350/telephone_number 
/address
will be always formated like this and should be on a certain place within my html-form!

Where the campaign is dynamic! I have results of the questions which are formated like 
that:
Aayes/Aa
Abbigger then .../Ab
There I have to add the question (different table). the table qusetion might look like 
this AaDid you receive our mailing?Aa. But there can be 1 to n answers and 
questions.

static=the definition of the form (as in your XML example), variable=the
data from the DB?
No like I stated before! That was a different example that I fixed at home!

How do you get the data back into the database? using actions, I suppose?
I am still not really certain about that! I still in development of the html Form. I 
tried with SQL-Transformer and esql and both were working fine. But I think I will 
have a look at actions as well. But still I first have to really decide about the data 
model for the db-server.

In your example you've only got textboxes. With listboxes (select in HTML)
it gets a bit trickier, since you'll have to get the possible values from a
different table first. Have you got an idea for that, too?
Maybing using XSP-ESQL?
nested esql like that:
esql:connection
esql:pool
xsp:exprGETpool/xsp:expr
/esql:pool
esql:execute-query
esql:query
 select * from IDM_info_xml Where info1_date = #xsp:exprtimeOfDay/xsp:expr#
 /esql:query
esql:results
esql:row-results
xsp:logicint xid =esql:get-int column=info_1empf/;/xsp:logic
client
xsp:attribute name=id
esql:get-string column=Cust_No/
/xsp:attribute
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aps
esql:execute-query
esql:query
  select * from ap_tab where ap_id =xsp:exprxid/xsp:expr
/esql:query
esql:results
esql:row-results
ap
salutation
esql:get-string column=salutation/
/salutation
titel
esql:get-string column=titel/
/titel
forename
esql:get-string column=forename/
/forename
department
esql:get-string column=department/
/department
surname
esql:get-string column=surname/
/surname
textension
esql:get-string column=direct_dial_/
/textension
/ap
/esql:row-results
/esql:results
esql:no-results
no-results/
/esql:no-results
esql:error-results/
/esql:execute-query
/aps
/client
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection

What do you think?

King regards
Thorsten


Reference:
[1] http://wiki.cocoondev.org/Wiki.jsp?page=XSPTransformCustomDate


- Original Message -
From: Scherler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 5:58 PM
Subject: Re: database forms


 Hi Stefan,

 I have to master the same task. I am working in a telephone marketing
 department and writing the call agent DBs. I will introduce the 3 tier
 modell and will have to get rid of my formulars (VBA).
 We have some static fields (which are always

Multiple pdf with one match?

2003-03-21 Thread Scherler, Thorsten
Hello group,

I want to do the following:
I have on html-Form where I put the date. With this date there should be called 3 
different piplines resulting 3 DIFFERENT pdf files.

Some thoughts:
I thought about open 3 different browser windows where each is for one resulting pdf.
I can do that with JavaScript but would prefer to do it server sided.

Any ideas or links or hints?

King regards
Thorsten

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: Antwort: Multiple pdf with one match?

2003-03-21 Thread Scherler, Thorsten
Thanks Manfred.

One Request - One Response! You are so right!

So really no work around! - Ok, back to JavaScript!

Thanks again
Thorsten

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 21. März 2003 14:59
An: [EMAIL PROTECTED]
Betreff: Antwort: Multiple pdf with one match?




Hi Thorsten!

There is one big Problem: ONE request ends up in ONE response, there is no
way around! (http standard)

But...

if you submit your form to a pipeline which produces a frameset splitted up
in three areas, every area could call the real pipeline for producing PDF

Your idea doing it by JavaScript with three new windows is also pssible!

regards
manfred




[EMAIL PROTECTED] am 21.03.2003 14:30:51

Bitte antworten an [EMAIL PROTECTED]@inet

An:  [EMAIL PROTECTED]
Kopie:
Thema:   Multiple pdf with one match?


Hello group,

I want to do the following:
I have on html-Form where I put the date. With this date there should be
called 3 different piplines resulting 3 DIFFERENT pdf files.

Some thoughts:
I thought about open 3 different browser windows where each is for one
resulting pdf.
I can do that with JavaScript but would prefer to do it server sided.

Any ideas or links or hints?

King regards
Thorsten

 Mit freundlichem Gruss,

 Thorsten Scherler
 Marketing / Telefonmarketing

 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]









-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Strange behaviour with user-config

2003-03-20 Thread Scherler
Hi, that haven't  worked for me neither!

user-configfop/config.xml/user-config

is the way it worked for me!

Perry Molendijk wrote:
Hi Thorston,
 
I had the same problem untill I did this:
 

map:serializer mime-type=application/pdf name=fo2pdf 
src=org.apache.cocoon.serialization.FOPSerializer

user-config src=f:/apache/fop-fonts/userconfig.xml/

/map:serializer

i.e. put in an absolute path.

 

Perry

- Original Message -
*From:* Scherler, Thorsten mailto:[EMAIL PROTECTED]
*To:* Cocoon-Users (E-Mail) mailto:[EMAIL PROTECTED]
*Sent:* Wednesday, March 19, 2003 11:46 PM
*Subject:* Strange behaviour with user-config
Hello group,

I have written a small app which is working fine.
...but as soon as I want my own fonts for fop it is not working
(the pdf).
e.g.
map:serializer name=fo2pdf
src=org.apache.cocoon.serialization.FOPSerializer
logger=sitemap.serializer.fo2pdf mime-type=application/pdf
user-config src=global/fonts/ci/config.xml/
/map:serializer
if I have the code like that the I receive:
message UnnamedSelector: ComponentSelector could not find the
component for hint [fo2pdf]
description
org.apache.avalon.framework.component.ComponentException:
UnnamedSelector: ComponentSelector could not find the component
for hint [fo2pdf]
...but as soon i put the the user-config/ in comments (!)
it is working allright.
The config.xml is in PATH_to_my_app/global/fonts/ci/config.xml.

Anybody had the problem before?

King regards!

 Mit freundlichem Gruss,

 Thorsten Scherler
 Marketing / Telefonmarketing

 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
 http://www.weidmueller.de


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: How to include XSP at certain places in XML?

2003-03-20 Thread Scherler
Hello,
Hubert Holtz wrote:
Hello,

I know I can include static XML content at any place with cinclude, that works fine, but how can I include
the result of an XSP file in a XML file, at a place of my choice ( i need some database entries to build up the
whole site, that's why I nedd XSP inside my XML) ? I know that you can aggregate XSP and XML with the help of the sitemap, but if I use this option I don't
have the possibilty to place the result of the xsp code insight my xml file, only before or after a certain xml file
and I don't want to split my xml files in 10 lines long pieces to puzzle them together in the sitemap, that
wouldn't make any sense, but would work :-)
 

Ok, I would reckon that writting a xst transform would be quick.
Just do the aggregation and and tranform it like that:
xsl:template match=dbresult
db
resultsxsl:copy-of select=dbresult//results
xsp
xsl:copy-of select=xspresult/
/xsp
/db
/xsl:template
have a look at http://wiki.cocoondev.org/Wiki.jsp?page=Jars2exclude to 
see another transformation.

And I have a second question, what's the difference between cinclude and xinclude, is there any?
 

Not really 100% sure but I thing xinclude is for static and cinclude for 
stylesheets.

King regards
Thorsten


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: database forms

2003-03-20 Thread Scherler
Hi Stefan,

I have to master the same task. I am working in a telephone marketing 
department and writing the call agent DBs. I will introduce the 3 tier 
modell and will have to get rid of my formulars (VBA).
We have some static fields (which are always the same - address  
contact person) and some variable (we have different campaigns where the 
questions to ask will always be different)

I thought about that:
1) select a db (pool) = campaign Example
2) get the static data with xsl:template match=static/
3) get the variable data and put it in a different tag
4) use a transform to create a html form (including validation through 
JavaScript)

to 4)   like that xslt:
xsl:template match=input/*
   input
   xsl:attribute name=typexsl:value-of 
select=name()//xsl:attribute
   !-- --
   xsl:for-each select=@*
   xsl:attribute name={name()}xsl:value-of 
select=.//xsl:attribute
   /xsl:for-each
   xsl:choose
   xsl:when test=normalize-space(text())!=''
   xsl:attribute name=valuexsl:value-of 
select=normalize-space(text())//xsl:attribute
   /xsl:when
   /xsl:choose
   /input
   /xsl:template

with this xml:
form action=http://www.google.com/search; name=f
input
hidden name=ieUTF-8/hidden
hidden name=oeUTF-8/hidden
hidden name=hleng/hidden
text name=q maxLength=256 size=55/
submit name=btnGGoogle-Search/submit
/input
scriptdocument.f.q.focus();/script
/form
...

King regards
Thorsten
Stefan Klein wrote:

Hi all,

I am looking for the quickest way to write database forms. It is something
that I will be doing thousands of times, so the goal is to find some really
efficient way.
Ideally it would look something like:
tabletable name/table - selects the table
inputbox ref=field /   - a simple input field bound to a  field in the
table
listbox ref=field values=table.field entries=table.field/  - a
listbox bound to a field, entries defines the options visible to the user,
values defines what is internally stored in the field. obviously the table
would be the same (useful for foreign key entries)
checkbox ...

The form would be populated automatically with the database values (the
current record being selected by a request parameter) and update the values
on submit.
What I've been pondering about for quite a while now is what would be the
best way to implement this in cocoon.
I looked into the departments and employees-tutorial delivered with
cocoon2, which is quite close to what I'd like, but still not it. For
example I don't like having to define listboxes and populate the form by
using separate esql-statements. What data to fill into the form should
already be specified in the form definition.
My first idea was to start from there and implement a logicsheet that would
allow me to define tags like the ones above.
Then I looked into xmlforms and liked them a lot. However:
1. I am still looking for a tag reference. Maybe someone can help out.
2. I am still not entirely sure how they might help me. Surely it would be
possible to write a JavaBean that accesses the database, but doing that
every time again is not the simplification I am looking for. Is there a way
to reference database fields directly from the forms?
Basically, I would be very grateful for any kind of hint you can offer on
how to use xmlforms for this or on other ways of accomplishing the task
(maybe there would even be ways to take the database description and
generate a form from it?). I am quite stuck for ideas, but it seems a
standard job so I am sure many people have already found sufficient ways to
do it.
Thanks in advance
Stefan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: Graphics in XSL:FO?

2003-03-20 Thread Scherler
TRY:
fo:external-graphic src=http://localhost:8080/mycocoon/foo.gif/
before that can work, make sure you matched *.gif in the sitemap.

king regards

J.Pietschmann wrote:

Colin W. Kingsbury wrote:

I am trying to get cocoon to render an instance to PDF which includes a
graphic reference. I have used the fo:external-graphic
src=file:///c:/stuff/foo.jpg/ tag and have my cocoon running in say
c:\tomcat\webapps\cocoon.
If I run the FO output through Fop on the command line I see my graphic;
if I access it through cocoon URL I get a blank screen result and no
error messages.


Do you get a PDF with some stuff but missing the graphic?
In any case, first check the Cocoon logs and also the tomcat
stdout for errors.
J.Pietschmann



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Strange behaviour with user-config

2003-03-19 Thread Scherler, Thorsten
Hello group,

I have written a small app which is working fine.
...but as soon as I want my own fonts for fop it is not working (the pdf).

e.g.
map:serializer name=fo2pdf src=org.apache.cocoon.serialization.FOPSerializer 
logger=sitemap.serializer.fo2pdf mime-type=application/pdf
user-config src=global/fonts/ci/config.xml/
/map:serializer

if I have the code like that the I receive:
message UnnamedSelector: ComponentSelector could not find the component for hint 
[fo2pdf]
description org.apache.avalon.framework.component.ComponentException: UnnamedSelector: 
ComponentSelector could not find the component for hint [fo2pdf]

...but as soon i put the the user-config/ in comments (!) it is working 
allright.

The config.xml is in PATH_to_my_app/global/fonts/ci/config.xml.

Anybody had the problem before?

King regards!

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[summary] AW: Strange behaviour with user-config

2003-03-19 Thread Scherler, Thorsten
Hello Joerg,
I made the FOPSerializer including fonts working for me on a Cocoon 2.0.4. 
What's your Cocoon version?

- I am using 2.0.4. as well. The *funny* (not so funny after all) thing is that in my 
other webapp it is working fine!

It should be configured using 
user-configcontext://global/fonts/ci/config.xml/user-config. The src 
attribute is deprecated.

- That was the solution!

Thank you very much!

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: A Gzipped XML Serializer component for Cocoon

2003-03-19 Thread Scherler
Hi Bruce,

nice work! I have not tried it out yet, but it looks promising!

Do you work for that projekt http://heml.mta.ca/heml-cocoon/ ?

I find it a very nice example using cocoon and SVG!

King regards
Thorsten Scherler
Bruce Robertson wrote:

I have posted a Wiki page describing a serializer component I'm using which
produces gzipped XML output. This is especially useful for those serving
complex SVG and would rather send it off as a svgz file. 

I'm pretty sure this is something that eventually should be rolled into
Cocoon itself, but as I note in the page, my code is a hack on the
XMLSerializer, and shouldn't be ci'd as-is. 

Details at: 
http://wiki.cocoondev.org/Wiki.jsp?page=Gzip_XML_Serializer

Yrs,
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: SendMailAction?

2003-03-18 Thread Scherler
That you need for it:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg18506.html
How it work wih java:
http://www.javacommerce.com/articles/sendingmail.htm
About the sendmail logicsheet:
http://members.iinet.net.au/~xions/jigsaws/sendmail.html
you wrote:

I'm sorry, but I'm searching for the Action (Java class) not for the
logicsheet.
- the logicsheet is an implementation of JavaMail API:
http://java.sun.com/products/javamail/JavaMail-1.2.pdf
the cocoon\src\java\org\apache\cocoon\components\language\markup\xsp\java\sendmail.xsl
after using it is compiled to your class! you will find it after you have used in your 
webapp within the work dir of tomcat.
Hope that helps

Stephan Niedermeier wrote:

Stephan Niedermeier wrote:

   

Hello,

i couldn't find the SendMailAction in the cocoon.jar. Can anyone tell
me, where I can found this class?
Thanks.

Greetings
Stephan
 

http://marc.theaimsgroup.com/?l=xml-cocoon-usersm=104790860126005w=2
   

I'm sorry, but I'm searching for the Action (Java class) not for the
logicsheet.
Thank you.

Best regards
Stephan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: SQL Transformer or ESQL Stylesheet?

2003-03-18 Thread Scherler
Konlin wrote:

Hello Cocoon!

Can you write me any clues when to use sql transformer and when esql
stylesheet? What is more flexible, easier, more professional etc? I'm
going to write simple news portal with Xindice or MySQL as DBMS and
I'm wondering what solution is better.
Greetz,
Konrad Inglot
 

I have ask that question before but with no answer!
My personal opinion is that you should use the SQL-transform [a] for 
simple Queries where you do not need much logic in it.
The esql  way would be for something more complex. The advantage of 
using ESQL [b] is the xsp where you can add java code. So this documents 
are more intelligent.
The last way and the you should do way is with actions [c]. That way 
everything is in Java.

...but again I think it depends on the situation.
a. is a transformer
b. a generator
c. is an action.
King regards
Thorsten
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: SendMailAction?

2003-03-18 Thread Scherler
Hi Stephan,

I never heard about the sendmailaction. Sorry, but if you have to pass 
the email body as a sitemap parameter I think it is not really allways 
the way to go.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg12040.html

Stephan Niedermeier wrote:

That you need for it:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg18506.html
How it work wih java:
http://www.javacommerce.com/articles/sendingmail.htm
About the sendmail logicsheet:
http://members.iinet.net.au/~xions/jigsaws/sendmail.html
you wrote:

I'm sorry, but I'm searching for the Action (Java class) not for the
logicsheet.
- the logicsheet is an implementation of JavaMail API:
http://java.sun.com/products/javamail/JavaMail-1.2.pdf
   

I thought, that there is a SendMailAction I can use as action. Please have a
look into the mailarchive:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg12026.html
I didn't find additional informations about this strange SendMailAction.

Best regards
Stephan


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: SendMailAction?

2003-03-18 Thread Scherler
Frank Ridderbusch wrote:

On Tue, 18 Mar 2003 12:14:18 +0100
Scherler [EMAIL PROTECTED] wrote:
 

Hi Stephan,

I never heard about the sendmailaction. Sorry, but if you have to pass
the email body as a sitemap parameter I think it is not really allways
the way to go.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg12040.html
   

Hi,

I've worked on the sendmail.xsl logicsheet and the SendmailAction.java
in the past weeks. My work is currently with Christian Haul for review.
If he finds it acceptable, I would think, that it will end up in CVS
sometime soon.
If you are interested, I can send you copy directly. This includes 
documentation for logicsheet and action.

 

I was looking for this a long time.
I would appreciate a copy of you work and documentation. Have you add 
attachments?

King regards
Thorsten
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: [heads-up] wiki abuse: your advice please

2003-03-15 Thread Scherler
Niclas Hedhman wrote:

I favour a simple self-registration, with email address as user name (so that 
the community can bombard the intruder with hate mail - just kidding).
 

Having a valid wiki name is not enough! I think we have to enter a 
password as well!
...but this would be against wiki design principles [1]:
*Open* - Should a page be found to be incomplete or poorly organized, 
any reader can edit it as they see fit.

The suggestion of Hussayn is a nice thought: if you subscribed to the 
mailing list (dev|user|cvs) then you can write - otherwise you have to 
subscribe to the list.

[#1]http://c2.com/cgi/wiki?WikiDesignPrinciples

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


sitemap parameter for esq connection-pool in xsp

2003-03-14 Thread Scherler, Thorsten
Hello group,

I try to establish a template structure for my reports. The all the same besides the 
pool-connection.

If I use the following pipeline:
map:pipeline
 map:match pattern=report-*.xml
  map:generate type=serverpages src=global/reports/xsp/verkauf1.xsp
   map:parameter name=pool value={1}/
  /map:generate
  map:serialize type=xml/
 /map:match
/map:pipeline

How can I call the value of map:parameter name=pool value={1}/ within my xsp?

I tried it the following way (snippet from my.xsp)
...
 xsp:logic
String pool =;
 try
{
pool=request.getParameter(pool);
  }
 catch( ParseException e )
{
 getLogger().error(XSP param POOL error: , e);
}
/xsp:logic
...

But this way I can only get the parameter that is called like ...?pool=something. 

How can I use the parameter defined in the sitemap? ...and can I define the parameter 
like map:parameter name=pool value={1}/?

King regards
Thorsten
 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[Summary] AW: sitemap parameter for esq connection-pool in xsp

2003-03-14 Thread Scherler, Thorsten
Hello group, hello Judith,

thank you Judith for your quick reply!

I had to change the old my.xsp:
 xsp:logic
String pool =;
 try
{
pool=request.getParameter(pool);
  }
 catch( ParseException e )
{
 getLogger().error(XSP param POOL error: , e);
}
/xsp:logic

into the new my.xsp:
 xsp:logic
String GETpool = parameters.getParameter(pool, );
/xsp:logic

where I now can get the connection with:
esql:poolxsp:exprGETpool/xsp:expr/esql:pool

Thanks again!

Stupid question (because I do not really have a clue about Java):
Why can I not use a the following:
String GETpool =;
 try
{
String GETpool = parameters.getParameter(pool, );
  }
 catch( ParseException e )
{
 getLogger().error(XSP param POOL error: , e);
}

The error is than that I already have defined the variable pool.

...but that is only nice to know!

King regards
Thorsten

-Ursprüngliche Nachricht-
Von: Andres, Judith [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 14. März 2003 14:59
An: [EMAIL PROTECTED]
Betreff: AW: sitemap parameter for esq connection-pool in xsp


Try:

String pool = parameters.getParameter(pool, );

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 14. März 2003 14:55
An: Cocoon-Users (E-Mail)
Betreff: sitemap parameter for esq connection-pool in xsp


Hello group,

I try to establish a template structure for my reports. The all the same besides the 
pool-connection.

If I use the following pipeline:
map:pipeline
 map:match pattern=report-*.xml
  map:generate type=serverpages src=global/reports/xsp/verkauf1.xsp
   map:parameter name=pool value={1}/
  /map:generate
  map:serialize type=xml/
 /map:match
/map:pipeline

How can I call the value of map:parameter name=pool value={1}/ within my xsp?

I tried it the following way (snippet from my.xsp)
...
 xsp:logic
String pool =;
 try
{
pool=request.getParameter(pool);
  }
 catch( ParseException e )
{
 getLogger().error(XSP param POOL error: , e);
}
/xsp:logic
...

But this way I can only get the parameter that is called like ...?pool=something. 

How can I use the parameter defined in the sitemap? ...and can I define the parameter 
like map:parameter name=pool value={1}/?

King regards
Thorsten
 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: SQL and Stylesheets

2003-03-13 Thread Scherler
Hi Richard.
you are calling templates which are not there!
xsl:apply-templates 
select=/document/sql:rowset/sql:row/sql:generalmusictitle/

The example from Cocoon: building XML applications - with some comments:
sqlexample.xsl:
?xml version=1.0?
xsl:stylesheet version=1.0 
xmlns:xsl=http://www.w3.org/1999/XSL/Transform;
xmlns:sql=http://apache.org/cocoon/SQL/2.0;
!--the root of the the sqlexample is document but could also be / 
that is actually the same (HERE)--
!--MAIN - TEMPLATE--
xsl:template match=document
html
headtitletest/title/head
bodytable
!--Here we call a SUB-TEMPLATE. The result of that template will be 
parsed right here. We are looking for the following XPath 
(sql:rowset/sql:row):
sql:rowset
sql:rowThis node/sql:row
/sql:rowset
--
xsl:apply-templates select=sql:rowset/sql:row/
/table/body/html
/xsl:template
!--/MAIN - TEMPLATE--
!--Sub1 - TEMPLATE: apply all the templates which are based within the 
sql:rowThis node/sql:row
Did you notice that we match the row output and parse a xhtml-element 
tr for each matching sql:row/.
Without using xsl:for-each/.
--
xsl:template match=sql:row
tr
xsl:apply-templates/
/tr
/xsl:template
!--/Sub1- TEMPLATE--
!--Sub2 - TEMPLATE--
!-- Here we know that the elements of the parent sql:row/ are 
sql:id|sql:name. | means or! Or lets say we just want them from the 
stream.--
xsl:template match=sql:id|sql:name
td
xsl:value-of select=./
/td
/xsl:template
!--/Sub2 - TEMPLATE--
/xsl:stylesheet

Besides that it would be nice to see your sitemap.xmap and the result of 
the sql transformation of the database.xml -Do you remember:
map:pipeline
map:match pattern=database
map:generate src=database.xml/
map:transform type=sql/
!-- map:transform src=databasepda.xsl/--
map:serialize/
/map:match
/map:pipeline

King regards
Thorsten
Richard Cunliffe wrote:

Thorsten and Marco,

After reading the Cocoon: Building XML Applications and OReilly 
XSLT I have written my own tidy and simple XSL style sheet J 
(instead of using XML Spy). Its giving results, but its not right.

I have included the style sheet, the XML document, and a picture of 
the results. Im sure its nothing to serious. It may be something to 
do with X-Paths but I cant be sure.

Thanks,

Richard.



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


[wiki] Difference between esql and sql? Area of usage?

2003-03-13 Thread Scherler
Hello group,

/I found different ways for SQL in cocoon. On the one hand there is 
esql:.../, on the other sql:.../. 

/This is the start of the following wiki-page that I started to 
summarize my experience with cocoon sql / esql. 
http://wiki.cocoondev.org/Wiki.jsp?page=SQL/
/*/consider this a work in progress - and I just started/*
Agenda:
- Difference between sql and esql = first page
- example1 sql / esql (beginner example of both approaches with the same 
result) = second page
- example2 sql / esql (Parameter example of both approaches with the 
same result) = third page
- example3 esql (nested example) = fourth page
- example4 esql (nested example + xsp:logic) = fifth page
/
for the first page:
/*please correct me if I am wrong, I am a beginner*
The main difference that I see is that sql:.../ is based on a 
transformer and esql:... on a generator. [1]
One advantage in XSP is that you can add more logic to a document. You 
can use Java and esql-logicsheet within XSP.
One advantage in using  SQL is that you can have multiple transformer 
within a match.
Both are based on different logicsheets.
...

second page:
simple pipline with a normal Select id, department_id, name from  
employee with a sql-transform and a esql-generation.
...

third page:
simple pipline with a normal Select id, department_id, name from  
employee Where id=? with a sql-transform and a esql-generation.
Introduction to esql:parameter/ and xsl:param/.
...

fourth page:
nested example with esql - 2 approaches:
a)  select * from ap_tab where ap_id = esql:parameter 
type=intesql:get-int column=id ancestor=1//esql:parameter
b) You need a xsp:logicint ap_id = esql:get-int column=id/ before 
the inner query begins and then use xsp:exprap_id/xsp:expr in the 
inner query to recall it.
query1

select ap_id as id from sales 
query2
select * from ap_tab where ap_id =query1-resultidquery1-result
/query2
/query1

...

fifth page:
http://wiki.cocoondev.org/Wiki.jsp?page=XSPTransformCustomDate
I will work on a regular basis on it and everybody is welcome to edit 
the page!

Any help welcome - just post your comment to this mail (reply).

King regards
Thorsten
Reference:
[#1] http://marc.theaimsgroup.com/?l=xml-cocoon-usersm=103979425914445w=2
/
/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: SQL and Stylesheets

2003-03-13 Thread Scherler
Richard Cunliffe wrote:

Thorsten

Ok, I when I looked at the book I thought I would take it back one step,
for it to make more sense to me. Therefore I thought I would start off
doing all the XPATHs together instead of separating it out and doing
many more MATCHes. 

The disadvantage in doing so is that you can not really debug the code! :(
...and frankly speaking xsl:apply-templates 
select=/document/sql:rowset/sql:row/sql:generalmusictitle/ don't 
result in

doing all the XPATHs together it is only one match!

...and still you have a define a match within the xsl:template!

You want to apply a template that matches 
select=/document/sql:rowset/sql:row/sql:artistbandname
xsl:apply-templates 
select=/document/sql:rowset/sql:row/sql:artistbandname/
...but no where in your code s a xsl:template 
match=/document/sql:rowset/sql:row/sql:artistbandname

...please read the eMail I have send you!

If you look on page 171 of the 'Cocoon Building applications' we can the
result that the SQL transformer comes out with, we don't normally see
this. Therefore I think I was calling templates that exist(although
temporarily).
Can you check I'm right?

You are wrong that is the whole point in it! You are not calling a 
template(xsl:call-template)! You want to apply a template 
(xsl:apply-templates)!
...but that is xsl stuff

...what comes out of a sql transformer is xml stuff! Node that you can 
match later on!

I have got the results to come out correctly by just copying the book,

NO!

Ok, last time! Try:
   map:pipeline
   map:match pattern=database.2test
   map:generate src=database.xml/
   map:transform type=sql
   map:parameter name=use-connection value=soundpool/
   /map:transform
   map:serialize type=xml/
   /map:match
   /map:pipeline
call it!
post the result! Otherwise neither you nor me know what is the real 
result of the transform! Or maybe there is NO result!

...by the way : your sitemap
   map:transform type=sql
   map:parameter name=use-connection value=soundpool/
   /map:transform
and your xsl file:
sql:use-connectionsoundpool/sql:use-connection
You should NOT  DO that! One time is enough!

but as soon as I start adding things to the style sheet, things start to
go wrong, that's why I thought I would set it up myself from start to
gain a better understanding. 

If I am calling the correct templates, can you see why it displays my
XML document 3 times?
If I'm wrong :-( about the templates on page 171, then tell me, and I
will try and work from there example a bit more.
 

That is just AN example NOT what is coming out for you!

Thanks

Richard

By the way I have included my sitemap!

 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


[Summary] nested queries with esql

2003-03-12 Thread Scherler, Thorsten
Hello group,
hello Christian Haul, hello Tim Myers, hello Leo Leonid,

here is my small summary (I will put it in the wiki ;-)).

problem:
I am using a RDBMS. I have two queries where the second query should use the result of 
the first.

example (working one): 
my.xsp:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolOSTMDB/esql:pool
!--First query--
esql:execute-query
esql:query
select ap_id as id from sales 
/esql:query
esql:results
esql:row-results
data
ep1
esql:get-int column=id/
/ep1
!--Second query which should dynamic --
aps
esql:execute-query
esql:query
 select * from ap_tab where ap_id =1
/esql:query
esql:results
esql:row-results
ap
esql:get-columns/
/ap
/esql:row-results
/esql:results
esql:no-results
no-results/
/esql:no-results
esql:error-results/
/esql:execute-query
/aps
/data
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Suggestions from the list:
a) Christian wrote (Mail: Multiple ancestors):
select * from ap_tab where ap_id =  esql:parameter type=intesql:get-int 
column=id ancestor=1//esql:parameter
Status = not working! I don't receive any error messages. It is just working without 
any result (besides CPU-usage 100%). I tried with 2 different db (big and small) but 
neither were working :( - thanks for the support, anyway. :)
= modifying the query like:
esql:parameteresql:get-int column=id ancestor=1//esql:parameter
will not result in an error but neither I receive the data of the contact person!

b)Tim wrote (Mail: Re: esql nested queries):
You need a xsp:logicint ap_id = esql:get-int column=id/ before the inner query 
begins and then use xsp:exprap_id/xsp:expr in the inner query to recall it.
= That is working fine with the small and big db!

So the final my.xsp looks like that:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;

dataset
esql:connection
esql:poolINSTA/esql:pool
!--note--
esql:execute-query
esql:query
 select ap_id as id  from xml_verkauf 
 /esql:query
esql:results
esql:row-resultsxsp:logicint xid =esql:get-int column=id/;/xsp:logic
data
ep1
xsp:exprxid/xsp:expr
/ep1
!--note--
aps
esql:execute-query
esql:query
  select * from ap_tab where ap_id 
=xsp:exprxid/xsp:expr/esql:query
esql:results
esql:row-results
ap
esql:get-columns/
/ap
/esql:row-results
/esql:results
esql:no-results
no-results/
/esql:no-results
esql:error-results/
/esql:execute-query
/aps
/data
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Thank you for the hints you gave me! Tim, thanks for actually SOLVING MY problem.

King regards
Thorsten

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: 2 (should be) easy questions

2003-03-12 Thread Scherler, Thorsten



Hello 
Richard,

to 1) 
yes you have to define the image in the sitemap (e.g. from my sitemap (will not 
work with your configuration)):
!-- === Ressources 
 --map:pipeline!-- 
images gif --map:match 
pattern="img/**.gif"map:read 
src="" 
mime-type="images/gif"//map:match!-- images 
jpg --map:match 
pattern="img/**.jpg"map:read 
src="" 
mime-type="images/jpeg"//map:matchmap:match 
pattern="img/**.jpeg"map:read 
src="" 
mime-type="images/jpeg"//map:match/map:pipeline

to 2) 
??? don't understand the problem 
King regards
Thorsten

-Ursprüngliche 
Nachricht-Von: Richard Cunliffe 
[mailto:[EMAIL PROTECTED]Gesendet: Montag, 10. März 2003 
18:49An: [EMAIL PROTECTED]Betreff: 2 (should be) 
easy questions

  
  
  
  Hi,
  
  I have two 
  questions:
  
  1. 
  Im not sure if this cocoon or my 
  inability to do XSL, but I have my web page images in an images folder, under 
  the root directory soundpool. Everything was looking good until I checked the 
  site in netscape, when I found the images were not loading. I consequently 
  checked on other on other computers, and they were not working there either. 
  Do I need to included something in my sitemap to tell cocoon where the images 
  are. If this is not the case, could someone please tell me how to get them to 
  work. The rest of my XML is being parsed correctly. Below is an example in my 
  style sheet referencing an image:
  
   
  img 
  src="C:\tomcat\webapps\cocoon\soundpool\images\uktop10.gif"/ 
  - This is what 
  XML Spy produced in its XSLT designer, I have also tried
   
  
   
  img 
  src="images\uktop10.gif"/ 
   this also 
  doesnt work
  
  
  
  2. 
  My next question is a DTD 
  question
  
  I have SQL statements in my XML 
  code to query a MySQL database, and I now want to display the results, but how 
  do I define this SQL query in my DTD?? I have attached a XML 
  file.
  
  
  Richard.


AW: nested queries with esql

2003-03-12 Thread Scherler, Thorsten
Ok, promise you will not laugh:

MS Access - I have to :(

-Ursprüngliche Nachricht-
Von: Christian Haul [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. März 2003 16:51
An: [EMAIL PROTECTED]
Betreff: Re: nested queries with esql


On 12.Mar.2003 -- 04:23 PM, Scherler, Thorsten wrote:
 select * from ap_tab where ap_id = esql:parameter
 type=intesql:get-int column=id ancestor=1//esql:parameter

 Status = not working! I don't receive any error messages. It is just
 working without any result (besides CPU-usage 100%). I tried with 2
 different db (big and small) but neither were working :( - thanks for
 the support, anyway. :)

Just out of curiosity: what DBMSs are you using?

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: nested queries with esql

2003-03-12 Thread Scherler, Thorsten
Hello Christian,

that is actually working fine!

Maybe a reason:
The one we started the discussion with:
The first query was based on a ACCESS query and the second was based on a table!

The personnel is based on 2 tables! - I have put everything in an Access DB to see 
whether it is working!

...what do you thing?

-Ursprüngliche Nachricht-
Von: Christian Haul [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. März 2003 17:28
An: [EMAIL PROTECTED]
Betreff: Re: nested queries with esql


On 12.Mar.2003 -- 04:54 PM, Scherler, Thorsten wrote:
 
 Von: Christian Haul [mailto:[EMAIL PROTECTED]
 Gesendet: Mittwoch, 12. März 2003 16:51
 An: [EMAIL PROTECTED]
 Betreff: Re: nested queries with esql
 
 
 On 12.Mar.2003 -- 04:23 PM, Scherler, Thorsten wrote:
  select * from ap_tab where ap_id = esql:parameter
  type=intesql:get-int column=id ancestor=1//esql:parameter
 
  Status = not working! I don't receive any error messages. It is just
  working without any result (besides CPU-usage 100%). I tried with 2
  different db (big and small) but neither were working :( - thanks for
  the support, anyway. :)
 
 Just out of curiosity: what DBMSs are you using?
 
 Ok, promise you will not laugh:
 
 MS Access - I have to :(

Could you try to run the following snippet with it? It's tested
against HSQLDB, it needs the personnel connection with the appropriate
content. You should be able to adjust it to your schema and data.

  esql:connection
esql:poolpersonnel/esql:pool

  esql:execute-query
esql:query
  SELECT name, id FROM department ORDER BY name
/esql:query
esql:results
  esql:row-results

h2esql:get-string column='name'//h2

esql:execute-query
   esql:query
  SELECT name FROM employee 
  WHERE department_id = 
 esql:parameter type=intesql:get-int column=id 
ancestor=1//esql:parameter
 !-- note: no spaces between esql:parameter and esql:get-int --
   /esql:query
   esql:results
  esql:row-results

  paraesql:get-string column='name'//para

  /esql:row-results
   /esql:results
/esql:execute-query

  /esql:row-results
/esql:results
  /esql:execute-query

 /esql:connection


Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: nested queries with esql

2003-03-12 Thread Scherler, Thorsten


-Ursprüngliche Nachricht-
Von: Christian Haul [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 12. März 2003 18:08
An: [EMAIL PROTECTED]
Betreff: Re: nested queries with esql


On 12.Mar.2003 -- 05:55 PM, Scherler, Thorsten wrote:
 
 that is actually working fine!
 
 Maybe a reason:
 The one we started the discussion with:
 The first query was based on a ACCESS query and the second was based on a table!
 
 The personnel is based on 2 tables! - I have put everything in an Access DB to see 
 whether it is working!
 
 ...what do you thing?

From the implementation point of view it should not make a
difference. ESQL does not know about tables. All it knows about are
queries and result sets.

So, if it really depends on MS Access whether there are two or one
table, I'd say either the jdbc driver or MS Access is
broken. Following the discussions on this list, I'd say both
are. Anyhow, I have not worked with these products, this is only
hearsay.


- Don't try to work with that product it is pain in the a...!


But there might have slipped a typo into your sample and table count
doesn't matter.

- I had a similar problem before. After a query all the integer have been converted 
to string!

...anyway I will but it in the wiki. That way we can keep track with the problem!

Thorsten

Chris.
-- 
C h r i s t i a n   H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: SQL RE: 2 (should be) easy questions

2003-03-12 Thread Scherler, Thorsten



Hello 
Richard,

your 
xsl is quite complex! 

To 
begin with, I prefer to nest my templates! So instead of:
xsl:template 
match="/"htmlhead/bodyimg 
src=""/titlesoundpool/titlexsl:for-each 
select="/".../xsl:for-each 
select="/".../xsl:template

I 
would do it like this:
xsl:template 
match="/"htmlhead/bodyimg 
src=""/titlesoundpool/titlexsl:apply-templates//xsl:template

xsl:template match="row|rowset"
...
/xsl:template

Besides that you have a xsl:apply-templates/ within a 
xsl:for-each That will result in an overflow (anybody correct me if 
I am wrong!). It will be called over and over again.

What 
are you trying to do with, anyway:
xsl:for-each select="query"xsl:for-each 
select="execute-query"xsl:apply-templates//xsl:for-each/xsl:for-each


Ok, I got some results 
to come out, but as soon as add more to the XSL style sheet nothing appears from 
the database.
- What do you mean?

  -Ursprüngliche Nachricht-Von: Richard Cunliffe 
  [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 12. März 2003 
  18:19An: [EMAIL PROTECTED]Betreff: RE: SQL RE: 
  2 (should be) easy questions
  
  Thorsten,
  
  Ok, I got some 
  results to come out, but as soon as add more to the XSL style sheet nothing 
  appears from the database.
  
  Is it possible for 
  you to have a look at my style sheet, and see if there are any obvious 
  mistakes?
  
  Many 
  Thanks,
  
  Richard.
  
  -Original 
  Message-From: Scherler, 
  Thorsten [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 16:34To: 
  [EMAIL PROTECTED]Subject: AW: SQL RE: 2 (should be) easy 
  questions
  
  
  Hello 
  Richard,
  
  
  
  ok, i am 
  still a whee bit confused but I try to answer.
  
  
  
  You 
  don't need to declare it! If so the CDATA would be the best! 
  
  
  
  
  You are 
  using sql:... that tells me that you need a map:transform 
  type="sql"/ in your sitemap!
  
  
  
  Like 
  that:
  
  map:match 
  pattern="verkauf-cp"map:generate 
  src=""/map:transform 
  type="sql"/map:serialize 
  type="xml"//map:match
  
  
  
  is that 
  right? ...and is it working?
  
  
  
  King 
  regards 
  
  Thorsten
  
  
  
-Ursprüngliche 
Nachricht-Von: Richard 
Cunliffe [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 12. März 2003 
17:07An: 
[EMAIL PROTECTED]Betreff: SQL RE: 2 (should be) easy 
questions
Thorsten,

The 
second question is about the SQL statement I have in my XML document. I am 
unsure how to declare it in my DTD.

Do you 
know if it is possible to define the SQL statement in my XML document in the 
DTD? I have everything defined, but I know that the SQL statement is defined 
wrongly. It is currently defined as data, so that means when a style sheet 
is applied, it only gives the SQL statement and not the 
results.

    Can 
you help? I have attached my DTD and XML files.

Richard.


-Original 
Message-From: 
Scherler, Thorsten [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 15:52To: 
[EMAIL PROTECTED]Subject: AW: 2 (should be) easy 
questions


Hello 
Richard,



to 1) 
yes you have to define the image in the sitemap (e.g. from my sitemap (will 
not work with your configuration)):

!-- 
=== Ressources  
--map:pipeline!-- images gif 
--map:match 
pattern="img/**.gif"map:read 
src="" 
mime-type="images/gif"//map:match!-- 
images jpg --map:match 
pattern="img/**.jpg"map:read 
src="" 
mime-type="images/jpeg"//map:matchmap:match 
pattern="img/**.jpeg"map:read 
src="" 
mime-type="images/jpeg"//map:match/map:pipeline



to 2) 
??? don't understand the problem 

King 
regards

Thorsten



-Ursprüngliche 
Nachricht-Von: Richard 
Cunliffe [mailto:[EMAIL PROTECTED]Gesendet: Montag, 10. März 2003 
18:49An: 
[EMAIL PROTECTED]Betreff: 2 (should be) easy 
questions

  
  Hi,
  
  I have two 
  questions:
  
  1. 
  Im not sure if this cocoon or 
  my inability to do XSL, but I have my web page images in an images folder, 
  under the root directory soundpool. Everything was looking good until I 
  checked the site in netscape, when I found the images were not loading. I 
  consequently checked on other on other computers, and they were not 
  working there either. Do I need to included something in my sitemap to 
  tell cocoon where the images are. If this is not the case, could someone 
  please tell me how to get them to work. The rest of my XML is being parsed 
  correctly.

AW: SQL RE: 2 (should be) easy questions

2003-03-12 Thread Scherler, Thorsten



I had 
a glance at your code, do you use the SPY as well to show the 
result?

I 
guess not! I am using the SPY as well. 

Ok, 
correct me if I am wrong! I aspect your pipeline looks like that (because I 
guess you are using cocoon to transform):
map:pipelinemap:match 
pattern="database" map:generate 
src=""/ map:transform type="sql"/ 
map:transform src=""/ 
map:serialize//map:match/map:pipeline

Is 
that right? If not - it should look like that!

Explanation:
map:pipelinemap:match 
pattern="database" 1) map:generate 
src=""/
2) map:transform type="sql"/ 3) 
map:transform src=""/ 
map:serialize//map:match/map:pipeline

1) take the 
database.xml
2) excecute the SQL Statement - that will 
produce XML 
3) your transformation. BASED on everything 
before!

Try the following:

map:pipelinemap:match 
pattern="database" map:generate 
src=""/
 map:transform type="sql"/!-- 
map:transform src=""/-- 
map:serialize//map:match/map:pipeline

then you see what you have to transform! See the 
source code (browser right click) and copy it to the Spy. from there you can 
copy the XPath. 
...and then you *just* have to go 
on!

Hope that helps!
Thorsten

  -Ursprüngliche Nachricht-Von: Richard Cunliffe 
  [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 12. März 2003 
  18:47An: [EMAIL PROTECTED]Betreff: RE: SQL RE: 
  2 (should be) easy questions
  
  Thorsten,
  
  Ok the following 
  statement is trying to display the results of the query from the MySQL 
  database in a table, I dont know if this is right.
  
  What are 
  you trying to do with, anyway:
  xsl:for-each 
  select="query"xsl:for-each 
  select="execute-query"xsl:apply-templates//xsl:for-each/xsl:for-each
  
  
  The code looks 
  complicated, because I am using XML Spy designer which allows you to put 
  together your style sheet visually, with the aid of the DTD. The code above 
  was the XML Spys way of trying to represent it from the 
DTD.
  
  I have attached my 
  xml, xsl, and dtd for you to have a look at to get a better 
  understanding.
  
  Many 
  thanks,
  
  Richard.
  


AW: SQL RE: 2 (should be) easy questions

2003-03-12 Thread Scherler, Thorsten



Hello 
again,

do you 
know the book "Cocoon: Building XML Applications" form Carsten Ziegeler  
Matthew Langham [ISBN of the book (0735712352)]?

Here 
is an example as attachment (hope that is allright with you, 
CarstenMatthew) about SQL.

King 
regards
Thorsten

  -Ursprüngliche Nachricht-Von: Scherler, Thorsten 
  Gesendet: Mittwoch, 12. März 2003 19:58An: 
  [EMAIL PROTECTED]Betreff: AW: SQL RE: 2 (should be) easy 
  questions
  I 
  had a glance at your code, do you use the SPY as well to show the 
  result?
  
  I 
  guess not! I am using the SPY as well. 
  
  Ok, 
  correct me if I am wrong! I aspect your pipeline looks like that (because I 
  guess you are using cocoon to transform):
  map:pipelinemap:match 
  pattern="database" map:generate 
  src=""/ map:transform type="sql"/ 
  map:transform src=""/ 
  map:serialize//map:match/map:pipeline
  
  Is 
  that right? If not - it should look like that!
  
  Explanation:
  map:pipelinemap:match 
  pattern="database" 1) map:generate 
  src=""/
  2) map:transform type="sql"/ 3) 
  map:transform src=""/ 
  map:serialize//map:match/map:pipeline
  
  1) take the 
  database.xml
  2) excecute the SQL Statement - that will 
  produce XML 
  3) your transformation. BASED on everything 
  before!
  
  Try the following:
  
  map:pipelinemap:match 
  pattern="database" map:generate 
  src=""/
   map:transform type="sql"/!-- 
  map:transform src=""/-- 
  map:serialize//map:match/map:pipeline
  
  then you see what you have to transform! See 
  the source code (browser right click) and copy it to the Spy. from there you 
  can copy the XPath. 
  ...and then you *just* have to go 
  on!
  
  Hope that helps!
  Thorsten
  
-Ursprüngliche Nachricht-Von: Richard Cunliffe 
[mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 12. März 2003 
18:47An: [EMAIL PROTECTED]Betreff: RE: SQL 
RE: 2 (should be) easy questions

Thorsten,

Ok the following 
statement is trying to display the results of the query from the MySQL 
database in a table, I dont know if this is right.

What 
are you trying to do with, anyway:
xsl:for-each 
select="query"xsl:for-each 
select="execute-query"xsl:apply-templates//xsl:for-each/xsl:for-each


The code looks 
complicated, because I am using XML Spy designer which allows you to put 
together your style sheet visually, with the aid of the DTD. The code above 
was the XML Spys way of trying to represent it from the 
DTD.

I have attached my 
xml, xsl, and dtd for you to have a look at to get a better 
understanding.

Many 
thanks,

Richard.



example.zip
Description: example.zip
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: esql nested queries

2003-03-11 Thread Scherler
Tim,

thank you very much!

belongs on users. - you are right (the first to dev was a mistake)



Tim Myers wrote:

Thorsten,

This message belongs on users.

You can't nest that way because as soon as you hit the nested execute-query
everything from the outer query is pushed onto a stack and is inaccessible.
You need a xsp:logicint ap_id = esql:get-int column=id/ before the 
inner query begins and then use xsp:exprap_id/xsp:expr in the inner query
to recall it.

Tim

On Mon, Mar 10, 2003 at 05:36:05PM +0100, Scherler, Thorsten wrote:
 

Hello group,

I am using cocoon 2.0.4.

I tried the following the nested esql (not working):

esql:connection
esql:poolINSTA/esql:pool
esql:execute-query
esql:query
select * from xml_verkauf 
/esql:query
esql:results
esql:row-results
data
client
ep1
esql:get-int column=ap_id/
/ep1
/client
aps
esql:execute-query
esql:query
 select * from ap_tab where ap_id =esql:get-int column=ap_id/ 
/esql:query
esql:results
esql:row-results
ap
esql:get-columns/
/ap
/esql:row-results
/esql:results
esql:no-resultsno-results//esql:no-results
esql:error-results/
/esql:execute-query
/aps
/data
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection

As soon as I change 
...
 select * from ap_tab where ap_id =1 
I can nest the query!

Why can I not use esql:get-int column=ap_id/ ?

King regards

   

Mit freundlichem Gruss,

Thorsten Scherler
Marketing / Telefonmarketing
Weidmüller GmbH  Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


AW: esql nested queries

2003-03-10 Thread Scherler, Thorsten
Hello Leo, 

it is not working either.

But I think I know why that happends:
in my source code there is the following:
client ap_id=#10;645#10;
if I us a attribute.

I think because of #10; I get no match for the second query!

Can that be?

-Ursprüngliche Nachricht-
Von: leo leonid [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries


try this:

esql:get-int column=ap_id ancestor=1/
  ---

/Leo
On Montag, März 10, 2003, at 05:36  Uhr, Scherler, Thorsten wrote:

 Hello group,

 I am using cocoon 2.0.4.

 I tried the following the nested esql (not working):

 esql:connection
 esql:poolINSTA/esql:pool
 esql:execute-query
 esql:query
  select * from xml_verkauf
  /esql:query
 esql:results
 esql:row-results
 data
 client
 ep1
 esql:get-int column=ap_id/
 /ep1
 /client
 aps
 esql:execute-query
 esql:query
   select * from ap_tab where ap_id =esql:get-int 
 column=ap_id/
 /esql:query
 esql:results
 esql:row-results
 ap
 esql:get-columns/
 /ap
 /esql:row-results
 /esql:results
 esql:no-resultsno-results//esql:no-results
 esql:error-results/
 /esql:execute-query
 /aps
 /data
 /esql:row-results
 /esql:results
 esql:no-results/
 esql:error-results/
 /esql:execute-query
 /esql:connection

 As soon as I change
 ...
   select * from ap_tab where ap_id =1
  I can nest the query!

 Why can I not use esql:get-int column=ap_id/ ?

 King regards

 Mit freundlichem Gruss,

 Thorsten Scherler
 Marketing / Telefonmarketing

 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



AW: esql nested queries

2003-03-10 Thread Scherler, Thorsten
Anyway,

how many ways for sql are there?

I found 3 different, what's the point in that?

I am confused (again!)

King regards

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Montag, 10. März 2003 18:12
An: Cocoon-Users (E-Mail)
Betreff: AW: esql nested queries


Hello Leo, 

it is not working either.

But I think I know why that happends:
in my source code there is the following:
client ap_id=#10;645#10;
if I us a attribute.

I think because of #10; I get no match for the second query!

Can that be?

-Ursprüngliche Nachricht-
Von: leo leonid [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries


try this:

esql:get-int column=ap_id ancestor=1/
  ---

/Leo
On Montag, März 10, 2003, at 05:36  Uhr, Scherler, Thorsten wrote:

 Hello group,

 I am using cocoon 2.0.4.

 I tried the following the nested esql (not working):

 esql:connection
 esql:poolINSTA/esql:pool
 esql:execute-query
 esql:query
  select * from xml_verkauf
  /esql:query
 esql:results
 esql:row-results
 data
 client
 ep1
 esql:get-int column=ap_id/
 /ep1
 /client
 aps
 esql:execute-query
 esql:query
   select * from ap_tab where ap_id =esql:get-int 
 column=ap_id/
 /esql:query
 esql:results
 esql:row-results
 ap
 esql:get-columns/
 /ap
 /esql:row-results
 /esql:results
 esql:no-resultsno-results//esql:no-results
 esql:error-results/
 /esql:execute-query
 /aps
 /data
 /esql:row-results
 /esql:results
 esql:no-results/
 esql:error-results/
 /esql:execute-query
 /esql:connection

 As soon as I change
 ...
   select * from ap_tab where ap_id =1
  I can nest the query!

 Why can I not use esql:get-int column=ap_id/ ?

 King regards

 Mit freundlichem Gruss,

 Thorsten Scherler
 Marketing / Telefonmarketing

 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de





-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: AW: esql nested queries

2003-03-10 Thread Scherler
leo leonid wrote:

It looks like you stored your 'ap_id's enclosed within two carriage 
returns.
(#10; or #xA; are encoded CRs, AFAIK). So I'd recommend you strip 
you DB column from these CRs and change the data type for this column 
to INT)
Can you do that with normalize-space()?
esql:get-int column=normalize-space(ap_id)/
/Leo



On Montag, März 10, 2003, at 06:12  Uhr, Scherler, Thorsten wrote:

Hello Leo,

it is not working either.

But I think I know why that happends:
in my source code there is the following:
client ap_id=#10;645#10;
if I us a attribute.
I think because of #10; I get no match for the second query!

Can that be?

-Ursprüngliche Nachricht-
Von: leo leonid [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 10. März 2003 17:54
An: [EMAIL PROTECTED]
Betreff: Re: esql nested queries
try this:

esql:get-int column=ap_id ancestor=1/
  ---
/Leo
On Montag, März 10, 2003, at 05:36  Uhr, Scherler, Thorsten wrote:
Hello group,

I am using cocoon 2.0.4.

I tried the following the nested esql (not working):

esql:connection
esql:poolINSTA/esql:pool
esql:execute-query
esql:query
 select * from xml_verkauf
 /esql:query
esql:results
esql:row-results
data
client
ep1
esql:get-int column=ap_id/
/ep1
/client
aps
esql:execute-query
esql:query
  select * from ap_tab where ap_id =esql:get-int
column=ap_id/
/esql:query
esql:results
esql:row-results
ap
esql:get-columns/
/ap
/esql:row-results
/esql:results
esql:no-resultsno-results//esql:no-results
esql:error-results/
/esql:execute-query
/aps
/data
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
As soon as I change
...
  select * from ap_tab where ap_id =1
 I can nest the query!
Why can I not use esql:get-int column=ap_id/ ?

King regards

Mit freundlichem Gruss,

Thorsten Scherler
Marketing / Telefonmarketing
Weidmüller GmbH  Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


refering to: http://wiki.cocoondev.org/Wiki.jsp?page=Jars2exclude

2003-03-09 Thread Thorsten Scherler
Hello group,

I wrote a HowTo: http://wiki.cocoondev.org/Wiki.jsp?page=Jars2exclude

I would need some help with it. Can anyone please have a look.
Thank you very much!
King regards
Thorsten
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


[CreateMinimalWebapp] remove all the optional jars with a XSL-Transformation

2003-03-07 Thread Scherler, Thorsten
Hello group,

I created a minimal webapp and found the following remark from Geoff Howard in 
[1 href=http://wiki.cocoondev.org/Wiki.jsp?page=CreateMinimalWebapp;] 
CreateMinimalWebapp:
2. edit lib/jars.xml to comment out/remove all the optional jars except the ones noted 
above
1. could be done with an xsl transform
[/1]

I wrote 2 XSLT- files that are working fine to do the job, but I would like to have 
more intelligence (please see below):
The first xslt (jars2exclude.xsl [2]) checks the lib element  form the jars.xml 
whether it starts with  'optional/' (the dir to exclude files from).  If so they will 
be labeled 2exclude (there are exceptions - you will see later).
xsl:when test=starts-with(text(), 'optional/') [compare 2]
The jars.xml looks like this:
...
file
title/
description/
used-by/
libcore/jvm1.2/excalibur-datasource-vm12-20021121.jar/lib
homepage/
/file
...
The example file would not meet the criteria. The following would:
file
...
liboptional/servlet_2_2.jar/lib
...
file
But this certain file has to be left untouched [1] - this is one of n exceptions (2 
are mentioned in [1], but I need more-n exception). This is be done with 
xsl:choosexsl:when[2]. Here is an example of an exception:
xsl:when test=substring-after(text(), 'optional/')='servlet_2_2.jar'
xsl:value-of select=./
/xsl:when

The result of the transformation [2] will look like this:
file
titleXML Catalog Entity Resolver/title
...
lib2exclude/lib
...
/file
file
titleServlet API/title
...
liboptional/servlet_2_2.jar/lib
...
/file

Transforming this result with exclude2jars.xsl [3] will result in the new jar.xml 
(without the exclusions, but with the exceptions).

Ok, that is nice but I would prefer not to hard code the exceptions, e.g.:
substring-after(text(), 'optional/')='servlet_2_2.jar'
   ||   ||
|---| hard coded exception (e.g. |optional/|

I prefer to use something like jars2exclude.xml [4] where I declare the |---| hard 
coded exceptions. 
...
dir2excludeoptional//dir2exclude
exceptservlet_2_2.jar/except
...

..but how can I do that?

Have a look at sitemap.snippet [5] to install it on your local cocoon version.

Any help and any ideas welcome.

King regards
Thorsten

[1] http://wiki.cocoondev.org/Wiki.jsp?page=CreateMinimalWebapp
[2]  jars2exclude.xsl:
xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform;
xsl:template match=/
xsl:apply-templates/
/xsl:template
xsl:template match=jars
jars
xsl:apply-templates select=file/
/jars
/xsl:template
xsl:template match=file
file
xsl:apply-templates/
/file
/xsl:template
!--Parsing of value===--
xsl:template match=title
title
xsl:value-of select=./
/title
/xsl:template
xsl:template match=description
description
xsl:value-of select=./
/description
/xsl:template
xsl:template match=used-by
used-by
xsl:value-of select=./
/used-by
/xsl:template
!--==Excluding dir without the exceptions==--
xsl:template match=lib
lib
xsl:choose
xsl:when test=starts-with(text(), 'optional/')
xsl:choose
xsl:when test=substring-after(text(), 'optional/')='fop-0.20.4.jar'
xsl:value-of select=./
/xsl:when
xsl:when test=substring-after(text(), 
'optional/')='servlet_2_2.jar'
xsl:value-of select=./
/xsl:when
xsl:when test=substring-after(text(), 
'optional/')='commons-jxpath-1.0.jar'
xsl:value-of select=./
/xsl:when
xsl:otherwise2exclude/xsl:otherwise
/xsl:choose
/xsl:when
xsl:otherwise
xsl:value-of select=./
/xsl:otherwise
/xsl:choose
/lib
/xsl:template
xsl:template match=homepage
homepage
xsl:value-of select=./
/homepage
/xsl:template
/xsl:stylesheet
[/2] 
[3]exclude2jars.xsl:
?xml version=1.0 encoding=UTF-8?
xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform;
xsl:template match=/
xsl:apply-templates/
/xsl:template
xsl:template match=jars
xsl:comment
  Add an entry for each jar file used by Cocoon, following the other entries

  Author: Ovidiu Predescu [EMAIL PROTECTED]
  Date: May 23, 2002
  
jars2exclude have been used.
Author: Thorsten Scherler [EMAIL PROTECTED]
Date: March 06, 2003
This is the modified jars.xml.
/xsl:comment
jars
xsl:copy-of select=file[lib!='2exclude']/
/jars
/xsl:template
/xsl:stylesheet
[/3]
[4] jars2exclude.xml
?xml version=1.0

AW: Is there any way to use a scheduler with Cocoon ?

2003-02-26 Thread Scherler, Thorsten



Hello 
Vincent,

http://www.wyona.org/docs/xdocs/scheduler.html

wyona 
is a Open Source CMS and based on Cocoon and Java. 

Just 
have a look.

p.s. It will hopefullybecome lenya in the near 
future and part of 
ASF

King regards
Thorsten
-Ursprüngliche Nachricht-Von: MAHE Vincent 
FTRD/DIH/REN [mailto:[EMAIL PROTECTED]Gesendet: 
Mittwoch, 26. Februar 2003 11:09An: 
[EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Betreff: 
Is there any way to use a scheduler with Cocoon ?

  Has anyone managed 
  to integrate a Java scheduler in a webapp using Cocoon 2.0 
  ?
  
  Some people 
  (Martin Holz for instance) on the net are talking about Jakarta CornerStone 
  Scheduler but I can't find any example.
  
  Vincent
  


WG: Is there any way to use a scheduler with Cocoon ?

2003-02-26 Thread Scherler, Thorsten



Hello 
group,

is 
there a way to integrate our scheduler into a cocoon app without installing the 
whole wyona cms dist.?

Please 
have a look on the following mail!

Thank 
you very much!

-Ursprüngliche Nachricht-Von: MAHE Vincent 
FTRD/DIH/REN [mailto:[EMAIL PROTECTED]Gesendet: 
Mittwoch, 26. Februar 2003 12:41An: 
[EMAIL PROTECTED]Betreff: RE: Is there any way to use a 
scheduler with Cocoon ?
Hello,

Yes 
but I need to install the whole Wyona whereas I'm only interested in the 
scheduler.
My 
webapp has nothing to do with a Content Management and Publishing 
System.

I just 
want to use the scheduler of Wyona in my webapp ... do you have any simple 
integration example ?

Vincent

  -Message d'origine-De: Scherler, Thorsten 
  [mailto:[EMAIL PROTECTED]Envoyé: mercredi 26 
  février 2003 11:15À: 
  [EMAIL PROTECTED]Objet: AW: Is there any way to use 
  a scheduler with Cocoon ?
  Hello Vincent,
  
  http://www.wyona.org/docs/xdocs/scheduler.html
  
  wyona is a Open Source CMS and based on Cocoon and Java. 
  
  
  Just 
  have a look.
  
  p.s. It will hopefullybecome lenya in the near 
  future and part of 
  ASF
  
  King regards
  Thorsten
  -Ursprüngliche Nachricht-Von: MAHE Vincent 
  FTRD/DIH/REN [mailto:[EMAIL PROTECTED]Gesendet: 
  Mittwoch, 26. Februar 2003 11:09An: 
  [EMAIL PROTECTED]Cc: 
  [EMAIL PROTECTED]Betreff: Is there any way to use a scheduler with 
  Cocoon ?
  
Has anyone 
managed to integrate a Java scheduler in a webapp using Cocoon 2.0 
?

Some people 
(Martin Holz for instance) on the net are talking about Jakarta CornerStone 
Scheduler but I can't find any example.

Vincent



AW: is tomcat a bad choice? (Re: alternative to tomcat?)

2003-02-20 Thread Scherler, Thorsten
G'day!

I have asked the question (alternative to tomcat?) and I will switch to jetty as well 
with the next version of my app!

My reasons are:
- faster (less ressources needed)
- liable (last 14 days tomcat crashed 14 times :()
- less overhead
- ...

And finally, wouldn't it be wise to add a cocoon with
Jetty page in CocoonCompetenceCenter ? ;-)

Yes, I think that will be a good idea. 

+1

King regards
Thorsten

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Scheduler with cocoon

2003-02-14 Thread Scherler, Thorsten
Hi list,

do you know wyona (http://www.wyona.org)?

They have implemended a scheduler! Just ask them for advice ! ([EMAIL PROTECTED])

king regards
Thorsten

-Ursprüngliche Nachricht-
Von: Niclas Hedhman [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 14. Februar 2003 07:11
An: [EMAIL PROTECTED]
Betreff: Re: Scheduler with cocoon


On Friday 14 February 2003 05:17, Guenther Schmidt wrote:
 provided you're using Linix, you might want to create a cron job a'la wget
 http://url that triggers your pipeline.

If you are not Linux expert, but using it more casually, the above can seem a 
bit cryptic.

cron is a time scheduler in Linux, which executes shell scripts according to 
settings in a table. Most Linux Distros has a default cron configuration that 
is pretty is to use. For RedHat, create a sheel script and place it in 
/etc/cron.daily, and it will execute once a day (think it is in the middle of 
night).

The script should look like this;

#!/bin/sh
#

wget http://www.mydomain.com/cocoon/theResource

and I think you need to set the x flag on the script file, such as;

chmod +x mydailyrequest.sh


That should be crystal clear.

 This is just a fallback possibility if nobody comes up with a better
 answer.

I think this is a perfect solution, as cron is extremely reliable.

 Guenther (turning 35 in 2.5 hours)

Niclas , turned 35 29680 hours ago ;o)   New yardstick for age?

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Meeting in cologne!

2003-02-14 Thread Scherler, Thorsten
Hi list, hi Hussayn,

how many people want to come to cologne so far?

When should the event take place?

Where should it be?

How can we help you organise it?

Any proposals for the agenda so far?

...I volunteer for organisation.

King regards
Thorsten

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Meeting in cologne!

2003-02-14 Thread Scherler, Thorsten
Ok, I will contact you as soon as I am home.

By the way my private mail is [EMAIL PROTECTED]

Wir sprechen uns dann später!

Thorsten

-Ursprüngliche Nachricht-
Von: SAXESS - Hussayn Dabbous [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 14. Februar 2003 13:55
An: [EMAIL PROTECTED]
Betreff: Re: Meeting in cologne!


Hy, Thorsten.

thanks for your offer. Great, i think some help
is really needed, let's get into touch offlist.


Here is a first proposal for agenda,timeshedule,location...
There is still some commitment needed for talks,
or other contribs ;-)


the aim of the meeting
--
Preliminary i see this as a possibillity to get
together, see what others are doing whith cocoon,
brainstorming, generating new ideas, ...
The meeting could be setup as a one day workshop.
The topics are not yet completely specified, but there
is a promising preliminary commitment available(see below).
The results shall be published in an convenient form,
possibly in this list as summary, or if applicable as
a collection of ppt's, docs, whatever on the Wiki? ...


possible types of activities

freely collected from all inputs i got so far:

I workshop activities
- basics (history, future, concepts)
- cocoon for admins (setup, maintenacne)
- best practices

II information exchange
- use of cocoon in business apps
- use cases What do you use Cocoon for?

III open issues with cocoon
- Howto to improve cocoon documentation


First proposal for an agenda:
-

begin around 9:30 in the morning ?

1 warm up (30 minutes)
   - who are you?
   - What are you doing with cocoon? (very short!)

2 Hot spot (Mathew,Carsten, 30 minutes (is this enough time?))
   Mathew or Carsten will try to attend the meeting.
   Mathew agreed on preparing a talk about Sunshine Portal.

3 talk about one or two active projects (2*30 minutes, N.N)
   getting insight into the project and how cocoon is used.
   content is mainly up to the talker ...

4 questions and answers (60 minutes)
   much like within the cocoon-users list, but face to face ...

Break for lunch

5 brain storming ( ??? )
   what would help us to get more out of cocoon ?

6 ???


possible dates for the meeting
--
Various constraints apply. From what i got so far, we should setup
a meeting on monday, or friday, but not during Karneval. Currently
the time interval is moving towards the first two weeks in March,
hence we keep with 4 possible days ;-) any further restrictions apply?

location, further organisational issues
---
In my company i can arrange a room for about 10 persons.
It would be great if someone had a beamer at hand.
I can supply a huuuge whiteboard.
For lunch i can arrange something near the company location
(10 minutes to walk)
And after the meeting we'll see then ...
If anyone wants to stay overnight, just give me a note. I can
arrange something for you.


I have setup a mailinglist for this meeting issues to keep
the cocoon-users list free from this stuff. i'm still not
fully convinced, if this was a good idea...

So far there are 13 interested people on the list:

[EMAIL PROTECTED]

If others are also interested, please send me a note. Ill put
you on the list too.

But if the list keeps on growing as it does so far,
we will need to look for another location ;-)

regards, Hussayn



Scherler, Thorsten wrote:
 Hi list, hi Hussayn,
 
 how many people want to come to cologne so far?
 
 When should the event take place?
 
 Where should it be?
 
 How can we help you organise it?
 
 Any proposals for the agenda so far?
 
 ...I volunteer for organisation.
 
 King regards
 Thorsten
 
 
Mit freundlichem Gruss,

Thorsten Scherler
Marketing / Telefonmarketing

Weidmüller GmbH  Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de


 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 

-- 
Dr. Hussayn Dabbous
SAXESS Software Design GmbH
Neuenhöfer Allee 125
50935 Köln
Telefon: +49-221-56011-0
Fax: +49-221-56011-20
E-Mail:  [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL

Re: Experiences with Cocoon Microsoft SQLServer?

2003-02-14 Thread Thorsten Scherler
Hi Felix,

I tried it but didn't like the result!

e.g. the Select * from table were working fine, but I had trouble with 
 Update, insert into,

Despite that I never got it working that I could got the data where 
date=xsp-parameter-request .../. I wasn't patient enough to get to 
the course.

...but it should work fine because of thje cocoon data layer.

Personally I recommend Oracle (if you have the money) or MySQL (pretty 
fast ;-)).

Don't use the MS SQL stuff (my personal opinion) it's garbage!

King regards
Thorsten



Felix Maeder wrote:
Hi list,

Does anyone use Cocoon in connection with Microsoft SQLServer in a 
production environment? What are the experiences? Are there any known 
issues with this combination?

Thanks a lot
-Felix


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: cocoon on SunOne?

2003-02-12 Thread Scherler, Thorsten
I am not quite sure but I guess:

Root Cause 
java.security.AccessControlException: access denied
(java.lang.RuntimePermission createSecurityManager)

it has something to do with your Permission setting and I think they reside on your 
server.

...but it is just a guess!

King regards
Thorsten

-Ursprüngliche Nachricht-
Von: Tsui, Alban [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 12. Februar 2003 13:11
An: [EMAIL PROTECTED]
Betreff: cocoon on SunOne?


hi 
I have compiled cocoon2.0.3 with jdk1.4 as a war and tried to deploy it to
SunOne app server. When I hit the page:
http://localhost:81/cocoon
I got the following error:
Type: Exception Report

Message: Internal Server Error
Exception 
javax.servlet.ServletException: Servlet.init() for servlet Cocoon2 threw
exception
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:94
9)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:658)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:229)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:212)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203
)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.ja
va:157)
at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)

Root Cause 
java.security.AccessControlException: access denied
(java.lang.RuntimePermission createSecurityManager)
at
java.security.AccessControlContext.checkPermission(AccessControlContext.java
:270)
at
java.security.AccessController.checkPermission(AccessController.java:401)
at
java.lang.SecurityManager.checkPermission(SecurityManager.java:542)
at java.lang.SecurityManager.(SecurityManager.java:298)
at
org.apache.cocoon.util.log.CocoonLogFormatter$CallStack.(CocoonLogFormatter.
java:99)
at
org.apache.cocoon.util.log.CocoonLogFormatter.(CocoonLogFormatter.java:127)
at
org.apache.cocoon.servlet.CocoonServlet.initLogger(CocoonServlet.java:730)
at
org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:262)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:92
1)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:658)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:229)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:212)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203
)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)
at
com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.ja
va:157)
at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)

Is this something to do with my cocoon or with my SunONE settings? Any help
would be appreciated.
Alban


This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: anyone interested in a cocoon-users meeting in Köln/germany ?

2003-02-11 Thread Thorsten Scherler
Hi Hussayn,

I would be interested.

Agenda:
- welcome
- basics (history, future, concepts)
- use of cocoon in business apps
- ...

...did you though about something like this?

King regards
Thorsten

SAXESS - Hussayn Dabbous wrote:

Hy;

If there is interest, i could organise something in Köln.
(maybe not as nice a place as some of you offered in this list ;-) )
Just send me a note (possibly include a proposal for an agenda ... )

regards, Hussayn




-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




XSP TransformCustomDate [was: Re: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?]

2003-02-02 Thread Scherler, Thorsten
Hello everyone,

after all the help I received from you I wrote a little How-to about transforming a 
custom date string to a valid Java Date object.

Please have a look at http://wiki.cocoondev.org/Wiki.jsp?page=XSPTransformCustomDate.

It is more or less the conclusion off the thread xsp-element equivalent to 
xsl:param? and some other that I have posted in regards to the topic.
I would like to thank especially Andrew Timberlake for being so patient.

Hope that will cut down developing time for you ;-).

King regards


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




[OFF TOPIC] Are there any spanish cocoon user|developer?

2003-02-01 Thread Thorsten Scherler
Hello everyone,
I would like to know:
Are there users|developers in Spain which are using|developing cocoon?
...I thought this would be the best place to ask. ;-)

King regards
Thorsten


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-02-01 Thread Thorsten Scherler
Hello Andrew,

how is weather in SA? Here in Germany it is snowing!

Please see my answer below:


But the people using the app that I am writing don't want type 01/30/2003 to get the reports.
The main reason is that the company that I am working for is in Germany. So the user wants to put 30.01.2003 in the form.
If I parse that into the esql I can't get any data out of db.


So to avoid worring about the format the user uses,
I could use a JavaScript with my html-Form:
1) input type=text name=date31.01.2003/input
2) transform that date before submit - result: 01/31/2003
3) request it with ?date=01/31/2003
4) ...and had no problems.

I'm not sure if you've understood the esql:parameter concept fully.
Using the esql parameter will result in java code that looks something
like the following:

...

When using code like this, you don't have to worry about the format the
database engine uses, you only have to worry about the format the user
uses and parse that into a Date object.


You are right! I think that is the actual problem.

The parsed date in the request (?date=01/31/03) is a string!

That was the conclusion the let me to the following code (date.xsp). I 
assume the request is ?date=30.01.2002 (datePattern = dd.MM.).

xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xsp:structure
xsp:includejava.util.*/xsp:include
xsp:includejava.text.*/xsp:include
/xsp:structure
document
xsp:logic
String datePattern = dd.MM.;
SimpleDateFormat dateFormat = new SimpleDateFormat( datePattern );
String sDate_one = 31.01.2002;
String sDate_two = request.getParameter(date);
Date date_one = null;
try
   {
   date_one = dateFormat.parse( sDate_two );
   }
   catch( ParseException e )
   {
 getLogger().error(XSP date error: , e);
}
/xsp:logic
request
xsp:exprsDate_two/xsp:expr
/request
transformed
xsp:exprdate_one/xsp:expr
/transformed
static
xsp:exprsDate_one/xsp:expr
/static
/document
/xsp:page

Thanks again for all the help and your time!

King regards
Thorsten
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xsp:structure
xsp:includejava.util.*/xsp:include
xsp:includejava.text.*/xsp:include
/xsp:structure
document
xsp:logic
 String datePattern = dd.MM.;
   SimpleDateFormat dateFormat = new SimpleDateFormat( datePattern );
   
   String sDate_one = 31.01.2002;
   String sDate_two = request.getParameter(date);
   
   Date date_one = null;
try
   {
   date_one = dateFormat.parse( sDate_two );
   }
   catch( ParseException e )
   {
 getLogger().error(XSP date error: , e);
}   
/xsp:logic
request
xsp:exprsDate_two/xsp:expr
/request
transformed
xsp:exprdate_one/xsp:expr
/transformed
static
xsp:exprsDate_one/xsp:expr
/static
/document
/xsp:page


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


Re: substring-before()

2003-01-31 Thread Thorsten Scherler
Thanks!

Joerg Heinicke wrote:

Thorsten Scherler wrote:


Jupp, thanks!

What would be an appropriate XSLT forum?

Any recommendations?



http://www.mulberrytech.com/xsl/xsl-list/

Joerg


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]





-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: date translation

2003-01-31 Thread Scherler, Thorsten
xsl:value-of select=translate($your-date, '/', '.') /

Would be if only I
need to change all the '/' into '.'

-Ursprüngliche Nachricht-
Von: Konstantin Piroumian [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 08:57
An: [EMAIL PROTECTED]
Betreff: Re: date translation


Yes, that's it.

Another option could be to use the XSLT translate() function if you only
need to change all the '/' into '.' in your date string:

xsl:value-of select=translate($your-date, '/', '.') /.

This way you can do it in XSLT.

--
  Konstantin

- Original Message -
From: Scherler, Thorsten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 20:28
Subject: AW: date translation


Thanks!

I found:
http://xml.apache.org/cocoon1/xsp.html


-Ursprüngliche Nachricht-
Von: Joerg Heinicke [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 30. Januar 2003 17:57
An: [EMAIL PROTECTED]
Betreff: Re: date translation


Only a comment:

Using

xsl:param name=any
 xsl:value-of select=anyExpression/
/xsl:param

is mostly not the optimum. It will create a Result Tree Fragment, where
it is not needed. Using

xsl:param name=any select=anyExpression/

is shorter and is of a normal data type like node set, string or
number. While working with strings it's only a question of conversions
the processor has to do. But when working with node sets it can be
really a problem:

xsl:param name=any
 xsl:copy-of select=anyExpressionThatReturnsANodeset/
/xsl:param

You can't operate on $any like on a node set. Only string operatrions
are allowed. So for example $any/path/to/a/node is not possible.

Another problem:

xsl:variable name=emptyString select=''/

xsl:variable name=emptyRTF
   xsl:value-of select=''/
/xsl:variable

xsl:if test=$emptyString/  == false
xsl:if test=$emptyRTF/ == true

You can't test that simply on the emptyness of a RTF, because it returns
always true. You must explicitely convert it into a string via
test=string($emptyRTF).

http://www.w3.org/TR/xslt#section-Result-Tree-Fragments

So in general it's better to avoid RTFs.

Regards,

Joerg

Scherler, Thorsten wrote:
 Hello group,

 if anybody need a date translation, here it is:

 e.g. test.html?date=29.1.2003 (like we write in Germany) will be
1/29/2003.

 xsl:param name=date/
 xsl:param name=GETdayxsl:value-of
select=substring-before($date,'.')/ /xsl:param
 xsl:param name=GETmonth_yearxsl:value-of
select=substring-after($date,'.')//xsl:param
 xsl:param name=GETmonthxsl:value-of
select=substring-before($GETmonth_year,'.')/ /xsl:param
 xsl:param name=GETyearxsl:value-of
select=substring-after($GETmonth_year,'.')/ /xsl:param
 ...
 xsl:value-of select=$GETmonth//xsl:value-of
select=$GETday//xsl:value-of select=$GETyear/

 King regards


Mit freundlichem Gruss,

Thorsten Scherler


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]



-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello group,

is there an equivalent in xsp to the xsl: xsl:param name=date/?

e.g. guess my request is like that: ...?date=30%2F01%2F2003.

And 
esql:query
 select * from info_bericht  where Info_datum = #xsp-request:get-parameter 
name=date/#
 /esql:query
is working fine.

But xsp-request:get-parameter name=date/ can't be used in xsp:logic/ like that:
xsp:logic
String timeOfDay = (
  new SimpleDateFormat(MM/dd/)
).format(xsp-request:get-parameter name=date/);
  /xsp:logic

If I do that I get:
type fatal
message Language Exception
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error while instantiating 
org\apache\cocoon\www\logic\IDC2_info_int_xsp: java.lang.NullPointerException

King regards for any help!

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:479)
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp:
Line 251, column 0:  illegal start of type
Line 105, column 11:  class org.apache.cocoon.www.logic.IDC2_info_int_xsp should be 
declared abstract; it does not define method generate() in class 
org.apache.cocoon.generation.AbstractGenerator
Line 0, column 0: 
2 errors


-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 13:39
An: [EMAIL PROTECTED]
Betreff: Re: xsp-element equivalent to xsl:param?


On Fri, 2003-01-31 at 14:31, Scherler, Thorsten wrote:
 Hello group,
 
 is there an equivalent in xsp to the xsl: xsl:param name=date/?
Yes, see below

 
 e.g. guess my request is like that: ...?date=30%2F01%2F2003.
 
 And 
 esql:query
  select * from info_bericht  where Info_datum = #xsp-request:get-parameter 
name=date/#
  /esql:query
 is working fine.
 
 But xsp-request:get-parameter name=date/ can't be used in xsp:logic/ like that:
   xsp:logic
 String timeOfDay = (
   new SimpleDateFormat(MM/dd/)
 ).format(xsp-request:get-parameter name=date/);
   /xsp:logic

xsp:logic
try{
String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(parameters.getParameter(date);
}catch(Exception e){}
/xsp:logic

You will need to wrap the code in a try/catch block or alternatively use
the syntax: parameters.getParameter(date, default value of choice);

 
 If I do that I get:
 type fatal
 message Language Exception
 description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error while instantiating 
org\apache\cocoon\www\logic\IDC2_info_int_xsp: java.lang.NullPointerException
 
 King regards for any help!
 
  Mit freundlichem Gruss,
  
  Thorsten Scherler
  Marketing / Telefonmarketing
  
  Weidmüller GmbH  Co.
  P.O. Box 2807
  33058 Paderborn
  Tel.:+ 49 - 5252-960-350
  Fax:+ 49 - 5252-960-116
  eMail: [EMAIL PROTECTED]
  http://www.weidmueller.de
  
  
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
-- 
Andrew Timberlake [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello jan,

with the request I get a similar error like with the parameters.

But here are all the files:

my sitemap.xmap:
?xml version=1.0?
map:sitemap xmlns:map=http://apache.org/cocoon/sitemap/1.0;
!-- === Components  
--
map:components
map:generators default=file
map:generator label=content,data 
logger=sitemap.generator.file name=file pool-grow=4 pool-max=32 pool-min=8 
src=org.apache.cocoon.generation.FileGenerator/
map:generator label=content,data 
logger=sitemap.generator.serverpages name=xsp pool-grow=2 pool-max=32 
pool-min=4 src=org.apache.cocoon.generation.ServerPagesGenerator/
/map:generators
map:transformers default=xslt
map:transformer logger=sitemap.transformer.xslt name=xslt 
pool-grow=2 pool-max=32 pool-min=8 
src=org.apache.cocoon.transformation.TraxTransformer
use-request-parametersfalse/use-request-parameters

use-browser-capabilities-dbfalse/use-browser-capabilities-db
use-delifalse/use-deli
/map:transformer
/map:transformers
map:readers default=resource
map:reader logger=sitemap.reader.resource name=resource 
pool-max=32 src=org.apache.cocoon.reading.ResourceReader/
/map:readers
map:serializers default=html
map:serializer logger=sitemap.serializer.xml 
mime-type=text/xml name=xml src=org.apache.cocoon.serialization.XMLSerializer/
map:serializer logger=sitemap.serializer.html 
mime-type=text/html name=html pool-grow=4 pool-max=32 pool-min=4 
src=org.apache.cocoon.serialization.HTMLSerializer
buffer-size1024/buffer-size
/map:serializer
map:serializer name=fo2pdf 
src=org.apache.cocoon.serialization.FOPSerializer logger=sitemap.serializer.fo2pdf 
mime-type=application/pdf
!----
user-config src=/fonts/ci/config.xml/
/map:serializer
/map:serializers
map:matchers default=wildcard
map:matcher logger=sitemap.matcher.wildcard name=wildcard 
src=org.apache.cocoon.matching.WildcardURIMatcher/
/map:matchers
map:selectors/
map:actions
map:action name=form-validator 
src=org.apache.cocoon.acting.FormValidatorAction/
/map:actions
/map:components
map:views/
!-- === Components  
--
!-- === Pipelines  --
map:pipelines
map:pipeline
!-- === Weidmueller 
 --
!-- index --
map:match pattern=
map:redirect-to uri=start.html/
/map:match
!-- start --
map:match pattern=start.html
map:generate typ=xml src=docs/menu.xml/
map:transform src=stylesheets/html/menu2html.xsl
map:parameter name=use-request-parameters 
value=true/
/map:transform
map:serialize type=html/
/map:match
!-- test --
map:match pattern=test.html
map:generate typ=xml src=docs/test.xml/
map:transform src=stylesheets/html/test2html.xsl
map:parameter name=use-request-parameters 
value=true/
/map:transform
map:serialize type=html/
/map:match
snip/
!-- === 
IDC2 --
!-- WI_int200301IDC2  - Info_sofort--
map:match pattern=IDC2/info_int.xml
map:generate type=xsp 
src=logic/IDC2_info_int.xsp/
map:serialize type=xml/
/map:match
map:match pattern=IDC2/info_int.pdf
map:aggregate element=Container
map:part src=cocoon:/IDC2/info_int.xml/
/map:aggregate
map:transform 
src=stylesheets/pdf/IDC2/bericht_int.xsl/
  

AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Sorry jan, ...and thabks a lot for your help!

I posted the working one! ;-)

The NOT working logic/IDC2_info_int.xsp:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xsp:logic
try{
String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
}catch(Exception e){}
/xsp:logic
dataset
...

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 31. Januar 2003 13:54
An: [EMAIL PROTECTED]
Betreff: AW: xsp-element equivalent to xsl:param?


Hello jan,

with the request I get a similar error like with the parameters.

But here are all the files:

my sitemap.xmap:
?xml version=1.0?
map:sitemap xmlns:map=http://apache.org/cocoon/sitemap/1.0;
!-- === Components  
--
map:components
map:generators default=file
map:generator label=content,data 
logger=sitemap.generator.file name=file pool-grow=4 pool-max=32 pool-min=8 
src=org.apache.cocoon.generation.FileGenerator/
map:generator label=content,data 
logger=sitemap.generator.serverpages name=xsp pool-grow=2 pool-max=32 
pool-min=4 src=org.apache.cocoon.generation.ServerPagesGenerator/
/map:generators
map:transformers default=xslt
map:transformer logger=sitemap.transformer.xslt name=xslt 
pool-grow=2 pool-max=32 pool-min=8 
src=org.apache.cocoon.transformation.TraxTransformer
use-request-parametersfalse/use-request-parameters

use-browser-capabilities-dbfalse/use-browser-capabilities-db
use-delifalse/use-deli
/map:transformer
/map:transformers
map:readers default=resource
map:reader logger=sitemap.reader.resource name=resource 
pool-max=32 src=org.apache.cocoon.reading.ResourceReader/
/map:readers
map:serializers default=html
map:serializer logger=sitemap.serializer.xml 
mime-type=text/xml name=xml src=org.apache.cocoon.serialization.XMLSerializer/
map:serializer logger=sitemap.serializer.html 
mime-type=text/html name=html pool-grow=4 pool-max=32 pool-min=4 
src=org.apache.cocoon.serialization.HTMLSerializer
buffer-size1024/buffer-size
/map:serializer
map:serializer name=fo2pdf 
src=org.apache.cocoon.serialization.FOPSerializer logger=sitemap.serializer.fo2pdf 
mime-type=application/pdf
!----
user-config src=/fonts/ci/config.xml/
/map:serializer
/map:serializers
map:matchers default=wildcard
map:matcher logger=sitemap.matcher.wildcard name=wildcard 
src=org.apache.cocoon.matching.WildcardURIMatcher/
/map:matchers
map:selectors/
map:actions
map:action name=form-validator 
src=org.apache.cocoon.acting.FormValidatorAction/
/map:actions
/map:components
map:views/
!-- === Components  
--
!-- === Pipelines  --
map:pipelines
map:pipeline
!-- === Weidmueller 
 --
!-- index --
map:match pattern=
map:redirect-to uri=start.html/
/map:match
!-- start --
map:match pattern=start.html
map:generate typ=xml src=docs/menu.xml/
map:transform src=stylesheets/html/menu2html.xsl
map:parameter name=use-request-parameters 
value=true/
/map:transform
map:serialize type=html/
/map:match
!-- test --
map:match pattern=test.html
map:generate typ=xml src=docs/test.xml/
map:transform src=stylesheets/html/test2html.xsl
map:parameter name=use-request-parameters 
value=true/
/map:transform
map:serialize type=html/
/map:match
snip/
!-- === 
IDC2

AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Yes, I've noticed that as well but with
getParameter(date)); - same exception.

Thanks

-Ursprüngliche Nachricht-
Von: Geoff Howard [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 14:17
An: [EMAIL PROTECTED]
Betreff: RE: xsp-element equivalent to xsl:param?


Wast that cut and pasted?  It looks like you're missing an end ) - should
be:
  getParameter(date));

Geoff

 -Original Message-
 From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 31, 2003 7:48 AM
 To: [EMAIL PROTECTED]
 Subject: AW: xsp-element equivalent to xsl:param?


 Hello Andrew,

 with:
 xsp:logic
 try{
 String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(parameters.getParameter(date);
 }catch(Exception e){}
 /xsp:logic

 I get:

 type fatal

 message Language Exception

 description org.apache.cocoon.ProcessingException: Language
 Exception:
 org.apache.cocoon.components.language.LanguageException: Error
 compiling IDC2_info_int_xsp: Line 251, column 0: illegal start of
 type Line 105, column 11: class
 org.apache.cocoon.www.logic.IDC2_info_int_xsp should be declared
 abstract; it does not define method generate() in class
 org.apache.cocoon.generation.AbstractGenerator Line 0, column 0: 2 errors

 sender org.apache.cocoon.servlet.CocoonServlet

 source Cocoon servlet

 stack-trace

 org.apache.cocoon.ProcessingException: Language Exception:
 org.apache.cocoon.components.language.LanguageException: Error
 compiling IDC2_info_int_xsp:
 Line 251, column 0:  illegal start of type
 Line 105, column 11:  class
 org.apache.cocoon.www.logic.IDC2_info_int_xsp should be declared
 abstract; it does not define method generate() in class
 org.apache.cocoon.generation.AbstractGenerator
 Line 0, column 0:
 2 errors

   at
 org.apache.cocoon.components.language.generator.ProgramGeneratorIm
 pl.createResource(ProgramGeneratorImpl.java:340)
   at
 org.apache.cocoon.components.language.generator.ProgramGeneratorIm
 pl.load(ProgramGeneratorImpl.java:292)
   at
 org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPage
 sGenerator.java:198)
   at
 org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupP
 ipeline(AbstractEventPipeline.java:202)
   at
 org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(C
achingEventPipeline.java:278)
   at
 org.apache.cocoon.components.pipeline.CachingEventPipeline.generat
 eKey(CachingEventPipeline.java:141)
   at
 org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
 s(CachingStreamPipeline.java:317)
   at
 org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.i
 nvoke(SerializeNode.java:153)
   at
 org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
 gNode.invokeNodes(AbstractParentProcessingNode.java:85)
   at
 org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
 Node.invoke(PreparableMatchNode.java:156)
   at
 org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
 gNode.invokeNodes(AbstractParentProcessingNode.java:109)
   at
 org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
 voke(PipelineNode.java:140)
   at
 org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
 gNode.invokeNodes(AbstractParentProcessingNode.java:109)
   at
 org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
 nvoke(PipelinesNode.java:144)
   at
 org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
 reeProcessor.java:328)
   at
 org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
 reeProcessor.java:293)
   at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
   at
 org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:999)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
pplicationFilterChain.java:247)
   at
 org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
 onFilterChain.java:193)
   at
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
 erValve.java:260)
   at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
 text.invokeNext(StandardPipeline.java:643)
   at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.
 java:480)
   at
 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at
 org.apache.catalina.core.StandardContextValve.invoke(StandardConte
 xtValve.java:191)
   at
 org.apache.catalina.core.StandardPipeline$StandardPipelineValveCon
 text.invokeNext(StandardPipeline.java:643)
   at
 org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.
 java:480)
   at
 org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at
 org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
   at
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv
 e.java

AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello Jan,

I couldn't find the error.

But I attached it.

-Ursprüngliche Nachricht-
Von: Jan Harms [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 14:31
An: [EMAIL PROTECTED]
Betreff: AW: xsp-element equivalent to xsl:param?


Thorsten,

here is a tip that might be useful: When you get a message Error compiling foo.xsp 
you should have a look at the generated java class.

Like JSPs, XSPs are transformed into a .java source file. Afterwards cocoon tries to 
compile this .java file into a .class file. These files can be found in Tomcats (or 
your servlet-engines) work-directory. Search for a subdirectory called 

cocoon-files/org/apache/cocoon/www/

There you can find a foo_xsp.java file. Open this file and search for syntax errors 
(the exception contains a line number!). Sure it´s generated code, but quite readable.

-Jan


 -Ursprüngliche Nachricht-
 Von: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 14:09
 An: [EMAIL PROTECTED]
 Betreff: AW: xsp-element equivalent to xsl:param?
 
 
 Yes, I've noticed that as well but with
 getParameter(date)); - same exception.
 
 Thanks
 
 -Ursprüngliche Nachricht-
 Von: Geoff Howard [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 14:17
 An: [EMAIL PROTECTED]
 Betreff: RE: xsp-element equivalent to xsl:param?
 
 
 Wast that cut and pasted?  It looks like you're missing an 
 end ) - should
 be:
   getParameter(date));
 
 Geoff
 
  -Original Message-
  From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 31, 2003 7:48 AM
  To: [EMAIL PROTECTED]
  Subject: AW: xsp-element equivalent to xsl:param?
 
 
  Hello Andrew,
 
  with:
  xsp:logic
  try{
  String timeOfDay = (new
  
 SimpleDateFormat(MM/dd/)).format(parameters.getParameter
 (date);
  }catch(Exception e){}
  /xsp:logic
 
  I get:
 
  type fatal
 
  message Language Exception
 
  description org.apache.cocoon.ProcessingException: Language
  Exception:
  org.apache.cocoon.components.language.LanguageException: Error
  compiling IDC2_info_int_xsp: Line 251, column 0: illegal start of
  type Line 105, column 11: class
  org.apache.cocoon.www.logic.IDC2_info_int_xsp should be declared
  abstract; it does not define method generate() in class
  org.apache.cocoon.generation.AbstractGenerator Line 0, 
 column 0: 2 errors
 
  sender org.apache.cocoon.servlet.CocoonServlet
 
  source Cocoon servlet
 
  stack-trace
 
  org.apache.cocoon.ProcessingException: Language Exception:
  org.apache.cocoon.components.language.LanguageException: Error
  compiling IDC2_info_int_xsp:
  Line 251, column 0:  illegal start of type
  Line 105, column 11:  class
  org.apache.cocoon.www.logic.IDC2_info_int_xsp should be declared
  abstract; it does not define method generate() in class
  org.apache.cocoon.generation.AbstractGenerator
  Line 0, column 0:
  2 errors
 
  at
  org.apache.cocoon.components.language.generator.ProgramGeneratorIm
  pl.createResource(ProgramGeneratorImpl.java:340)
  at
  org.apache.cocoon.components.language.generator.ProgramGeneratorIm
  pl.load(ProgramGeneratorImpl.java:292)
  at
  org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPage
  sGenerator.java:198)
  at
  org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupP
  ipeline(AbstractEventPipeline.java:202)
  at
  org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(C
 achingEventPipeline.java:278)
  at
  org.apache.cocoon.components.pipeline.CachingEventPipeline.generat
  eKey(CachingEventPipeline.java:141)
  at
  org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
  s(CachingStreamPipeline.java:317)
  at
  org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.i
  nvoke(SerializeNode.java:153)
  at
  org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
  gNode.invokeNodes(AbstractParentProcessingNode.java:85)
  at
  org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatch
  Node.invoke(PreparableMatchNode.java:156)
  at
  org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
  gNode.invokeNodes(AbstractParentProcessingNode.java:109)
  at
  org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.in
  voke(PipelineNode.java:140)
  at
  org.apache.cocoon.components.treeprocessor.AbstractParentProcessin
  gNode.invokeNodes(AbstractParentProcessingNode.java:109)
  at
  org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.i
  nvoke(PipelinesNode.java:144)
  at
  org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
  reeProcessor.java:328)
  at
  org.apache.cocoon.components.treeprocessor.TreeProcessor.process(T
  reeProcessor.java:293)
  at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
  at
  
 org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.
 java:999)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853

AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello Andrew,

my final xsp should look like this:
...
dataset
  xsp:logic
 try{
 String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
}catch(Exception e){}
 /xsp:logic
esql:connection
esql:poolIDC2_int/esql:pool
esql:execute-query
esql:query
 select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
 /esql:query
...

like I stated before, as soon I get rid off the logic my query is successful.

Like you told me before my method now starts after the first xml element:

snip from IDC2_info_int_xsp.java
  /**
* Generate XML data.
*/
  public void generate() throws SAXException, IOException, ProcessingException {
  this.contentHandler.startDocument();
 AttributesImpl xspAttr = new AttributesImpl();

...

this.contentHandler.startElement(
  ,
  dataset,
  dataset,
  xspAttr
);
xspAttr.clear();


 this.characters(\n  );
  
 try{
 String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
}catch(Exception e){}
 
 this.characters(\n\t\t);
  ... 


-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 15:30
An: [EMAIL PROTECTED]
Betreff: Re: AW: xsp-element equivalent to xsl:param?


On Fri, 2003-01-31 at 16:09, Scherler, Thorsten wrote:
 Hello Jan,
 
 I couldn't find the error.
 
 But I attached it.
 
I was reading your previous post in which you posted your xsp source.
Instead of this:
esql:execute-query
esql:query
 select * from info_bericht  where country ='xsp-request:get-parameter
name=GETcountry/' AND  Info_datum = #xsp-request:get-parameter name=date/#
/esql:query

Try this:
esql:execute-query
esql:query
 select * from info_bericht  where country = 
esql:parameterxsp-request:get-parameter
name=GETcountry//esql:parameter AND  Info_datum = 
esql:parameterxsp-request:get-parameter name=date//esql:parameter
/esql:query

This will then use a PreparedStatement which is safer from possible SQL exploit.

Other than that, the XSP source didn't show where you were using the direct access to 
parameters.getParameter() or request.getParameter()

Andrew

Andrew


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
I found out that (1):
...
  xsp:logic
 String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(new Date());
 /xsp:logic
...
esql:query
 select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
 /esql:query
...

works fine!

BUT this (2/3/4) one is not working at all:
...
xsp:logic
 try{
String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(new Date());
 }catch(Exception e){}
 /xsp:logic
...
esql:query
 select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
 /esql:query
...

error:
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 371, column 9: variable timeOfDay not found in class 
org.apache.cocoon.www.logic.IDC2_info_int_xsp Line 0, column 0: 1 error 

AND (3) neither working:
...
  xsp:logic
 String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(parameters.getParameter(date));
 /xsp:logic
...

error:
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 302, column 62: unreported exception: 
org.apache.avalon.framework.parameters.ParameterException; must be caught or declared 
to be thrown Line 0, column 0: 1 error 

Nor (4):
...
  xsp:logic
 String timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
 /xsp:logic
...

error:
escription org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.IllegalArgumentException: Cannot format 
given Object as a Date

I don't have a clue!

Is there another way?

King regards

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Thanks,

but now I am not getting any results because is always timeOfDay = .

I will look into using esql:parameter tags.

Thanks for your patience.

-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 16:07
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: xsp-element equivalent to xsl:param?


Try this

...
dataset
   xsp:logic
  String timeOfDay = ;
  try{
 timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
  }catch(Exception e){}
   /xsp:logic
   
esql:connection
esql:poolIDC2_int/esql:pool
esql:execute-query
esql:query
select * from info_bericht  where country ='xsp-request:get-parameter
name=GETcountry/'   AND  Info_datum =
#xsp:exprtimeOfDay/xsp:expr#
/esql:query

I will mention again that you should look into using esql:parameter
tags.

Andrew

On Fri, 2003-01-31 at 16:46, Scherler, Thorsten wrote:
 Hello Andrew,
 
 my final xsp should look like this:
 ...
 dataset
   xsp:logic
  try{
  String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
 }catch(Exception e){}
  /xsp:logic
 esql:connection
 esql:poolIDC2_int/esql:pool
 esql:execute-query
 esql:query
  select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
  /esql:query
 ...
 
 like I stated before, as soon I get rid off the logic my query is successful.
 
 Like you told me before my method now starts after the first xml element:
 
 snip from IDC2_info_int_xsp.java
   /**
 * Generate XML data.
 */
   public void generate() throws SAXException, IOException, ProcessingException {
   this.contentHandler.startDocument();
  AttributesImpl xspAttr = new AttributesImpl();
 
 ...
 
 this.contentHandler.startElement(
   ,
   dataset,
   dataset,
   xspAttr
 );
 xspAttr.clear();
 
 
  this.characters(\n  );
   
  try{
  String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
 }catch(Exception e){}
  
  this.characters(\n\t\t);
   ... 
 
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 15:30
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: xsp-element equivalent to xsl:param?
 
 
 On Fri, 2003-01-31 at 16:09, Scherler, Thorsten wrote:
  Hello Jan,
  
  I couldn't find the error.
  
  But I attached it.
  
 I was reading your previous post in which you posted your xsp source.
 Instead of this:
 esql:execute-query
 esql:query
  select * from info_bericht  where country ='xsp-request:get-parameter
 name=GETcountry/' AND  Info_datum = #xsp-request:get-parameter name=date/#
 /esql:query
 
 Try this:
 esql:execute-query
 esql:query
  select * from info_bericht  where country = 
esql:parameterxsp-request:get-parameter
 name=GETcountry//esql:parameter AND  Info_datum = 
esql:parameterxsp-request:get-parameter name=date//esql:parameter
 /esql:query
 
 This will then use a PreparedStatement which is safer from possible SQL exploit.
 
 Other than that, the XSP source didn't show where you were using the direct access 
to parameters.getParameter() or request.getParameter()
 
 Andrew
 
 Andrew
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
-- 
Andrew Timberlake [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello everyone,

I hope I don't bother you.

At the moment only if I use xsp-request:get-parameter name=date/ I get the 
parameter.

Otherwise I get s**t (sorry for being rude, I spent now more than 12h)- nothing.

So is that a bug?

should I post to the dev-list?

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 31. Januar 2003 16:14
An: [EMAIL PROTECTED]
Betreff: AW: AW: AW: xsp-element equivalent to xsl:param?


Thanks,

but now I am not getting any results because is always timeOfDay = .

I will look into using esql:parameter tags.

Thanks for your patience.

-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 16:07
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: xsp-element equivalent to xsl:param?


Try this

...
dataset
   xsp:logic
  String timeOfDay = ;
  try{
 timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
  }catch(Exception e){}
   /xsp:logic
   
esql:connection
esql:poolIDC2_int/esql:pool
esql:execute-query
esql:query
select * from info_bericht  where country ='xsp-request:get-parameter
name=GETcountry/'   AND  Info_datum =
#xsp:exprtimeOfDay/xsp:expr#
/esql:query

I will mention again that you should look into using esql:parameter
tags.

Andrew

On Fri, 2003-01-31 at 16:46, Scherler, Thorsten wrote:
 Hello Andrew,
 
 my final xsp should look like this:
 ...
 dataset
   xsp:logic
  try{
  String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
 }catch(Exception e){}
  /xsp:logic
 esql:connection
 esql:poolIDC2_int/esql:pool
 esql:execute-query
 esql:query
  select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
  /esql:query
 ...
 
 like I stated before, as soon I get rid off the logic my query is successful.
 
 Like you told me before my method now starts after the first xml element:
 
 snip from IDC2_info_int_xsp.java
   /**
 * Generate XML data.
 */
   public void generate() throws SAXException, IOException, ProcessingException {
   this.contentHandler.startDocument();
  AttributesImpl xspAttr = new AttributesImpl();
 
 ...
 
 this.contentHandler.startElement(
   ,
   dataset,
   dataset,
   xspAttr
 );
 xspAttr.clear();
 
 
  this.characters(\n  );
   
  try{
  String timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
 }catch(Exception e){}
  
  this.characters(\n\t\t);
   ... 
 
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 15:30
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: xsp-element equivalent to xsl:param?
 
 
 On Fri, 2003-01-31 at 16:09, Scherler, Thorsten wrote:
  Hello Jan,
  
  I couldn't find the error.
  
  But I attached it.
  
 I was reading your previous post in which you posted your xsp source.
 Instead of this:
 esql:execute-query
 esql:query
  select * from info_bericht  where country ='xsp-request:get-parameter
 name=GETcountry/' AND  Info_datum = #xsp-request:get-parameter name=date/#
 /esql:query
 
 Try this:
 esql:execute-query
 esql:query
  select * from info_bericht  where country = 
esql:parameterxsp-request:get-parameter
 name=GETcountry//esql:parameter AND  Info_datum = 
esql:parameterxsp-request:get-parameter name=date//esql:parameter
 /esql:query
 
 This will then use a PreparedStatement which is safer from possible SQL exploit.
 
 Other than that, the XSP source didn't show where you were using the direct access 
to parameters.getParameter() or request.getParameter()
 
 Andrew
 
 Andrew
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
-- 
Andrew Timberlake [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED

AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
You're patience and so brilliant:
sitemap.log:
ERROR   (2003-01-31) 16:36.32:707   [sitemap.generator.serverpages] 
(/weidmueller-dev/IDC2/info_int.xml) Thread-9/IDC2_info_int_xsp: XSP date error: 
java.lang.IllegalArgumentException: Cannot format given Object as a Date
at java.text.DateFormat.format(DateFormat.java:265)
at java.text.Format.format(Format.java:116)

now you wrote:
If there is an error being thrown, then you are going to have to change
the request parameter value into a valid java.util.Date object.

my question: How? - I am so stupid when it comes to Java (or maybe in general ;-))

-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 16:27
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: AW: xsp-element equivalent to xsl:param?


I think that the request parameter is returning a string and the format
object is expecting a Date object. (I should have recognised this
earlier).
I think the XSP page is throwing an exception which we have been
ignoring. Try the following code and then check the sitemap.log and
errors.log (can't remember which one) file in /WEB-INF/logs/ for the
exception. You can do a find in the log file for XSP date error to
locate the error.
If there is an error being thrown, then you are going to have to change
the request parameter value into a valid java.util.Date object.

...
dataset
   xsp:logic
  String timeOfDay = ;
  try{
 timeOfDay = (new
SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
  }catch(Exception e){
getLogger().error(XSP date error: , e);
}
   /xsp:logic
   

On Fri, 2003-01-31 at 17:13, Scherler, Thorsten wrote:
 Thanks,
 
 but now I am not getting any results because is always timeOfDay = .
 
 I will look into using esql:parameter tags.
 
 Thanks for your patience.
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 16:07
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: AW: xsp-element equivalent to xsl:param?
 
 
 Try this
 
 ...
 dataset
xsp:logic
   String timeOfDay = ;
   try{
  timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
   }catch(Exception e){}
/xsp:logic

 esql:connection
 esql:poolIDC2_int/esql:pool
 esql:execute-query
 esql:query
 select * from info_bericht  where country ='xsp-request:get-parameter
 name=GETcountry/'   AND  Info_datum =
 #xsp:exprtimeOfDay/xsp:expr#
 /esql:query
 
 I will mention again that you should look into using esql:parameter
 tags.
 
 Andrew
 
 On Fri, 2003-01-31 at 16:46, Scherler, Thorsten wrote:
  Hello Andrew,
  
  my final xsp should look like this:
  ...
  dataset
xsp:logic
   try{
   String timeOfDay = (new
  SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
  }catch(Exception e){}
   /xsp:logic
  esql:connection
  esql:poolIDC2_int/esql:pool
  esql:execute-query
  esql:query
   select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
   /esql:query
  ...
  
  like I stated before, as soon I get rid off the logic my query is successful.
  
  Like you told me before my method now starts after the first xml element:
  
  snip from IDC2_info_int_xsp.java
/**
  * Generate XML data.
  */
public void generate() throws SAXException, IOException, ProcessingException {
this.contentHandler.startDocument();
   AttributesImpl xspAttr = new AttributesImpl();
  
  ...
  
  this.contentHandler.startElement(
,
dataset,
dataset,
xspAttr
  );
  xspAttr.clear();
  
  
   this.characters(\n  );

   try{
   String timeOfDay = (new
  SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
  }catch(Exception e){}
   
   this.characters(\n\t\t);
... 
  
  
  -Ursprüngliche Nachricht-
  Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
  Gesendet: Freitag, 31. Januar 2003 15:30
  An: [EMAIL PROTECTED]
  Betreff: Re: AW: xsp-element equivalent to xsl:param?
  
  
  On Fri, 2003-01-31 at 16:09, Scherler, Thorsten wrote:
   Hello Jan,
   
   I couldn't find the error.
   
   But I attached it.
   
  I was reading your previous post in which you posted your xsp source.
  Instead of this:
  esql:execute-query
  esql:query
   select * from info_bericht  where country ='xsp-request:get-parameter
  name=GETcountry/' AND  Info_datum = #xsp-request:get-parameter name=date/#
  /esql:query
  
  Try this:
  esql:execute-query
  esql:query
   select * from info_bericht  where country = 
esql:parameterxsp-request:get-parameter
  name=GETcountry//esql:parameter AND  Info_datum = 
esql:parameterxsp-request:get-parameter name=date//esql:parameter
  /esql:query
  
  This will then use a PreparedStatement which is safer from possible SQL exploit.
  
  Other than that, the XSP source didn't show where you were using the direct

AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Yes, I am doing that right now.

But the people using the app that I am writing don't want type 01/30/2003 to get the 
reports.
The main reason is that the company that I am working for is in Germany. So the user 
wants to put 30.01.2003 in the form.

If I parse that into the esql I can't get any data out of db.

I thought about client-side JavaScript to transform the date and then parse it, but I 
hoped that I could transform it on the server side with xsp.

You said something about: simply invert the process on the SimpleDateFormat object. 

How would I do that?

-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 16:50
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: AW: AW: xsp-element equivalent to xsl:param?


Thank you for the compliment but it was only through bumping my head
against many a brick wall that I learned anything.

To convert your string into a Date object, you simply invert the process
on the SimpleDateFormat object

Date myDate = (new
SimpleDateFormat(MM/dd/)).parse(request.getParameter(date));
This method needs the request parameter to arrive in the correct format
though and therefore invalidates the need to format the date in the way
you been up until now.

Now this is where the esql:parameter tag comes in handy. Instead of
using the #Formated dat string# format you can pass the date object
directly to the esql parameter:

esql:parameterxsp:exprmyDate/xsp:expr/esql:parameter

Andrew

On Fri, 2003-01-31 at 17:40, Scherler, Thorsten wrote:
 You're patience and so brilliant:
 sitemap.log:
 ERROR   (2003-01-31) 16:36.32:707   [sitemap.generator.serverpages] 
(/weidmueller-dev/IDC2/info_int.xml) Thread-9/IDC2_info_int_xsp: XSP date error: 
 java.lang.IllegalArgumentException: Cannot format given Object as a Date
   at java.text.DateFormat.format(DateFormat.java:265)
   at java.text.Format.format(Format.java:116)
 
 now you wrote:
 If there is an error being thrown, then you are going to have to change
 the request parameter value into a valid java.util.Date object.
 
 my question: How? - I am so stupid when it comes to Java (or maybe in general ;-))
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 16:27
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: AW: AW: xsp-element equivalent to xsl:param?
 
 
 I think that the request parameter is returning a string and the format
 object is expecting a Date object. (I should have recognised this
 earlier).
 I think the XSP page is throwing an exception which we have been
 ignoring. Try the following code and then check the sitemap.log and
 errors.log (can't remember which one) file in /WEB-INF/logs/ for the
 exception. You can do a find in the log file for XSP date error to
 locate the error.
 If there is an error being thrown, then you are going to have to change
 the request parameter value into a valid java.util.Date object.
 
 ...
 dataset
xsp:logic
   String timeOfDay = ;
   try{
  timeOfDay = (new
 SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
   }catch(Exception e){
 getLogger().error(XSP date error: , e);
 }
/xsp:logic

 
 On Fri, 2003-01-31 at 17:13, Scherler, Thorsten wrote:
  Thanks,
  
  but now I am not getting any results because is always timeOfDay = .
  
  I will look into using esql:parameter tags.
  
  Thanks for your patience.
  
  -Ursprüngliche Nachricht-
  Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
  Gesendet: Freitag, 31. Januar 2003 16:07
  An: [EMAIL PROTECTED]
  Betreff: Re: AW: AW: xsp-element equivalent to xsl:param?
  
  
  Try this
  
  ...
  dataset
 xsp:logic
String timeOfDay = ;
try{
   timeOfDay = (new
  SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
}catch(Exception e){}
 /xsp:logic
 
  esql:connection
  esql:poolIDC2_int/esql:pool
  esql:execute-query
  esql:query
  select * from info_bericht  where country ='xsp-request:get-parameter
  name=GETcountry/'   AND  Info_datum =
  #xsp:exprtimeOfDay/xsp:expr#
  /esql:query
  
  I will mention again that you should look into using esql:parameter
  tags.
  
  Andrew
  
  On Fri, 2003-01-31 at 16:46, Scherler, Thorsten wrote:
   Hello Andrew,
   
   my final xsp should look like this:
   ...
   dataset
 xsp:logic
try{
String timeOfDay = (new
   SimpleDateFormat(MM/dd/)).format(request.getParameter(date));
   }catch(Exception e){}
/xsp:logic
   esql:connection
   esql:poolIDC2_int/esql:pool
   esql:execute-query
   esql:query
select * from info_bericht  where country ='xsp-request:get-parameter 
name=GETcountry/'   AND  Info_datum = #xsp:exprtimeOfDay/xsp:expr#
/esql:query
   ...
   
   like I stated before, as soon I get rid off the logic my query is successful.
   
   Like you told me before my method now starts after the first xml element:
   
   snip from

AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Hello again,

I have shorten the xsp:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
xsp:logic
Date myDate = ;
try{
myDate = (new
SimpleDateFormat(dd.MM.).parse(request.getParameter(date));
String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  }catch(Exception e){
getLogger().error(XSP date error: , e);
}
/xsp:logic
test
xsp:exprmyDate /xsp:expr
/test
/dataset
/xsp:page

error (cocoon):
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 289, column 66: ')' expected Line 286, column -1: incompatible 
types Line 0, column 0: 2 errors 

IDC2_info_int_xsp.java:
snip/
this.characters(\n\t\t);
string myDate = ;
try{
myDate = (new
SimpleDateFormat(dd.MM.).parse(request.getParameter(date));
  }catch(Exception e){
getLogger().error(XSP date error: , e);
}

The Line 289, column 66 is (*): parse(request.getParameter(date)(*))

The sitemap.log and error.log don't have the XSP date error.


-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 17:08
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?


On Fri, 2003-01-31 at 17:59, Scherler, Thorsten wrote:
 Yes, I am doing that right now.
 
 But the people using the app that I am writing don't want type 01/30/2003 to get the 
reports.
 The main reason is that the company that I am working for is in Germany. So the user 
wants to put 30.01.2003 in the form.
 
 If I parse that into the esql I can't get any data out of db.
 
 I thought about client-side JavaScript to transform the date and then parse it, but 
I hoped that I could transform it on the server side with xsp.
 
 You said something about: simply invert the process on the SimpleDateFormat object. 
 
 How would I do that?
I think what you are trying to do is the following:
Date myDate = (new
SimpleDateFormat(dd.MM.).parse(request.getParameter(date));
String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
That will receive the date in format 30.01.2003 and convert it to
01/30/2003

I'm not sure if you've understood the esql:parameter concept fully.
Using the esql parameter will result in java code that looks something
like the following:

...
PreparedStatement statement = conn.prepareStatement(select * from table
where datecolumn = ?);
statement.setDate(1, myDate);
...

When using code like this, you don't have to worry about the format the
database engine uses, you only have to worry about the format the user
uses and parse that into a Date object.

I do realise that I may not always understand exactly what you are
asking so please keep asking until we fully understand each other.

-- 
Andrew Timberlake [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
I correct it and now:

description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 286, column -1: incompatible types Line 309, column 48: 
variable dateParam not found in class org.apache.cocoon.www.logic.IDC2_info_int_xsp 
Line 0, column 0: 2 errors 

the xsp:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
xsp:logic
  Date myDate = ;
  try{
myDate = (new SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  }catch(Exception e){
getLogger().error(XSP date error: , e);
}
   /xsp:logic
test
xsp:exprdateParam/xsp:expr
/test
/dataset
/xsp:page

the request: ?date=31.01.2003

-Ursprüngliche Nachricht-
Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 31. Januar 2003 17:49
An: [EMAIL PROTECTED]
Betreff: Re: AW: AW: AW: AW: AW: AW: xsp-element equivalent to
xsl:param?


On Fri, 2003-01-31 at 18:37, Scherler, Thorsten wrote:
 Hello again,
 
 I have shorten the xsp:
 xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
 dataset
 xsp:logic
 Date myDate = ;
 try{
 myDate = (new
 SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
 ---^
You had a missing ')'

 String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
   }catch(Exception e){
 getLogger().error(XSP date error: , e);
 }
 /xsp:logic
 test
 xsp:exprmyDate /xsp:expr
 /test
 /dataset
 /xsp:page
 

-- 
Andrew Timberlake [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
I tried:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
xsp:logic
  Date myDate = ;
  String dateParam = null;

  try{
myDate = (new 
SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
   dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  } catch(Exception e){
getLogger().error(XSP date error: , e);
  }
   /xsp:logic
test
xsp:exprdateParam/xsp:expr
/test
/dataset
/xsp:page

error:
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 286, column -1: incompatible types Line 0, column 0: 1 error 


  IDC2_info_int_xsp.java: 
this.characters(\n\t\t\t);
  
  Date myDate = ;
  String dateParam = null;
  try{
myDate = (new 
SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
   dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  } catch(Exception e){
getLogger().error(XSP date error: , e);
  }
   
this.characters(\n\t\t\t);
  



Bye
Judith

 -Ursprüngliche Nachricht-
 Von:  Scherler, Thorsten [SMTP:[EMAIL PROTECTED]]
 Gesendet am:  Freitag, 31. Januar 2003 18:01
 An:   [EMAIL PROTECTED]
 Betreff:  AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?
 
 I correct it and now:
 
 description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 286, column -1: incompatible types Line 309, column 48: 
variable dateParam not found in class org.apache.cocoon.www.logic.IDC2_info_int_xsp 
Line 0, column 0: 2 errors 
 
 the xsp:
 xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
   dataset
   xsp:logic
   Date myDate = ;
   try{
 myDate = (new SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
 String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
   }catch(Exception e){
 getLogger().error(XSP date error: , e);
 }
/xsp:logic
   test
   xsp:exprdateParam/xsp:expr
   /test
   /dataset
 /xsp:page
 
 the request: ?date=31.01.2003
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 17:49
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: AW: AW: AW: AW: AW: xsp-element equivalent to
 xsl:param?
 
 
 On Fri, 2003-01-31 at 18:37, Scherler, Thorsten wrote:
  Hello again,
  
  I have shorten the xsp:
  xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
  dataset
  xsp:logic
  Date myDate = ;
  try{
  myDate = (new
  SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
  ---^
 You had a missing ')'
 
  String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
}catch(Exception e){
  getLogger().error(XSP date error: , e);
  }
  /xsp:logic
  test
  xsp:exprmyDate /xsp:expr
  /test
  /dataset
  /xsp:page
  
 
 -- 
 Andrew Timberlake [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?

2003-01-31 Thread Scherler, Thorsten
Last Mail before I stop work:

If I modify the code of Judith like that:
...
 Date myDate = null;
...

instead of Date myDate = ;

I do not get an error now, but neither the date.

So thanks everybody for your help.

I will finish up after 14hours without solving the problem.

King regards
-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 31. Januar 2003 18:11
An: [EMAIL PROTECTED]
Betreff: AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to
xsl:param?


I tried:
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
xsp:logic
  Date myDate = ;
  String dateParam = null;

  try{
myDate = (new 
SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
   dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  } catch(Exception e){
getLogger().error(XSP date error: , e);
  }
   /xsp:logic
test
xsp:exprdateParam/xsp:expr
/test
/dataset
/xsp:page

error:
description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 286, column -1: incompatible types Line 0, column 0: 1 error 


  IDC2_info_int_xsp.java: 
this.characters(\n\t\t\t);
  
  Date myDate = ;
  String dateParam = null;
  try{
myDate = (new 
SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
   dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
  } catch(Exception e){
getLogger().error(XSP date error: , e);
  }
   
this.characters(\n\t\t\t);
  



Bye
Judith

 -Ursprüngliche Nachricht-
 Von:  Scherler, Thorsten [SMTP:[EMAIL PROTECTED]]
 Gesendet am:  Freitag, 31. Januar 2003 18:01
 An:   [EMAIL PROTECTED]
 Betreff:  AW: AW: AW: AW: AW: AW: AW: xsp-element equivalent to xsl:param?
 
 I correct it and now:
 
 description org.apache.cocoon.ProcessingException: Language Exception: 
org.apache.cocoon.components.language.LanguageException: Error compiling 
IDC2_info_int_xsp: Line 286, column -1: incompatible types Line 309, column 48: 
variable dateParam not found in class org.apache.cocoon.www.logic.IDC2_info_int_xsp 
Line 0, column 0: 2 errors 
 
 the xsp:
 xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
   dataset
   xsp:logic
   Date myDate = ;
   try{
 myDate = (new SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
 String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
   }catch(Exception e){
 getLogger().error(XSP date error: , e);
 }
/xsp:logic
   test
   xsp:exprdateParam/xsp:expr
   /test
   /dataset
 /xsp:page
 
 the request: ?date=31.01.2003
 
 -Ursprüngliche Nachricht-
 Von: Andrew Timberlake [mailto:[EMAIL PROTECTED]]
 Gesendet: Freitag, 31. Januar 2003 17:49
 An: [EMAIL PROTECTED]
 Betreff: Re: AW: AW: AW: AW: AW: AW: xsp-element equivalent to
 xsl:param?
 
 
 On Fri, 2003-01-31 at 18:37, Scherler, Thorsten wrote:
  Hello again,
  
  I have shorten the xsp:
  xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
  dataset
  xsp:logic
  Date myDate = ;
  try{
  myDate = (new
  SimpleDateFormat(dd.MM.)).parse(request.getParameter(date));
  ---^
 You had a missing ')'
 
  String dateParam = (new SimpleDateFormat(MM/dd/)).format(myDate);
}catch(Exception e){
  getLogger().error(XSP date error: , e);
  }
  /xsp:logic
  test
  xsp:exprmyDate /xsp:expr
  /test
  /dataset
  /xsp:page
  
 
 -- 
 Andrew Timberlake [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 
 
 -
 Please check that your question  has not already been answered in the
 FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
 
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail:   [EMAIL PROTECTED]
 

-
Please check that your question  has not already been

AW: Time to go back to JSP. Cocoon just isnt ready.

2003-01-30 Thread Scherler, Thorsten
Hello, group.

I am using cocoon in a professional environment. 

I am happy with it! So is my boss, ...and his boss! 

Use yourself whatever you want! Come back in one year - yes I strongly believe cocoon 
will be still there, because it is the concept behind it that makes so powerful! 

But please everyone, stop producing bad vibes!

Thanks.

-Ursprüngliche Nachricht-
Von: Carsten Ziegeler [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 30. Januar 2003 14:22
An: [EMAIL PROTECTED]
Betreff: RE: Time to go back to JSP. Cocoon just isnt ready.


PLEASE: LET'S NOT TURN THIS INTO A FLAME WAR AGAINST ANYONE!

We can discuss everything as long as it does not get personal.

If someone does not want to use Cocoon, fine - if someone
wants to use Cocoon, it's even better. And if someone is soo
happy with Cocoon and can even give back to the immens effort
the cocoon community has put into this project: excellent.

Just two more sentences to all of you out there wondering if 
Cocoon is usable or not:

a) many companies are using cocoon in *production* environments
   and this includes really, really big ones - so it is usable
   and used.

b) it's your decision if you want to use cocoon or not and noone else's.

And finally:
Again, let's try to be objective and let's not get personal!!!

Have a nice day
Carsten 

Carsten Ziegeler 
Open Source Group, SN AG



-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




substring-before()

2003-01-30 Thread Scherler, Thorsten
Hello group,

Function: string substring-before ( string, string ) Returns the string part preceding 
the first occurence of the second passed string inside the first passed string. The 
return value of substring-before('2000/3/22', '/') would be '2000'.

My question: 
can that first string be a param? 


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: substring-before()

2003-01-30 Thread Scherler, Thorsten
Yes it can be:
e.g.
xsl:param name=date/
...
xsl:value-of select=substring-before($date,'/')/
...
-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Donnerstag, 30. Januar 2003 16:06
An: Cocoon-Users (E-Mail)
Betreff: substring-before()


Hello group,

Function: string substring-before ( string, string ) Returns the string part preceding 
the first occurence of the second passed string inside the first passed string. The 
return value of substring-before('2000/3/22', '/') would be '2000'.

My question: 
can that first string be a param? 


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




date translation

2003-01-30 Thread Scherler, Thorsten
Hello group,

if anybody need a date translation, here it is:

e.g. test.html?date=29.1.2003 (like we write in Germany) will be 1/29/2003.

xsl:param name=date/
xsl:param name=GETdayxsl:value-of select=substring-before($date,'.')/ 
/xsl:param
xsl:param name=GETmonth_yearxsl:value-of 
select=substring-after($date,'.')//xsl:param
xsl:param name=GETmonthxsl:value-of 
select=substring-before($GETmonth_year,'.')/ /xsl:param
xsl:param name=GETyearxsl:value-of select=substring-after($GETmonth_year,'.')/ 
/xsl:param
...
xsl:value-of select=$GETmonth//xsl:value-of select=$GETday//xsl:value-of 
select=$GETyear/

King regards

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: date translation

2003-01-30 Thread Scherler, Thorsten
it is me again.

How can I do it with xsp?

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Donnerstag, 30. Januar 2003 16:22
An: Cocoon-Users (E-Mail)
Betreff: date translation


Hello group,

if anybody need a date translation, here it is:

e.g. test.html?date=29.1.2003 (like we write in Germany) will be 1/29/2003.

xsl:param name=date/
xsl:param name=GETdayxsl:value-of select=substring-before($date,'.')/ 
/xsl:param
xsl:param name=GETmonth_yearxsl:value-of 
select=substring-after($date,'.')//xsl:param
xsl:param name=GETmonthxsl:value-of 
select=substring-before($GETmonth_year,'.')/ /xsl:param
xsl:param name=GETyearxsl:value-of select=substring-after($GETmonth_year,'.')/ 
/xsl:param
...
xsl:value-of select=$GETmonth//xsl:value-of select=$GETday//xsl:value-of 
select=$GETyear/

King regards

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: date translation

2003-01-30 Thread Scherler, Thorsten
Hello Konstantin,

I want to do the following:

I produce reports from a database. 
e.g.
esql:query
select * from info_bericht  where Info_datum = #xsp-request:get-parameter 
name=date/#   AND country ='xsp-request:get-parameter name=GETcountry/'
/esql:query

This is be done from a html form.
e.g.
form action=IDC2/info_int.pdf
select name=GETcountry
optgroup label=Lauml;nder
option value=FranceFrance/option
option value=ItalyItaly/option
option value=NetherlandNetherland/option
option value=SwissSwiss/option
/optgroup
/select
input type=text name=date
input type=submit
/form

The actual date of the esql:query/  has to be in the format e.g. 01/29/2003, but we 
are a company in Germany were we use this date format: 29.01.2003.

So I would like to translate the 29.01.2003 into 01/29/2003 before I put it in the 
esql:query/.

SimpleDateFormat.parse() will do the job? I will try!
 
xsp:logic
   // perform your date translation using any method you like, e.g.
SimpleDateFormat.parse(), etc.
/xsp:logic

Thanks a million!

-Ursprüngliche Nachricht-
Von: Konstantin Piroumian [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 30. Januar 2003 16:34
An: [EMAIL PROTECTED]
Betreff: Re: date translation


Please tell us what is the final target of your date translation and we'll
try to advice something.
In XSP you do it just the same way as in pure Java:
xsp:logic
   // perform your date translation using any method you like, e.g.
SimpleDateFormat.parse(), etc.
/xsp:logic

--
  Konstantin

- Original Message -
From: Scherler, Thorsten [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 18:28
Subject: AW: date translation


it is me again.

How can I do it with xsp?

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten
Gesendet: Donnerstag, 30. Januar 2003 16:22
An: Cocoon-Users (E-Mail)
Betreff: date translation


Hello group,

if anybody need a date translation, here it is:

e.g. test.html?date=29.1.2003 (like we write in Germany) will be 1/29/2003.

xsl:param name=date/
xsl:param name=GETdayxsl:value-of
select=substring-before($date,'.')/ /xsl:param
xsl:param name=GETmonth_yearxsl:value-of
select=substring-after($date,'.')//xsl:param
xsl:param name=GETmonthxsl:value-of
select=substring-before($GETmonth_year,'.')/ /xsl:param
xsl:param name=GETyearxsl:value-of
select=substring-after($GETmonth_year,'.')/ /xsl:param
...
xsl:value-of select=$GETmonth//xsl:value-of
select=$GETday//xsl:value-of select=$GETyear/

King regards

 Mit freundlichem Gruss,

 Thorsten Scherler
 Marketing / Telefonmarketing

 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de



-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]



-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: substring-before()

2003-01-30 Thread Thorsten Scherler
Jupp, thanks!

What would be an appropriate XSLT forum?

Any recommendations?

Jeremy Quinn wrote:


On Thursday, Jan 30, 2003, at 15:06 Europe/London, Scherler, Thorsten 
wrote:

Hello group,

Function: string substring-before ( string, string ) Returns the 
string part preceding the first occurence of the second passed string 
inside the first passed string. The return value of 
substring-before('2000/3/22', '/') would be '2000'.

My question:
can that first string be a param?


If by this you mean 'can that first string be set by an XSLT param' ?

The answer is yes. (Be pretty useless if you could'nt ;)

eg.

?xml version=1.0?
xsl:stylesheet version=1.0 
xmlns:xsl=http://www.w3.org/1999/XSL/Transform;

  xsl:param name=date/

  xsl:template match=/
xsl:if test=substring-before($date, '/') = '2000'
  pYes, Ladies  Gentlemen, it is indeed the year 2000/p
/xsl:if
  /xsl:template

/xsl:stylesheet

Ideally this kind of question ought to be asked on an appropriate XSLT 
forum.
But I hope it helped.

regards Jeremy


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Request parameters for SQL arguments

2002-12-06 Thread Scherler, Thorsten
select * From AllTask Where wfID=xsp-request:get-parameter name=myID/

call it like: ../view-workflow?myID=2

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 15:41
An: [EMAIL PROTECTED]
Betreff: XSP: Request parameters for SQL arguments


I try to have a variable for my sql query :

select * From AllTask Where wfID=

That variable (wfID=*) is in my url, that means the page is loaded with
the adress:

.../view-workflow?myID=2 or .../view-workflow?myID=5

How can I get the variable 2 or 5 and put it in my SQL query? I use a
xsp page.
In the sitemap I have the following pipeline

 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages
src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline  

Thank you!

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Request parameters for SQL arguments

2002-12-06 Thread Scherler, Thorsten
Sorry, that is much better (use xsp:expr/):

select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr


-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 6. Dezember 2002 15:44
An: [EMAIL PROTECTED]
Betreff: AW: Request parameters for SQL arguments


select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr

call it like: ../view-workflow?myID=2

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 15:41
An: [EMAIL PROTECTED]
Betreff: XSP: Request parameters for SQL arguments


I try to have a variable for my sql query :

select * From AllTask Where wfID=

That variable (wfID=*) is in my url, that means the page is loaded with
the adress:

.../view-workflow?myID=2 or .../view-workflow?myID=5

How can I get the variable 2 or 5 and put it in my SQL query? I use a
xsp page.
In the sitemap I have the following pipeline

 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages
src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline  

Thank you!

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Request parameters for SQL arguments

2002-12-06 Thread Scherler, Thorsten
Is there a reason u don't use esql?

Or do you use esql?

http://enpdata.csit.fsu.edu/cocoon/documents/esql

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 16:04
An: [EMAIL PROTECTED]
Betreff: RE: Request parameters for SQL arguments


If I write :
select * From AllTask Where wfID=1 
It's alright, but when I write:
select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr
Then I get following error:
typeStatus report
message
descriptionThe requested resource () is not available.

Do I have to add something in my pipeline? 
 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline 

thanks
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 06, 2002 3:47 PM
To: [EMAIL PROTECTED]
Subject: AW: Request parameters for SQL arguments


Sorry, that is much better (use xsp:expr/):

select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr


-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 6. Dezember 2002 15:44
An: [EMAIL PROTECTED]
Betreff: AW: Request parameters for SQL arguments


select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr

call it like: ../view-workflow?myID=2

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 15:41
An: [EMAIL PROTECTED]
Betreff: XSP: Request parameters for SQL arguments


I try to have a variable for my sql query :

select * From AllTask Where wfID=

That variable (wfID=*) is in my url, that means the page is loaded with the adress:

.../view-workflow?myID=2 or .../view-workflow?myID=5

How can I get the variable 2 or 5 and put it in my SQL query? I use a xsp page. In the 
sitemap I have the following pipeline

 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline  

Thank you!

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Request parameters for SQL arguments

2002-12-06 Thread Scherler, Thorsten
please send mor code!

I will have a look at home

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 16:14
An: [EMAIL PROTECTED]
Betreff: RE: Request parameters for SQL arguments


I use ESQL, the beginning of my page is like this :
?cocoon-process type=xsp?
?cocoon-process type=xslt?
?xml-stylesheet href=stylesheets/dynamic-page2html.xsl type=text/xsl?
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2;
page
content
esql:connection
esql:poolpersonnel/esql:pool
esql:execute-query
esql:query
select * From AllTask Where 
wfID=xsp-request:get-parameter name=myID/
/esql:query   

esql:results
...

But with this I get an error because of xsp-request:get-parameter name=myID/ 


-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 06, 2002 4:12 PM
To: [EMAIL PROTECTED]
Subject: AW: Request parameters for SQL arguments


Is there a reason u don't use esql?

Or do you use esql?

http://enpdata.csit.fsu.edu/cocoon/documents/esql

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 16:04
An: [EMAIL PROTECTED]
Betreff: RE: Request parameters for SQL arguments


If I write :
select * From AllTask Where wfID=1 
It's alright, but when I write:
select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr Then I get following error: typeStatus report message 
descriptionThe requested resource () is not available.

Do I have to add something in my pipeline? 
 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline 

thanks
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 06, 2002 3:47 PM
To: [EMAIL PROTECTED]
Subject: AW: Request parameters for SQL arguments


Sorry, that is much better (use xsp:expr/):

select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr


-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Freitag, 6. Dezember 2002 15:44
An: [EMAIL PROTECTED]
Betreff: AW: Request parameters for SQL arguments


select * From AllTask Where wfID=xsp:exprxsp-request:get-parameter 
name=myID//xsp:expr

call it like: ../view-workflow?myID=2

-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 6. Dezember 2002 15:41
An: [EMAIL PROTECTED]
Betreff: XSP: Request parameters for SQL arguments


I try to have a variable for my sql query :

select * From AllTask Where wfID=

That variable (wfID=*) is in my url, that means the page is loaded with the adress:

.../view-workflow?myID=2 or .../view-workflow?myID=5

How can I get the variable 2 or 5 and put it in my SQL query? I use a xsp page. In the 
sitemap I have the following pipeline

 map:pipeline
map:match pattern=workflowmax/view-workflow
 map:generate type=serverpages src=workflowmax/documents/view-workflow.xsp/
 map:transform type=sql
map:parameter name=use-connection value=personnel/
 /map:transform
 map:serialize/
/map:match
   /map:pipeline  

Thank you!

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED

Re: Sendmail serial email

2002-12-03 Thread Thorsten Scherler
Dear Ray, dear all,

thanks for the reply!

Ray Martin wrote:

Sir,
I too experienced that no one would give any answers.  But, i am wondering
if the cocoon-users mail list server is always behaving correctly.  i am
subscribed to the cocoon-users list, but this is the first time that i have
seen your message.  i did not receive any of your previous postings on this
question.


...and I have posted a lot.



i too got sendmail to work for me slightly.  however, i was never able to
get sendmail to authenticate or to attach a file.

i gave up on sendmail.  Instead i use an action in which i have some JAVA
mail client code.  Now i can control the code exactly to meet my
requirements.  i am no longer dependent on code that has no documentation
beyond a simple tutorial - which in its own self was very interesting - just
no clues as to how to proceed with such things as authentication and file
attachment.

if i can help in any way - a code snippet? - let me know. if you are going
to continue with sendmail, i cannot help.


YES PLEASE LET ME KNOW HOW YOU DID IT. I am not married to sendmail.

You are right in saying the tutorial is not enough, because to attach 
something to mail is quite basic stuff you want to do with mail.

authentication is no point at the moment but it should be possible.


another subject - i know that you are talking about attaching a file to an
email.  but, while we are on the subject of attaching files.  if there is
ever a time when you want to attach a file to an HTTP request  (file
uploading) - cocoon does this automatically.  i was going crazy trying to
figure out how to do it - i accidentally looked in the cocoon upload
directory and there the file was - sitting right there as nice as could be -
kinda like magic.  i would like to know more about the class that was used
to parse the multipart form, but i have not been able to fidn it just yet.

good luck with sending emails,

Ray



-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:49 AM
To: [EMAIL PROTECTED]
Subject: AW: Sendmail serial email


Hello group,

I don't know why I don't get any answers on that topic, but it is
quit frustrating.

http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-cocoon-p2.ht


ml#sidebar1


There you can find how to nested a esql with sendmail.

It is working!

Now I just suffering how to attach a pdf.

...but I don't think I will get any answers on that,or?

:-(

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten
Gesendet: Montag, 2. Dezember 2002 13:58
An: Cocoon-Dev (E-Mail); Cocoon-Users (E-Mail)
Betreff: Sendmail serial email


Hello group,

I am still trying to send a serial email with cocoon ... and I am
stucked big time

I got the sendmail logic sheet runnig (without the possiblity to
attach a file or a URL).

I have my query (with esql) running.

Now I want to do the following:
The query looks for the date on which information has to be send
(info.xsp:)
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter
name=date/#
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=ADM_email/
/email
/ADM
/WD
/client
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Now I want to send each ADM an eMail.
I have the following sendmail.xsp. I have to replace empfaenger
with the emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic
  String empfaenger =
  [EMAIL PROTECTED]\n;
 /xsp:logic
xsp:logic
  String text =
  \n+
  something\n+
  \n+
  more:\n+
  empfaenger;
  /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr
/sendmail:cc
sendmail:subjectD 200203 V/sendmail:subject
!-- Modify the next line

[Fwd: Re: Sendmail serial email]

2002-12-03 Thread Thorsten Scherler
 text/plain; charset=us-ascii; format=flowed: Unrecognized 
---BeginMessage---
Dear Ray, dear all,

thanks for the reply!

Ray Martin wrote:

Sir,
I too experienced that no one would give any answers.  But, i am wondering
if the cocoon-users mail list server is always behaving correctly.  i am
subscribed to the cocoon-users list, but this is the first time that i have
seen your message.  i did not receive any of your previous postings on this
question.


...and I have posted a lot.



i too got sendmail to work for me slightly.  however, i was never able to
get sendmail to authenticate or to attach a file.

i gave up on sendmail.  Instead i use an action in which i have some JAVA
mail client code.  Now i can control the code exactly to meet my
requirements.  i am no longer dependent on code that has no documentation
beyond a simple tutorial - which in its own self was very interesting - just
no clues as to how to proceed with such things as authentication and file
attachment.

if i can help in any way - a code snippet? - let me know. if you are going
to continue with sendmail, i cannot help.


YES PLEASE LET ME KNOW HOW YOU DID IT. I am not married to sendmail.

You are right in saying the tutorial is not enough, because to attach 
something to mail is quite basic stuff you want to do with mail.

authentication is no point at the moment but it should be possible.


another subject - i know that you are talking about attaching a file to an
email.  but, while we are on the subject of attaching files.  if there is
ever a time when you want to attach a file to an HTTP request  (file
uploading) - cocoon does this automatically.  i was going crazy trying to
figure out how to do it - i accidentally looked in the cocoon upload
directory and there the file was - sitting right there as nice as could be -
kinda like magic.  i would like to know more about the class that was used
to parse the multipart form, but i have not been able to fidn it just yet.

good luck with sending emails,

Ray



-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:49 AM
To: [EMAIL PROTECTED]
Subject: AW: Sendmail serial email


Hello group,

I don't know why I don't get any answers on that topic, but it is
quit frustrating.

http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-cocoon-p2.ht


ml#sidebar1


There you can find how to nested a esql with sendmail.

It is working!

Now I just suffering how to attach a pdf.

...but I don't think I will get any answers on that,or?

:-(

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten
Gesendet: Montag, 2. Dezember 2002 13:58
An: Cocoon-Dev (E-Mail); Cocoon-Users (E-Mail)
Betreff: Sendmail serial email


Hello group,

I am still trying to send a serial email with cocoon ... and I am
stucked big time

I got the sendmail logic sheet runnig (without the possiblity to
attach a file or a URL).

I have my query (with esql) running.

Now I want to do the following:
The query looks for the date on which information has to be send
(info.xsp:)
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter
name=date/#
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=ADM_email/
/email
/ADM
/WD
/client
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Now I want to send each ADM an eMail.
I have the following sendmail.xsp. I have to replace empfaenger
with the emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic
  String empfaenger =
  [EMAIL PROTECTED]\n;
 /xsp:logic
xsp:logic
  String text =
  \n+
  something\n+
  \n+
  more:\n+
  empfaenger;
  /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr

Re: AW: Sendmail serial email

2002-12-03 Thread Thorsten Scherler
Hello Frank,

so you patched the sendmail.xsl to have multiple cc. Rhanks for the reply.

What you have said makes sense (showing the concept). I had a look @ the 
JavaMail Design Specification. I have there my desiered result (a script 
for multipart message). That would be the ready to go Java code.

Coming from the sendmail.xsl I have to extend it in attaching the code 
for multipart. This I have to write in xsl because it will be parsed. 
The parsed result have to be in Java.

snip
// Instantiate a Multipart object
MimeMultipart mp = new MimeMultipart();
// create the first bodypart object
MimeBodyPart b1 = new MimeBodyPart();
// create textual content
// and add it to the bodypart object
b1.setContent(Spaceport Map,text/plain);
mp.addBodyPart(b1);
// Multipart messages usually have more than
// one body part. Create a second body part
// object, add new text to it, and place it
// into the multipart message as well. This
// second object holds postscript data.
MimeBodyPart b2 = new MimeBodyPart(); b2.setContent(map,application/
postscript);
mp.addBodyPart(b2);
// Create a new message object as described above,
// and set its attributes. Add the multipart
// object to this message and call saveChanges()
// to write other message headers automatically.
Message msg = new MimeMessage(session);
// Set message attrubutes as in a singlepart
// message.
msg.setContent(mp); // add Multipart
msg.saveChanges();
/snip

I have to get that result, right!

Thank you Frank for repling I am on my own and I will try my best! ;-)

Frank Ridderbusch wrote:
Scherler, Thorsten wrote:



Hello group,

I don't know why I don't get any answers on that topic, but it is quit
frustrating.




http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-cocoon-p2.html#sidebar1


There you can find how to nested a esql with sendmail.

It is working!

Now I just suffering how to attach a pdf.

...but I don't think I will get any answers on that,or?

:-(



Well, here is someone, who will answer, but I guess it is not quite the
expected answer. 

It does not appear, that you have looked at source of sendmail.xsp 
logisheet (to be found at the location 

src/java/org/apache/cocoon/components/language/markup/xsp/java/sendmail.xsl

If you do, then you realize, that sendmail.xsp ist basically a XSL
stylesheet, that generates Java code, which in turn send an email
though the Java Mail API. You're also see, that only a hand full of
tags are implemented and sendmail:attach is not one of them.
Apparently until now there wasn't anybody who felt the need to 
to attach a file in a sendmail.xsp logisheet. I guess, the current
sendmail.xsp is more of a prove of concept and this is probably
also the reason, that it not configured by default in the main sitemap.

I guess, you're on your own. You might want to look at the report
I filed with bugzilla:

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15005

This might give you an idea, how to proceed. 


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Sendmail serial email

2002-12-02 Thread Scherler, Thorsten
Hello group,

I am still trying to send a serial email with cocoon ... and I am stucked big time

I got the sendmail logic sheet runnig (without the possiblity to attach a file or a 
URL).

I have my query (with esql) running.

Now I want to do the following:
The query looks for the date on which information has to be send (info.xsp:)
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter name=date/# 
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=ADM_email/
/email
/ADM
/WD
/client
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Now I want to send each ADM an eMail. 
I have the following sendmail.xsp. I have to replace empfaenger with the 
emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0; 
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic   
   String empfaenger = 
   [EMAIL PROTECTED]\n;
  /xsp:logic
xsp:logic
   String text =
   \n+
   something\n+
   \n+
   more:\n+
   empfaenger;
   /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr
/sendmail:cc
sendmail:subjectD 200203 V/sendmail:subject
!-- Modify the next line to point to your mail server --
sendmail:smtphostmail.weidmueller.com/sendmail:smtphost
sendmail:body
xsp:exprtext/xsp:expr
xsp-request:get-parameter name=date/
/sendmail:body
/sendmail:send-mail
sendok/send
/page
/xsp:page

How can I do that?

Write a xsl with Processing instruction to build the sendmail file on the fly?

I would rather like not to have to do that!

Any ideas?

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: Sendmail serial email

2002-12-02 Thread Scherler, Thorsten
Hello group,

I don't know why I don't get any answers on that topic, but it is quit frustrating.

http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-cocoon-p2.html#sidebar1

There you can find how to nested a esql with sendmail.

It is working!

Now I just suffering how to attach a pdf.

...but I don't think I will get any answers on that,or?

:-(

-Ursprüngliche Nachricht-
Von: Scherler, Thorsten 
Gesendet: Montag, 2. Dezember 2002 13:58
An: Cocoon-Dev (E-Mail); Cocoon-Users (E-Mail)
Betreff: Sendmail serial email


Hello group,

I am still trying to send a serial email with cocoon ... and I am stucked big time

I got the sendmail logic sheet runnig (without the possiblity to attach a file or a 
URL).

I have my query (with esql) running.

Now I want to do the following:
The query looks for the date on which information has to be send (info.xsp:)
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:esql=http://apache.org/cocoon/SQL/v2; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter name=date/# 
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=ADM_email/
/email
/ADM
/WD
/client
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
/dataset
/xsp:page

Now I want to send each ADM an eMail. 
I have the following sendmail.xsp. I have to replace empfaenger with the 
emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp; 
xmlns:xsp-request=http://apache.org/xsp/request/2.0; 
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic   
   String empfaenger = 
   [EMAIL PROTECTED]\n;
  /xsp:logic
xsp:logic
   String text =
   \n+
   something\n+
   \n+
   more:\n+
   empfaenger;
   /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr
/sendmail:cc
sendmail:subjectD 200203 V/sendmail:subject
!-- Modify the next line to point to your mail server --
sendmail:smtphostmail.weidmueller.com/sendmail:smtphost
sendmail:body
xsp:exprtext/xsp:expr
xsp-request:get-parameter name=date/
/sendmail:body
/sendmail:send-mail
sendok/send
/page
/xsp:page

How can I do that?

Write a xsl with Processing instruction to build the sendmail file on the fly?

I would rather like not to have to do that!

Any ideas?

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: output XML

2002-11-26 Thread Scherler, Thorsten
Helo Chris,

try
snipIs it possible to have a generator that opens an XML file and outputs it
quite simply 'as is' ?
/snip
map:match pattern=*.xml
map:read src=*.xml/
/map:match

or with XSP
!-- === XSP --
map:match pattern=xsp.xml
map:generate type=xsp src=xsp.xsp/
map:serialize type=xml/
/map:match

King regards

-Ursprüngliche Nachricht-
Von: Shaw, Chris [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. November 2002 10:01
An: '[EMAIL PROTECTED]'
Betreff: output XML


Hi,

Simple question (I hope!)



I have such a thing written at the moment but when I use
contentHandler.characters(..) then all the XML tags get escaped into lt;
and gt; tags!

Thanks (in advance)

Chris
-=-=-=

Any e-mail message from the European Central Bank (ECB) is sent in good faith but 
shall neither be binding nor construed as constituting a commitment by the ECB except 
where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any 
unauthorised disclosure, use or dissemination, either in whole or in part, is 
prohibited.
If you have received this e-mail in error, please notify the sender immediately via 
e-mail and delete this e-mail from your system.


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: output XML

2002-11-26 Thread Scherler, Thorsten
No Prob:

Q:
First, the name of the xml file is not known, so the generator has to go
figure it out, open it and the output it.

A:
map:match pattern=*.xml /
The * is a wildcard. Means the name is not known (variable), but as soon the extension 
xml is requested the match is true.

Q:
The second problem is that I need to wrap it with other XML tags

A: One way:
map:match pattern=xml/*.xml
map:aggregate element=Container
map:part src=cocoon:/*.xml/
/map:aggregate
map:transform src=stylesheets/transform.xsl/
map:serialize type=xml/
/map:match

With the map:aggregate element=Container
map:part src=cocoon:/*.xml/
/map:aggregate
your xml is now wrapped into container/.


You have to thing in a pipeline! There is the end of the pipeline (transformed xml) 
and a way through a pipeline. You can aggregate as many elements of INTERNAL and 
EXTRENAL ressources as you like (best practice: one step after the other).

Other way with XSLT.
Regards
Thorsten
-=-=-=

-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday 26 November 2002 10:43
To: [EMAIL PROTECTED]
Subject: AW: output XML


Helo Chris,

try
snipIs it possible to have a generator that opens an XML file and outputs
it
quite simply 'as is' ?
/snip
map:match pattern=*.xml
map:read src=*.xml/
/map:match

or with XSP
!-- === XSP --
map:match pattern=xsp.xml
map:generate type=xsp src=xsp.xsp/
map:serialize type=xml/
/map:match

King regards

-Ursprüngliche Nachricht-
Von: Shaw, Chris [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. November 2002 10:01
An: '[EMAIL PROTECTED]'
Betreff: output XML


Hi,

Simple question (I hope!)



I have such a thing written at the moment but when I use
contentHandler.characters(..) then all the XML tags get escaped into lt;
and gt; tags!

Thanks (in advance)

Chris
-=-=-=

Any e-mail message from the European Central Bank (ECB) is sent in good
faith but shall neither be binding nor construed as constituting a
commitment by the ECB except where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above.
Any unauthorised disclosure, use or dissemination, either in whole or in
part, is prohibited.
If you have received this e-mail in error, please notify the sender
immediately via e-mail and delete this e-mail from your system.


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


Any e-mail message from the European Central Bank (ECB) is sent in good faith but 
shall neither be binding nor construed as constituting a commitment by the ECB except 
where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any 
unauthorised disclosure, use or dissemination, either in whole or in part, is 
prohibited.
If you have received this e-mail in error, please notify the sender immediately via 
e-mail and delete this e-mail from your system.


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




AW: cant create pdfs

2002-11-22 Thread Scherler, Thorsten
Hi Anton, 

sorry wrong message text!

Ok the error message tells you there is a problem with the *.xml. And then follows a 
fop exception that is quite wreid!

goto PATHTO_TOMCAT\webapps\cocoon\WEB-INF\logs there are 4 logs! Have a look and find 
the messages and post them!

Cheers, mate!

-Ursprüngliche Nachricht-
Von: Thorsten Scherler [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 22. November 2002 08:01
An: [EMAIL PROTECTED]
Betreff: Re: cant create pdfs


Hi Anton,

you're welcome!
If you use the code of the tutorial the problem will be the plugin of 
the client. Do you know anyone of this 1%? Ask her/him to setup the 
A.Reader again. I expect they then see your page.

King Regards
Thorsten

Anton Hughes wrote:
 Hi Thorsten
 
 Thanks for the reply!
 The code I used is the exact code from the tutorial which can be found at
 http://xml.apache.org/cocoon/howto/howto-html-pdf-publishing.htmld
 
 I cut and pasted the code several times and each time got the same results.
 
 I've also cut and pasted the code for sitemap.xmap file.
 
 Regards
 Anton
 
 -Original Message-
 From: Thorsten Scherler [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, November 21, 2002 8:03 PM
 To: [EMAIL PROTECTED]
 Subject: Re: cant create pdfs
 
 
 gidday mate,
 Could not read resource
   file:/C:/apache/Apache Tomcat 
 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
   java.lang.RuntimeException: org.apache.fop.apps.FOPException: 
 'master-name'
   for 'fo:page-sequence'matches no 'simple-page-master' or
   'page-sequence-master'
  
 I reckon that the .fo file is screwed. I mean did you use the exact file 
 of the tutorial? It seems that in your fo:page-sequence you don't have a 
   'page-sequence-master' for that reason u get a internal server error.
 
 But it would be nice to see your code.
 
 Good on ya mate. Greetings to downunder.
 
 Anton Hughes wrote:
 
Greetings

I'm just starting out with Cocoon and am having trouble getting it to
 
 create
 
pdfs.  I have gone through the tutorial on how to make HTML/pdf docs and
 
 it
 
works fine with making HTML docs from and xml file but not with PDFs - can
someone please advise me as to what I should do?

The error msg I recieve is this:
Cocoon 2 - Internal server error


 
 
 


type internal-server-error

message Could not read resource file:/C:/apache/Apache Tomcat
4.0/webapps/cocoon/mount/html-pdf/pageOne.xml

description org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat
 
 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
 
java.lang.RuntimeException: org.apache.fop.apps.FOPException:
 
 'master-name'
 
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

sender org.apache.cocoon.servlet.CocoonServlet

source Cocoon servlet

exception

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat
 
 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
 
java.lang.RuntimeException: org.apache.fop.apps.FOPException:
 
 'master-name'
 
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

request-uri

/cocoon/mount/html-pdf/pageOne.pdf

stacktrace

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat
 
 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
 
java.lang.RuntimeException: org.apache.fop.apps.FOPException:
 
 'master-name'
 
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'
  at

 
 org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:115)
 
  at

 
 org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
 
entPipeline.java:210)
  at

 
 org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
 
treamPipeline.java:350)
  at

 
 org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.wildcardMatchN40002E(sitem
 
ap_xmap.java:555)
  at

 
 org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:
 
342)
  at

 
 org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:
 
295)
  at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
  at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
  at

 
 org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400251(sitemap_xmap.java:34
 
13)
  at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2646)
  at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2448)
  at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
  at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
  at org.apache.cocoon.Cocoon.process(Cocoon.java:514)
  at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
  at

 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application

XSL Element testing whether empty, or not!

2002-11-21 Thread Scherler, Thorsten
Hello group,

newbie question:
How can you test whether a Element contain information or not? I mean something like 
the DB command is not Null // is null.

Example:
data.xml
case 1) departmentElektro/department 
case 2) department / 

I want to have the word Department in front of the value as soon as the departmentis 
not empty/department.
I figured out that the string-length(./department/text()) is 19 as soon department 
/. If  departmentis not empty/department is  19.
So I have written the following xsl (knowing that is a work around but not a solution).
xsl:variable name=xtest
xsl:value-of select=string-length(./department/text())/
/xsl:variable
fo:block
xsl:choose
xsl:when test=$xtest19Abteilung: xsl:value-of select=./department/text()/
/xsl:when
xsl:when test=$xtestlt;20
xsl:value-of select=./department/text()/
/xsl:when
/xsl:choose

Is there a better way to do it?

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: [Wyonacms-users] XOpus

2002-11-21 Thread Thorsten Scherler
This is an open appeal to the XML Open Source Community. Please support 
this appeal to keep an Open Source Project alive! How can we keep the 
following project Open Source? Please post this message to people who 
may help!

Xopus is a browser based in-place wysiwyg XML editor. Xopus allows 
users to edit their XML data in an intuitive word processor alike way.
http://xopus.org/index.jsp

The following notice is on the above mentioned page. (my comments) are 
in the brackets.


Hello groups, hello Laurens van den Oever, Sjoerd Visscher, Lon Boonen!

Here is the notice of Q42:

Hi all,

Today we made a decision concerning the Open Source future of Xopus.

Originally, the Open Source project was intended to be our marketing. We 
hoped for huge exposure and many new projects and funding.

(How long are you open source now? Since August/September? I think it 
will take a while to spread the word. I talked to many people that are 
thinking to use Xopus and support the project, but it takes some time to 
really get in to it.)

And of course to change the world for the better.

(Would be if you stay Open Source! Your Editor is one good piece of 
work! I really like it! If we spread the word into the cocoon community 
I think you will get more support and projects)

We indeed got a lot of positive feedback, a few contributions (thanks 
guys!), but no projects nor funding.

The only serious leads and paying customers so far haven't found us 
through the Open Source community. Most of them don't like the Open 
Source idea all together.

(That's to bad. But part of the idea is as well that the user will 
develop the software because the know best want they want. I think your 
client will understand that they will profite of the work of the Open 
Source Community. They have ideas, spirit and a powerful community.)

Building the ideal XML editor, our goal, turned out to be somewhat more 
ambitious than we estimated.
We have made a huge investment building this product and can't continue 
to deliver free software without revenues.

(If some organisation listen: There is a Xopus Version for sale that 
have this * Advanced features:
o Complex pipeline resolving
o Richtext editors
o Table editing
o Lookup editors
o Animations
o Fast-pace editing (allows fast-keyboard-typing while xml nodes are 
created automatically according to the schema)
o Date editors
o Integer editors
o Enumeration editors)

Therefore we have been forced to the conclusion that we will not release 
new Xopus versions to the Open Source community as long as we don't find 
serious paid projects or funding.

(The product is really awesome try it out @ 
http://xopus.org/index.jsp?menu=demo)

We hope we will be able to return to the Open Source development soon.

Thanks for your support and we apologize for the inconvenience 
(THHGTTG IV),


What can we do?

King Regards

Thorsten Scherler
(by the way I am not with Q42, I am using the Open Source Product with 
wyona-cms (http://www.wyona.org/) and I like it very much. All cocoon 
user can integrate that editor in they applications! Online editing of 
XML - Kick's ass!)


Alex McLintock wrote:
Oh dear. It looks like XOpus isn't going to be open source, after all.

http://xopus.org/index.jsp

H. I can't really argue with their reasoning. I am pushing Open 
Source to the business community - and not getting enough revenue to 
make it worthwhile either.

Comments?

Alex





Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here 
http://www.OWAL.co.uk/oss_support/


___
WyonaCMS-users mailing list
[EMAIL PROTECTED]
http://mail.wyona.org/cgi-bin/mailman/listinfo/wyonacms-users



-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: cant create pdfs

2002-11-21 Thread Thorsten Scherler
Hi Anton,

you're welcome!
If you use the code of the tutorial the problem will be the plugin of 
the client. Do you know anyone of this 1%? Ask her/him to setup the 
A.Reader again. I expect they then see your page.

King Regards
Thorsten

Anton Hughes wrote:
Hi Thorsten

Thanks for the reply!
The code I used is the exact code from the tutorial which can be found at
http://xml.apache.org/cocoon/howto/howto-html-pdf-publishing.htmld

I cut and pasted the code several times and each time got the same results.

I've also cut and pasted the code for sitemap.xmap file.

Regards
Anton

-Original Message-
From: Thorsten Scherler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 8:03 PM
To: [EMAIL PROTECTED]
Subject: Re: cant create pdfs


gidday mate,
Could not read resource
  file:/C:/apache/Apache Tomcat 
4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
  java.lang.RuntimeException: org.apache.fop.apps.FOPException: 
'master-name'
  for 'fo:page-sequence'matches no 'simple-page-master' or
  'page-sequence-master'
 
I reckon that the .fo file is screwed. I mean did you use the exact file 
of the tutorial? It seems that in your fo:page-sequence you don't have a 
  'page-sequence-master' for that reason u get a internal server error.

But it would be nice to see your code.

Good on ya mate. Greetings to downunder.

Anton Hughes wrote:

Greetings

I'm just starting out with Cocoon and am having trouble getting it to


create


pdfs.  I have gone through the tutorial on how to make HTML/pdf docs and


it


works fine with making HTML docs from and xml file but not with PDFs - can
someone please advise me as to what I should do?

The error msg I recieve is this:
Cocoon 2 - Internal server error









type internal-server-error

message Could not read resource file:/C:/apache/Apache Tomcat
4.0/webapps/cocoon/mount/html-pdf/pageOne.xml

description org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat


4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:


java.lang.RuntimeException: org.apache.fop.apps.FOPException:


'master-name'


for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

sender org.apache.cocoon.servlet.CocoonServlet

source Cocoon servlet

exception

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat


4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:


java.lang.RuntimeException: org.apache.fop.apps.FOPException:


'master-name'


for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

request-uri

/cocoon/mount/html-pdf/pageOne.pdf

stacktrace

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat


4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:


java.lang.RuntimeException: org.apache.fop.apps.FOPException:


'master-name'


for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'
	at



org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:115)


	at



org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv


entPipeline.java:210)
	at



org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS


treamPipeline.java:350)
	at



org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.wildcardMatchN40002E(sitem


ap_xmap.java:555)
	at



org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:


342)
	at



org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:


295)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
	at



org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400251(sitemap_xmap.java:34


13)
	at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2646)
	at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2448)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:514)
	at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at



org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application


FilterChain.java:247)
	at



org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh


ain.java:193)
	at



org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja


va:243)
	at



org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5


66)
	at



org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)


	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at



org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja


va:190

sendmail Attachments

2002-11-20 Thread Scherler, Thorsten
Hello group,

I want to attach a pdf which will be create through a xsp. I will use it to create 
reports. 

The xsp will get the datasets trough esql then transform it to pdf. I can then get the 
pdf trough http://localhost:8080/weidmueller/report.pdf?date=11/19/2002.

Now I want to attach the report to a mail and send it using sendmail. sendmail is 
runnig fine, by the way.

How can I attach a file? sendmail:attachment is not working.

Here part of my sendmail logicsheet:
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to[EMAIL PROTECTED]/sendmail:to
sendmail:subjectCocoon send mail test/sendmail:subject
!-- Modify the next line to point to your mail server --
sendmail:smtphostpost.weidmueller.com/sendmail:smtphost
sendmail:body
xsp:exprtext/xsp:expr
/sendmail:body
/sendmail:send-mail
King regards

 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Re: cant create pdfs

2002-11-20 Thread Thorsten Scherler
gidday mate,
Could not read resource
 file:/C:/apache/Apache Tomcat 
4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
 java.lang.RuntimeException: org.apache.fop.apps.FOPException: 
'master-name'
 for 'fo:page-sequence'matches no 'simple-page-master' or
 'page-sequence-master'

I reckon that the .fo file is screwed. I mean did you use the exact file 
of the tutorial? It seems that in your fo:page-sequence you don't have a 
 'page-sequence-master' for that reason u get a internal server error.

But it would be nice to see your code.

Good on ya mate. Greetings to downunder.

Anton Hughes wrote:
Greetings

I'm just starting out with Cocoon and am having trouble getting it to create
pdfs.  I have gone through the tutorial on how to make HTML/pdf docs and it
works fine with making HTML docs from and xml file but not with PDFs - can
someone please advise me as to what I should do?

The error msg I recieve is this:
Cocoon 2 - Internal server error




type internal-server-error

message Could not read resource file:/C:/apache/Apache Tomcat
4.0/webapps/cocoon/mount/html-pdf/pageOne.xml

description org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
java.lang.RuntimeException: org.apache.fop.apps.FOPException: 'master-name'
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

sender org.apache.cocoon.servlet.CocoonServlet

source Cocoon servlet

exception

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
java.lang.RuntimeException: org.apache.fop.apps.FOPException: 'master-name'
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'

request-uri

/cocoon/mount/html-pdf/pageOne.pdf

stacktrace

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/apache/Apache Tomcat 4.0/webapps/cocoon/mount/html-pdf/pageOne.xml:
java.lang.RuntimeException: org.apache.fop.apps.FOPException: 'master-name'
for 'fo:page-sequence'matches no 'simple-page-master' or
'page-sequence-master'
	at
org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:115)
	at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:210)
	at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:350)
	at
org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.wildcardMatchN40002E(sitem
ap_xmap.java:555)
	at
org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:
342)
	at
org.apache.cocoon.www.mount.html_pdf.sitemap_xmap.process(sitemap_xmap.java:
295)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
	at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400251(sitemap_xmap.java:34
13)
	at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2646)
	at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2448)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:514)
	at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
	at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
	at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
	at

sendmail Attachment

2002-11-18 Thread Scherler, Thorsten
Hello group,

I try to achieve the following thing:
i want to send reports as pdf Attachment that are stored not on the file system but 
@http e.g.: http://localhost:8088/cocoon/weidmueller/IDC2/info_adm.pdf?date=11/15/2002

I wrote a vb script to attach the file but I can't use for attaching an uri! This is 
due to Outlook. With mozilla it is possible but Mozilla can't be a solution (company 
order).

I am using cocoon for the reports anyway so I tend to send the reports via sendmail. I 
am plannig to to the following:
http://www.cocooncenter.de/cc/documents/resources/sendmail/.

Before I start I like to confirm to my boss that we can attach the uri!

Has anyone already attached a uri via sendmail logicsheet?

Thanks for the help in advance!


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




Sendmail with wyona

2002-11-18 Thread Scherler, Thorsten
http://mail.wyona.org/pipermail/wyonacms-dev/2002-July/90.html

Hello group,

I want to do the exact same thing!
http://members.iinet.net.au/~xions/jigsaws/sendmail.html

But how can I achieve that within wyona? I mean for example:
3. Copy mail.jar and activation.jar to cocoon-2.0.2\lib\optional. I'm not 100% sure if 
this is required but it doesn't do any harm.
or
2. Copy sendmail.xsl to 
cocoon-2.0.2\src\java\org\apache\cocoon\components\language\markup\xsp\java

I have the src of wyona, but can't found the files anywhere!


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




FOP - Adding Font and compile the fop.jar for cocoon?

2002-11-15 Thread Scherler, Thorsten
Hello group,

I have compiled a fop.jar where Arial is supported (I am not sure whether it is 
compiled right). Now I replace the PATHTo\webapps\cocoon\WEB-INF\lib\fop-0.20.3.jar 
with the new fop.jar. I have name it fop-0.20.3.jar again. But now I am getting this 
error:
ERROR
The org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode notifies that 
org.apache.avalon.framework.configuration.ConfigurationException says:

Type 'fo2pdf' is not defined for 'serialize' at 
file:/C:/bin/cms/build/jakarta-tomcat-4.0.4/webapps/cocoon/weidmueller/live-sitemap.xmap:54:35
 

More precisely:

org.apache.avalon.framework.configuration.ConfigurationException: Type 'fo2pdf' is not 
defined for 'serialize' at 
file:/C:/bin/cms/build/jakarta-tomcat-4.0.4/webapps/wyona-cms/wyona/cms/pubs/weidmueller/live-sitemap.xmap:54:35
 


But in the above mentioned sitemap there is map:serializer name=fo2pdf 
src=org.apache.cocoon.serialization.FOPSerializer logger=sitemap.serializer.fo2pdf 
mime-type=application/pdf/. Which is working fine withe original fop.jar of cocoon. 

What am I doing wrong?

BACKGROUND:
I found this page:
http://xml.apache.org/fop/fonts.html

I did (there is a error if you use the original [...C:\myfonts\arial.ttf 
C:\myfonts\arial.ttf arial.xml]):
java -cp 
build\fop.jar;lib\xercesImpl-2.0.1.jar;lib\xml-apis.jar;lib\xalan-2.3.1.jar;lib\batik.jar
 org.apache.fop.fonts.apps.TTFReader C:\myfonts\arial.ttf C:\myfonts\arial.xml 

Now I have:
TTF Reader v1.1.1

Reading C:\myfonts\arial.ttf...

Number of glyphs in font: 1296
Creating xml font file...

Creating CID encoded metrics
Writing xml font file C:\myfonts\arial.xml...

This font contains no embedding license restrictions

Then I did:
Register the fonts within FOP
Edit conf/userconfig.xml and add entries for the font if the fonts section, ie:
 font metrics-file=arial.xml kerning=yes embed-file=arial.ttf
font-triplet name=Arial style=normal weight=normal/
font-triplet name=ArialMT style=normal weight=normal/
 /font

BUT I am using FOP as servlet (Tomcat and cocoon). I now have to compile a fop.jar 
with my userconfig.xml, or not?
Then I have to replace the old fop.jar @tomcat\webapps\cocoon\WEB-INF\lib. And then I 
have Arial within fo, or not


 Mit freundlichem Gruss,
 
 Thorsten Scherler
 Marketing / Telefonmarketing
 
 Weidmüller GmbH  Co.
 P.O. Box 2807
 33058 Paderborn
 Tel.:+ 49 - 5252-960-350
 Fax:+ 49 - 5252-960-116
 eMail: [EMAIL PROTECTED]
 http://www.weidmueller.de
 
 

-
Please check that your question  has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:   [EMAIL PROTECTED]




  1   2   >