cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scherler, Thorsten" <Thorsten.Scher...@weidmueller.de>
Subject AW: Request parameters for SQL arguments
Date Fri, 06 Dec 2002 15:15:30 GMT
please send mor code!

I will have a look at home

-----Ursprüngliche Nachricht-----
Von: Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com]
Gesendet: Freitag, 6. Dezember 2002 16:14
An: cocoon-users@xml.apache.org
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:pool>personnel</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:Thorsten.Scherler@weidmueller.de] 
Sent: Friday, December 06, 2002 4:12 PM
To: cocoon-users@xml.apache.org
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: Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com]
Gesendet: Freitag, 6. Dezember 2002 16:04
An: cocoon-users@xml.apache.org
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:expr><xsp-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:Thorsten.Scherler@weidmueller.de] 
Sent: Friday, December 06, 2002 3:47 PM
To: cocoon-users@xml.apache.org
Subject: AW: Request parameters for SQL arguments


Sorry, that is much better (use <xsp:expr/>):

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


-----Ursprüngliche Nachricht-----
Von: Scherler, Thorsten 
Gesendet: Freitag, 6. Dezember 2002 15:44
An: cocoon-users@xml.apache.org
Betreff: AW: Request parameters for SQL arguments


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

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

-----Ursprüngliche Nachricht-----
Von: Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com]
Gesendet: Freitag, 6. Dezember 2002 15:41
An: cocoon-users@xml.apache.org
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message