Re: including a static XML file in the return from my sql call?

2003-07-01 Thread Joerg Heinicke
Have a look on the output of the render-logic5.xsl transformation. You have maybe kicked the sql:* elements out of your XML. Joerg Paul Tomsic wrote: I'm trying to import a static XML file into the results of my SQL call. Here's my sitemap.

including a static XML file in the return from my sql call?

2003-06-30 Thread Paul Tomsic
I'm trying to import a static XML file into the results of my SQL call. Here's my sitemap.xmap block: and ins

SQL Transformer/Resin broken?

2003-06-23 Thread Ed Yavno
Hi All, I'm having problems trying to use something under Caucho Resin that works perfectly fine under Tomcat: SQL Transformer in Cocoon 2.0.4 deployed under Resin 2.1.8/10(same result) trying to query Oracle 8i. Both Tomcat 4.0.6 and Resin 2.1.8 use the exact same settings (see below: we

SQL Transformer, part of xml doc in a database field.

2003-06-16 Thread Chris
SQL Transformer, part of xml doc in a database field. What if one of the fields from a select statement in an has a text field that contains a valid xml document. All the '<' and '>' characters get escaped, I would like the xml in this field to be part of the rowse

Help: How to create sql element for dynamic queries?

2003-06-10 Thread Jin, Juping
tends AbstractGenerator implements Disposable, Configurable { ... public void generate() throws SAXException { contentHandler.startDocument(); contentHandler.startElement("", "document", "document", emptyAttr); contentHandler.startPref

Re: MS SQL Stored Procedure Help

2003-06-06 Thread Frank Taffelt
i'm not sure if the esql:results element is needed in your case. try the following structure: ... ... maybe this helps: http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=102752486530060&w=2 Frank - To unsubscribe, e

RE: MS SQL Stored Procedure Help

2003-06-06 Thread Tim Bachta
-Original Message- From: Frank Taffelt [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:40 AM To: [EMAIL PROTECTED] Subject: Re: MS SQL Stored Procedure Help this is a snippet which works for me under mssql (jtds driver): {call proc_info( Integer.parseInt(id

MS SQL Stored Procedure Help

2003-06-06 Thread Tim Bachta
I am trying to call this procedure using cocoon. getLoginResult. This stored procedure takes 2 strings and returns an int. My code is below but I am getting an error of incorrect syntax near {. I have tried literally hundreds of different combinations with nothing working can someone please sho

Re: MS SQL Stored Procedure Help

2003-06-06 Thread Frank Taffelt
this is a snippet which works for me under mssql (jtds driver): {call proc_info( Integer.parseInt(id) )} ... i'm remembering problems with the positioning of "{" and the following "call" keyword. You have to make sure that there is no space between them. I'm not sure if

Mysql and sql transformer

2003-04-09 Thread Luca Marchetti
Hi all, I've got a problem with mysql (on win or linux) and sql transformer. I've followed the instruction on the cocoon wiki about how to set-up mysql jdbc drivers, I've set up a simple pipeline with a really simple query, but the result is always the same: Failed to obtain con

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Luca Morandini
> -Original Message- > From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 6:32 PM > To: '[EMAIL PROTECTED]' > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL > upda te table???) > > > do you mi

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Delis, Christopher E.
do you mind sharing the template? =-) --chris > -Original Message- > From: Luca Morandini [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 11:18 AM > To: [EMAIL PROTECTED] > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Luca Morandini
> -Original Message- > From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 5:18 PM > To: '[EMAIL PROTECTED]'; 'Luca Morandini ' > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL > upda te table

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Delis, Christopher E.
uch as single-quotes) for each variable but i'd rather not. any ideas? do i need to re-design my approach? here is the update command i wish to perform. it receives the variables from previous generator/transforms: http://www.w3.org/1999/XSL/Transform"; xmlns:sql="htt

Re: SQL Transformer or ESQL Stylesheet?

2003-03-18 Thread Andrew Savory
Hi, On Tue, 18 Mar 2003, Scherler wrote: > Konlin wrote: > > >Can you write me any clues when to use sql transformer and when esql > >stylesheet? > > I have ask that question before but with no answer! > My personal opinion is that you should use the SQL-transform [a]

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, Kon

RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???)

2003-03-18 Thread Delis, Christopher E.
thanks! i am so embarassed. ;-) i gazed right past that little paragraph... sheesh! -Original Message- From: Luca Morandini To: [EMAIL PROTECTED] Sent: 3/18/03 1:15 AM Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???) Christopher, IIUC, you need

RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???)

2003-03-17 Thread Luca Morandini
Christopher, IIUC, you need substitution: go to http://xml.apache.org/cocoon/userdocs/transformers/sql-transformer.html and look for the "Substitution" topic Regards, - Luca Morandini GIS Consultant

sql transformer question; *not* esql... (was RE: ???ESQL update table???)

2003-03-17 Thread Delis, Christopher E.
i replied to the wrong topic. sorry... what i meant to ask was: is there a "place-holder" mechanism available using the sql transformer? --chris -Original Message- From: Delis, Christopher E. To: '[EMAIL PROTECTED]' Sent: 3/17/03 9:48 AM Subject: RE: ???ESQL u

SQL Transformer or ESQL Stylesheet?

2003-03-17 Thread Konlin
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

SQL Transformer or ESQL Stylesheet?

2003-03-17 Thread Konlin
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

SOLUTION: double namespace attribute in SQL Transformer

2003-03-16 Thread Robert Douglass
Here is the solution that I believe Charles was suggesting (for those who are as XML inept as I, it is nice to have this in black and white) http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";>

AW: SQL and Stylesheets

2003-03-13 Thread Marco Rolappe
to go into the , the s and other stuff belong to the body (w3schools also has an html tutorial and tag reference). I haven't yet worked with the sql transformer, only with the esql logicsheet (which is supposed to be quite similar); that sql:* stuff doesn't like quite ri

Re: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Brian Johnson
, March 13, 2003, at 10:28 AM, Luca Morandini wrote: -Original Message- From: Brian Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:14 PM To: [EMAIL PROTECTED] Subject: Re: sql result tags = column names minus case / any way to get case sensitive tags? In my case, I

Re: SQL and Stylesheets

2003-03-13 Thread Scherler
w/sql:artistbandname" ...but no where in your code s a ...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 t

RE: SQL and Stylesheets

2003-03-13 Thread Richard Cunliffe
Parachutes Oasis The Story Morning Glory I have attached my xsl, what can anyone suggest? Thanks, Richard. http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> So

RE: SQL and Stylesheets

2003-03-13 Thread Faron Dutton
nliffe [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 10:32 AM > To: [EMAIL PROTECTED] > Subject: RE: SQL and Stylesheets > > > > 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

RE: SQL and Stylesheets

2003-03-13 Thread Richard Cunliffe
lding 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? I have got the results to come out correctly by just copying the book, but as so

RE: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Luca Morandini
> -Original Message- > From: Brian Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 4:14 PM > To: [EMAIL PROTECTED] > Subject: Re: sql result tags = column names minus case / any way to get > case sensitive tags? > > > In my case, I would

Re: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Brian Johnson
3:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: sql result tags = column names minus case / any way to get case sensitive tags? The SQLTransformer calls toLowerCase() on the column names when it serializes them. I'm not sure what the reason for this is. Does anybody know?

RE: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Luca Morandini
> -Original Message- > From: Brian Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 3:35 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: sql result tags = column names minus case / any way to get > case sensitive tags? > The SQLTransfor

Re: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Brian Johnson
The SQLTransformer calls toLowerCase() on the column names when it serializes them. I'm not sure what the reason for this is. Does anybody know? Is it because case is driver dependent? Brian On Thursday, March 13, 2003, at 07:42 AM, Christian Haul wrote: On 13.Mar.2003 -- 10:35 AM, Guenther Sc

[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 , on the other . /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

Re: sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Christian Haul
On 13.Mar.2003 -- 10:35 AM, Guenther Schmidt wrote: > Hi all, > > is there a possibility to retrieve case sensitive column names, i.e. result > tags. > > My "select * from rentObjects where ... " returns all column names (result > tags) case insensitive. > > Is there a way to retrieve ... instea

Re: SQL and Stylesheets

2003-03-13 Thread Scherler
Hi Richard. you are calling templates which are not there! The example from Cocoon: building XML applications - with some comments: sqlexample.xsl: http://www.w3.org/1999/XSL/Transform"; xmlns:sql="http://apache.org/cocoon/SQL/2.0";> test Besides tha

sql result tags = column names minus case / any way to get case sensitive tags?

2003-03-13 Thread Guenther Schmidt
Hi all, is there a possibility to retrieve case sensitive column names, i.e. result tags. My "select * from rentObjects where ... " returns all column names (result tags) case insensitive. Is there a way to retrieve ... instead of .. ? Thanks Guenther

SQL and Stylesheets

2003-03-13 Thread Richard Cunliffe
Thorsten and Marco,     After reading the “Cocoon: Building XML Applications” and O’Reilly “XSLT” I have written my own “tidy and simple” XSL style sheet J (instead of using XML Spy). It’s giving results, but its not right.   I have included the style sheet, the XML document, and a p

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

2003-03-12 Thread Marco Rolappe
to be handled by the sql transformer (which in this case couldn't even work because you're not matching the correspondig namespace)? 3. in which sequence are transformations applied? (sql transformer -> your stylesheet, or vice versa?)   just a guess; starting from your database.xm

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, Carsten&Matthew) about SQL.   King regards Thorsten

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

2003-03-12 Thread Scherler, Thorsten
it should look like that!   Explanation:    1)   2)    3)       1) take the database.xml 2) excecute the SQL Statement <- that will produce XML 3) your transformation. BASED on everything before!   Try the following:                then you see what you have to transform! See the sourc

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

2003-03-12 Thread Richard Cunliffe
Thorsten,   Ok the following statement is trying to display the results of the query from the MySQL database in a table, I don’t know if this is right.   What are you trying to do with, anyway:            The code looks complicated, because I am using XML Spy designer which allow

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

2003-03-12 Thread Scherler, Thorsten
AIL 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

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

2003-03-12 Thread Richard Cunliffe
Message- From: Scherler, Thorsten [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 16:34 To: [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 s

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

2003-03-12 Thread Scherler, Thorsten
rsten   -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 docume

SQL RE: 2 (should be) easy questions

2003-03-12 Thread Richard Cunliffe
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

SQL

2003-03-11 Thread Richard Cunliffe
Hi,   Once an XML SQL statement has been passed through the Cocoon SQL Transformer, I would like it to parse through the XSLT to generate the results as HTML.   Does anyone know how to represent the XML SQL query in the DTD?   Thanks,   Richard.  

RE: Accessing nrofrows from SQL Transformer within Stylesheet

2003-03-11 Thread Samuel Bruce
Thanks very much. That worked. I tried the sql namespace prefix before but I put it in the wrong place. Previously I used sql:@nrofrows. Thanks again. --- Luca Morandini <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Samuel Bruce [mailto:[EMAIL PROTECTED]

RE: Accessing nrofrows from SQL Transformer within Stylesheet

2003-03-11 Thread Luca Morandini
> -Original Message- > From: Samuel Bruce [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 11, 2003 7:23 PM > To: cocoon > Subject: Accessing nrofrows from SQL Transformer within Stylesheet > > > > My stylesheet snippet is: > > > >

Accessing nrofrows from SQL Transformer within Stylesheet

2003-03-11 Thread Samuel Bruce
Hello, I can't seem to access the nrofrows value returned from the SQL Transformer. The resulting XML after the SQL Transformer executes in my pipeline is as follows: http://apache.org/cocoon/SQL/2.0"; n

!!!SQL actions!!!

2003-02-20 Thread Maxime.Gheysen
Hello, Is there anybody who can help me with sql actions! I'm trying to add, edit, delete objects in my database, but now I use sql queries, and that's not a good solution! I have a connection, some fields in my xsp page and a "add to database" button. How does actions exactl

patch for and with Sybase and MS SQL server

2003-02-17 Thread neil
. Both use urls starting with "jdbc:sybase:" so some other means must be used to distinguish between them. 2) MS SQL Server also supports "select TOP", so SybaseEsqlQuery should be used with it too. Here is a patch to address this stuff: --- /cygdrive/c/xml-cocoon2/src/bl

cocoon + MS SQL Server Stored Procedure

2003-02-14 Thread Haas, Holger
> Hi! > > How can I execute Stored Procedures (SP) of a MS SQL Database > by the use of the COCOON SQL-Transformer? > > My Environment: > JAVA-Version: j2sdk1.4.0_01 > JDBC-Driver: jtds-0.4.jar > Database: MS SQL Server 7.0 > and Cocoon 2.0.

Re: Problem with SQL Transformer[Sol]

2003-02-07 Thread Cedric Claus
Martin Holz wrote: Cedric Claus <[EMAIL PROTECTED]> writes: This pipeline doesn't work : After SQL transformation the sort and replace.xsl does wrong. But if I copy the xml result of the SQL transform and then apply the same xsl , no problem (with xalan and MSXML) My co

Re: Problem with SQL Transformer

2003-02-06 Thread Martin Holz
Cedric Claus <[EMAIL PROTECTED]> writes: > This pipeline doesn't work : After SQL transformation the sort and > replace.xsl does wrong. But if I copy the xml result of the SQL > transform and then apply the same xsl , no problem (with xalan and > MSXML) > > >

Problem with SQL Transformer

2003-02-06 Thread Cedric Claus
Hi, I have a problem with a pipeline : This pipeline doesn't work : After SQL transformation the sort and replace.xsl does wrong. But if I copy the xml result of the SQL transform and then apply the same xsl , no problem (with xalan and MSXML) My configuration : cocoo

Strange results: SQL Transformer -> Other Transformer -> XML-Serializer

2003-02-04 Thread Stefan Riegel
Hi, for sure I do somthing wrong, because nobody seems to report similar problems. But I just can't find the error. I would like to transform SQL Transformer output to another XML using the Identity Transformation (I guess this is the right word). Problem: the attributes in the rowset-el

Re: Set SQL results into an array

2003-01-20 Thread admin
Why don't you write a stored procedure on SQL Server ? Something like create procedure myProc as declare myCurs cursor for "your first select that gets the array" open myCurs fetch from myCurs into while (@@fetch_status = 0) begin insert into .. fetch next

Re: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread Jeremy Quinn
On Friday, Jan 17, 2003, at 10:04 Europe/London, Carsten Ziegeler wrote: Jeremy Quinn wrote: SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = this is how mine look ... And you do not use the sql namespace on the substitue-value element (sql:substitue-value sql:name

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread Carsten Ziegeler
Jeremy Quinn wrote: > > SELECT DISTINCT contributor_id, name FROM foo WHERE > contributor_id = > > > this is how mine look ... > And you do not use the sql namespace on the substitue-value element (sql:substitue-value sql:name="..."/>) or hav

Re: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread Jeremy Quinn
On Thursday, Jan 16, 2003, at 12:21 Europe/London, Andrew Savory wrote: Hi, As far as I can tell, using substitute-value with SQL Transformer does not work in 2.0.4 (and there aren't any examples of it in the samples, something I'll rectify if I ever get the darn thing working!

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Carsten Ziegeler
> -Original Message- > From: Andrew Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew > Savory > Sent: Thursday, January 16, 2003 1:51 PM > To: [EMAIL PROTECTED] > Subject: RE: SQL Transformer substitute-value woes with 2.0.4 > > > On Thu, 16 Jan 2

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Andrew Savory
On Thu, 16 Jan 2003, Carsten Ziegeler wrote: > I'm not sure, but I guess you have to use the sql namespace > for the substitute-value element as well: > Oh man, it's ALWAYS a simple solution. Thanks! Patch for docs sent to bugzilla and cocoon-dev, and I've added &q

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Carsten Ziegeler
Hi Andrew, I'm not sure, but I guess you have to use the sql namespace for the substitute-value element as well: HTH Carsten > -Original Message- > From: Andrew Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew > Savory > Sent: Thursday, January 16, 2003 1:2

SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Andrew Savory
Hi, As far as I can tell, using substitute-value with SQL Transformer does not work in 2.0.4 (and there aren't any examples of it in the samples, something I'll rectify if I ever get the darn thing working!). Here's what I've got: test.xml: http://apache.org/cocoo

Set SQL results into an array

2003-01-13 Thread Maxime.Gheysen
Hi everybody, I use microsoft SQL server, and XSP pages. I also use ESQL for all my DB commands. I want to insert data with query like "INSERT Into blabla (ID) values (MyArray)" In this query "MyArray" is the result of another query. How can I make it? Here is an example :

Re: sql errors and esql

2003-01-13 Thread Christian Haul
On 13.Jan.2003 -- 12:26 PM, Sarah Windler wrote: > Thank you for the hint. I am trying to understand, what you mean: > > 1.Setup the database connection --> setup error > 2. Setup a prepStatement (con.prepareStatement(queryString) --> ??? > 3. exeute the query: prepStmt.execute()] --> r

Re: sql errors and esql

2003-01-13 Thread Sarah Windler
Thank you for the hint. I am trying to understand, what you mean: 1.Setup the database connection --> setup error 2. Setup a prepStatement (con.prepareStatement(queryString) --> ??? 3. exeute the query: prepStmt.execute()] --> runtime error Is the second a runtime or setup error? regar

Re: sql errors and esql

2003-01-13 Thread Christian Haul
On 13.Jan.2003 -- 10:57 AM, Windler Burri, Sarah wrote: > Hi > Thank you for your reply, but I am not agree: > 1. Both errors in the example are runtime errors! Or more precisaly: Who > decides, which error ist a syntax or runtime error? The try{ block starts just before prepareCall() or prepare

RE: sql errors and esql

2003-01-13 Thread Windler Burri, Sarah
Message- From: Christian Haul [mailto:[EMAIL PROTECTED]] Sent: Montag, 13. Januar 2003 10:38 To: [EMAIL PROTECTED] Subject: Re: sql errors and esql On 13.Jan.2003 -- 09:47 AM, Sarah Windler wrote: > Hi > I don't understand, why some sql errors goes through the > esql:error-re

Re: sql errors and esql

2003-01-13 Thread Christian Haul
On 13.Jan.2003 -- 09:47 AM, Sarah Windler wrote: > Hi > I don't understand, why some sql errors goes through the > esql:error-results pipe and others not. > For example: > 1. SQL> select mgmt_ip_addressm from v_ps_port_traffic; > select mgmt_ip_addressm from v_ps_port_

sql errors and esql

2003-01-13 Thread Sarah Windler
Hi I don't understand, why some sql errors goes through the esql:error-results pipe and others not. For example: 1. SQL> select mgmt_ip_addressm from v_ps_port_traffic; select mgmt_ip_addressm from v_ps_port_traffic * ERROR at line 1: ORA-00904: "MGMT_IP_ADDRESSM": inv

Re: i18n catalogue and sql [act howto]

2003-01-08 Thread Konstantin Piroumian
From: "Cocoon User" <[EMAIL PROTECTED]> > > hi konstantin > > i plan to create an action that will create sitiemap variables for > specific request-parameters not for use only with i18n There is already such action in Cocoon: src\java\org\apache\cocoon\acting\RequestParamAction.java But I'd pref

Re: i18n catalogue and sql [act howto]

2003-01-08 Thread Cocoon User
hi konstantin i plan to create an action that will create sitiemap variables for specific request-parameters not for use only with i18n is there any simple action or any howto create an action for cocoon? i need just a point to start form (something for example) thnx stavros On Wed, 8 Jan 200

Re: i18n catalogue and sql

2003-01-08 Thread Konstantin Piroumian
From: "Cocoon User" <[EMAIL PROTECTED]> > hi martin this is a way to send a parameter inside your xsl file (pretty > good) but i need something else > > i want to use a request parameter as a variable inside my sitemap > > example > > if i have http://../...?locale=el > > src="{locale}_data.xml" >

confusing SQL Error

2003-01-06 Thread Robert Sösemann
Dear listmembers, I have switched a running Cocoon sytem from the use of a MYSQL db to IBMs DB2 7.2 Since that one many of my xsps generate the following error message: org.apache.cocoon.ProcessingException: Exception in Ser

Re: i18n catalogue and sql

2003-01-06 Thread Darren Petrie
You can access a request parameter variable inside your sitemap via a matcher or a selector As a matcher--- As a selector--- ..do something ..do something else Hope that answers your question. Darren On Sunday, January 5, 2003, at 03:12 P

Re: i18n catalogue and sql

2003-01-05 Thread aps olute
In an article by Steve Punte of candlelightsoftware.com, he uses to pickoff input=5 in a url of http://localhost/mypage?input=5 and passed it to a template like this: Can anyone perhaps elaborate on how input=5 from that select? what if the the parameters where http

Re: i18n catalogue and sql

2003-01-05 Thread Cocoon User
hi martin this is a way to send a parameter inside your xsl file (pretty good) but i need something else i want to use a request parameter as a variable inside my sitemap example if i have http://../...?locale=el src="{locale}_data.xml" point to el_data.xml (i have do something similar using

Re: i18n catalogue and sql

2003-01-05 Thread Martin Lüthi
You can use the request parameter like this: Cheers Martin Cocoon User <[EMAIL PROTECTED]> writes: > i know how to make a src file selection based to requested url using > matches > > http://./el/test > http://./en/test > > > > > > but how can do somethi

Re: i18n catalogue and sql

2003-01-01 Thread Cocoon User
ility is to use > separate content files for different languages, e.g: index_en.xml, > index_ru.xml, ..., and then use an action or an input module to retrieve the > needed one based on the user's locale (you can use LocaleAction and its > 'language' sitemap parameter). > >

sql xsp and redirection

2003-01-01 Thread Cocoon User
hi people and happy new year i try to build a sible address book using mySQL and xsp to understand how thing work i have two xsp files that only execute update and delete queries and display a success or failure message is it posible to call a .xsp file (for delete query execution) and then thi

Re: i18n catalogue and sql

2002-12-30 Thread Konstantin Piroumian
ou can use LocaleAction and its 'language' sitemap parameter). > > > > is it possible for catalogues to retrieve data from an sql server > mySQL for example Recently there was commited a patch that allowed to use any source as input for the XML catalogue, so you can easil

i18n catalogue and sql

2002-12-28 Thread Cocoon User
hy people i have found very usefull the i18n processing but what happend when you have large text? is it possible for catalogues to retrieve data from an sql server mySQL for example xml page -ID-> catalogue -ID-> data from SQL thnx s

RE: SQL-Transformer

2002-12-13 Thread Geoff Howard
sorry, just noticed you were talking about sql transformer - i had assumed esql logicsheet in xsp. i need more coffee. try ... then, your results should start off with an attribute nrofrows on rowset, ie: http://apache.org/cocoon/SQL/2.0";> Geoff -

Re: SQL-Transformer

2002-12-13 Thread Boris Althaus
mysql - Original Message - From: Geoff Howard To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 4:19 PM Subject: RE: SQL-Transformer There is a tag defined but it's not fully implemented, although it may be in the very latest cvs. (it only w

RE: SQL-Transformer

2002-12-13 Thread Geoff Howard
er 13, 2002 9:45 AMTo: [EMAIL PROTECTED]Subject: SQL-Transformer Hallo Cocoon Users,   does the SQL-Transformer has a map-parameter like or is there a way to retrieve the number of cols in the resultset?   Regards Boris  

SQL-Transformer

2002-12-13 Thread Boris Althaus
Hallo Cocoon Users,   does the SQL-Transformer has a map-parameter like or is there a way to retrieve the number of cols in the resultset?   Regards Boris  

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-11 Thread Maxime.Gheysen
I'm using Microsoft SQL 2000 server and microsoft's JDBC drivers. Is there is other simple way? Like executing a simple "INSERT ... INTO..." SQL command when I click on my button? -Original Message- From: Geoff Howard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Decem

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-11 Thread Geoff Howard
; Subject: RE: Add/Remove/Edit Sql entries with buttons (using ESQL) > > > I want to add an entry in my page when I click on : " type="submit" value="Save" name="cocoon-action-Add"/>" > And how can I have an automatic ID? > What i

Cocoon-2.0.4 possible bug in Sql transformer

2002-12-11 Thread Gabriele Domenichini
Cocoon-2.0.4 seems to repeat namespace declaration in the sql:rowset element resulting from a sql transformation launching a stored procedure. I have cocoon 2.0.3 and cocoon 2.0.4 side by side on the same machine. I call an Oracle stored procedure with SQL transformer With this code: http

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Maxime.Gheysen
ion to use? ... ... --- http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2"; xmlns:xsp-request="http://apache.org/xsp/request/2.0";> Add a Workflow

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Geoff Howard
class javadoc is the one with the helpful configuration information. Geoff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:11 AM To: [EMAIL PROTECTED] Subject: RE: Add/Remove/Edit Sql entries with buttons (using ESQL) If I write

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Maxime.Gheysen
al Message- From: Geoff Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 4:13 PM To: [EMAIL PROTECTED] Subject: RE: Add/Remove/Edit Sql entries with buttons (using ESQL) You need a proper name attribute on your submit button to get it to call the action. For instance, in your case (

RE: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Geoff Howard
IL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:30 AM To: [EMAIL PROTECTED] Subject: FW: Add/Remove/Edit Sql entries with buttons (using ESQL) Excuse me, previous message was not complete : Hello, I want to Add/Remove/Edit Sql entries by click

FW: Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Maxime.Gheysen
Excuse me, previous message was not complete : Hello, I want to Add/Remove/Edit Sql entries by clicking on buttons. I tryied with these 3 actions : And these action-sets . These actions are in my sitemap. Now, if I want them on

Add/Remove/Edit Sql entries with buttons (using ESQL)

2002-12-10 Thread Maxime.Gheysen
Hello, I want to Add/Remove/Edit Sql entries by clicking on buttons. I tryied with these 3 actions : And these action-sets . These actions are in my sitemap. Now, if I want them on a button, like

RE: Request parameters for SQL arguments

2002-12-09 Thread Maxime.Gheysen
Christian Haul [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 4:28 PM To: [EMAIL PROTECTED] Subject: Re: Request parameters for SQL arguments On 06.Dec.2002 -- 04:13 PM, [EMAIL PROTECTED] wrote: > I use ESQL, the beginning of my page is like this : type="xsp"?> > &g

Re: SQL query cannot be read.

2002-12-08 Thread Gabriele Domenichini
Don't Know try to use the same namespace qualifiers (sql:)... Jin Wei Yong wrote: Hi, I am still exploring the use of SQLTranformer. I am using a book, Cocoon:Building XML Application by Matthew Langham and Carsten Ziegeler. If you have the book, you can refer to Chapter 7. The thi

SQL query cannot be read.

2002-12-07 Thread Jin Wei Yong
Hi, I am still exploring the use of SQLTranformer. I am using a book, Cocoon:Building XML Application by Matthew Langham and Carsten Ziegeler. If you have the book, you can refer to Chapter 7. The this SQL-related example does not use XSP at all. The query is written in the xsl file. In the

Re: Request parameters for SQL arguments

2002-12-06 Thread Christian Haul
On 06.Dec.2002 -- 04:13 PM, [EMAIL PROTECTED] wrote: > I use ESQL, the beginning of my page is like this : > > > > http://apache.org/xsp"; >xmlns:esql="http://apache.org/cocoon/SQL/v2";> > > >

  1   2   3   4   >