Trouble with if
/fo:table-row /xsl:if /xsl:if and my output is showing up with each productivity-line showing. Thanks for the help Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Trouble with if
Can you give me an example of what you are referring to? Tim Bachta -Original Message- From: Joerg Heinicke [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 2:12 PM To: [EMAIL PROTECTED] Subject: Re: Trouble with if Group your data by date/, anything else won't work. http://www.jenitennison.com/xslt/grouping/muenchian.xml http://www.dpawson.co.uk/xsl/sect2/N4486.html Joerg Tim Bachta wrote: I am having trouble with an xsl:if condition. I am testing to see if the date value is the same as the previous date value. If it is I want to skip over the code otherwise I want it to execute the code, simple, here is my code: (the xsl:variable is declared under the stylesheet element as xsl:variable name=oldGroup/ Xml coming in is - XML and XSLT stripped ... and my output is showing up with each productivity-line showing. Thanks for the help 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]
Cocoon to csv not excel
Is there a way to create a csv file using cocoon? I have looked through the developers handbook with no luck. Thank you. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Cocoon to csv not excel
So can I use an xsl to create the node? I have a xsp that creates an xml file that I don't want to change. Tim Bachta -Original Message- From: Upayavira [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 9:32 AM To: [EMAIL PROTECTED] Subject: Re: Cocoon to csv not excel Using XSLT with the text serializer should do it. Just wrap your CSV content with a single node which will be ignored by the text serializer: root 1,bill 2,sid 3,sue /root and map:match pattern=xx map:generate ... map:transform... map:serialize type=text/ /map:match Regards, Upayavira On 27 Jun 2003 at 9:33, Tim Bachta wrote: Is there a way to create a csv file using cocoon? I have looked through the developers handbook with no luck. 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
xsl question
How would I do an if statement in xsl were I am testing for the value of an element? Example xsl:if test=deviation = 1 . where my incoming xml looks like this: de deviation0/deviation compleated-byN/A/compleated-by Thanks for the help Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql:query problem
Here is my code in plain Java:
import java.util.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.text.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class Test
{
public static void main(String args[])
{
boolean retVal = false;
try
{
Connection con = makeConnection();
if (con != null)
{
try
{
CallableStatement stmt = con.prepareCall({call
rptLocationDeviations(?,?,?,?)});
stmt.setInt(1, 199);
stmt.setString(2, Rm 130 B);
stmt.setString(3, 5-20-2003);
stmt.setString(4, 6-20-2003);
ResultSet res = stmt.executeQuery();
while (res.next())
{
System.out.println(Result set is working);
}
res.close();
stmt.close();
retVal = true;
}
catch (SQLException ex)
{
ex.printStackTrace();
}
finally
{
try {
con.close();
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
}
else
{
System.out.println(noConnection);
}
}
catch(SQLException sql)
{
sql.printStackTrace();
}
System.out.println(Return val =+ retVal);
}
public static Connection makeConnection() throws SQLException
{
System.setProperty(jdbc.drivers,
com.microsoft.jdbc.sqlserver.SQLServerDriver);
return
DriverManager.getConnection(jdbc:microsoft:sqlserver://kopentpdc:1433;D
atabaseName=vyzo, user, password);
}
}
End Java
///
Here is what I have in my xsp:
esql:execute-query
esql:call{call
rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter, esql:parameter
direction=in type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr(ResultSet)esql:get-object column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
//
End XSP
/
This procedure should return a result set. And it does in my Java
version. I have looked at the Java code that cocoon compiles from my
xsp and everything looks fine there, granted it is a little confusing to
look through since the formatting is not the greatest.
Thanks for the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
Yes -- unless your driver returns a result set. This is highly
dependent on the jdbc driver :-(
If you know how to do it in plain java, we'll be able to help you
transfer this knowledge to esql.
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]
RE: esql:query problem
Forgot to add that I am getting an invalid parameter bindings error from
cocoon.
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Tim Bachta
Sent: Wednesday, June 25, 2003 9:53 AM
To: [EMAIL PROTECTED]
Subject: RE: esql:query problem
Here is my code in plain Java:
import java.util.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.text.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class Test
{
public static void main(String args[])
{
boolean retVal = false;
try
{
Connection con = makeConnection();
if (con != null)
{
try
{
CallableStatement stmt = con.prepareCall({call
rptLocationDeviations(?,?,?,?)});
stmt.setInt(1, 199);
stmt.setString(2, Rm 130 B);
stmt.setString(3, 5-20-2003);
stmt.setString(4, 6-20-2003);
ResultSet res = stmt.executeQuery();
while (res.next())
{
System.out.println(Result set is working);
}
res.close();
stmt.close();
retVal = true;
}
catch (SQLException ex)
{
ex.printStackTrace();
}
finally
{
try {
con.close();
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
}
else
{
System.out.println(noConnection);
}
}
catch(SQLException sql)
{
sql.printStackTrace();
}
System.out.println(Return val =+ retVal);
}
public static Connection makeConnection() throws SQLException
{
System.setProperty(jdbc.drivers,
com.microsoft.jdbc.sqlserver.SQLServerDriver);
return
DriverManager.getConnection(jdbc:microsoft:sqlserver://kopentpdc:1433;D
atabaseName=vyzo, user, password);
}
}
End Java
///
Here is what I have in my xsp:
esql:execute-query
esql:call{call
rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter, esql:parameter
direction=in type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr(ResultSet)esql:get-object column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
//
End XSP
/
This procedure should return a result set. And it does in my Java
version. I have looked at the Java code that cocoon compiles from my
xsp and everything looks fine there, granted it is a little confusing to
look through since the formatting is not the greatest.
Thanks for the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
Yes -- unless your driver returns a result set. This is highly
dependent on the jdbc driver :-(
If you know how to do it in plain java, we'll be able to help you
transfer this knowledge to esql.
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
RE: esql:query problem
I thought the same but that did not work. The Int declares the types so
if you look in the java code it is transformed into
_esql_query.getCallableStatement().setInt(1,(number));
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:11 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
Guessing a little; should it be little case int instead of Int at
esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter
-Roger
- Original Message -
From: Tim Bachta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:53 AM
Subject: RE: esql:query problem
Here is my code in plain Java:
import java.util.*;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.text.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class Test
{
public static void main(String args[])
{
boolean retVal = false;
try
{
Connection con = makeConnection();
if (con != null)
{
try
{
CallableStatement stmt = con.prepareCall({call
rptLocationDeviations(?,?,?,?)});
stmt.setInt(1, 199);
stmt.setString(2, Rm 130 B);
stmt.setString(3, 5-20-2003);
stmt.setString(4, 6-20-2003);
ResultSet res = stmt.executeQuery();
while (res.next())
{
System.out.println(Result set is working);
}
res.close();
stmt.close();
retVal = true;
}
catch (SQLException ex)
{
ex.printStackTrace();
}
finally
{
try {
con.close();
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
}
else
{
System.out.println(noConnection);
}
}
catch(SQLException sql)
{
sql.printStackTrace();
}
System.out.println(Return val =+ retVal);
}
public static Connection makeConnection() throws SQLException
{
System.setProperty(jdbc.drivers,
com.microsoft.jdbc.sqlserver.SQLServerDriver);
return
DriverManager.getConnection(jdbc:microsoft:sqlserver://kopentpdc:1433;D
atabaseName=vyzo, user, password);
}
}
End Java
///
Here is what I have in my xsp:
esql:execute-query
esql:call{call
rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter, esql:parameter
direction=in type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr(ResultSet)esql:get-object column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
//
End XSP
/
This procedure should return a result set. And it does in my Java
version. I have looked at the Java code that cocoon compiles from my
xsp and everything looks fine there, granted it is a little confusing to
look through since the formatting is not the greatest.
Thanks for the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 7:37 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 24.Jun.2003 -- 08:48 AM, Tim Bachta wrote:
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
Yes -- unless your driver returns a result set. This is highly
dependent on the jdbc driver :-(
If you know how to do it in plain java, we'll be able to help you
transfer this knowledge to esql.
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
RE: esql:query problem
My code now looks like this w/out the user-results tag:
esql:execute-query
esql:call{call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter, esql:parameter
direction=in type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
testesql:get-string column=1//test
/esql:row-results
/esql:results
/esql:call-results
/esql:execute-query
and I get back a different error message now:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():
org.apache.avalon.framework.CascadingRuntimeException: Error getting
ascii data for column 1
We may be getting closer? Thanks for all the help.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:20 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 25.Jun.2003 -- 09:53 AM, Tim Bachta wrote:
Here is my code in plain Java:
snip/
CallableStatement stmt = con.prepareCall({call
rptLocationDeviations(?,?,?,?)});
stmt.setInt(1, 199);
stmt.setString(2, Rm 130 B);
stmt.setString(3, 5-20-2003);
stmt.setString(4, 6-20-2003);
ResultSet res = stmt.executeQuery();
while (res.next())
{
System.out.println(Result set is working);
}
snip/
Mmmh, this looks very simple. You have no out parameters and you get a
result set back.
Here is what I have in my xsp:
esql:execute-query
esql:call{call
rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr(ResultSet)esql:get-object column=1 from-call=true/
/xsp:expr
/esql:result
You should not need the esql:use-results/ tag. Try removing the tag
and report back.
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]
RE: esql:query problem
Well I tried that and no error, the only problem is I get no results
either. I was looking at the example that I am working from
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
And it uses the call-results tag as well as the use-results tag. I
guess this may be bad documentation? I don't know I just wish I could
get this to work. Thanks again for the help it is really appreciated.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 25.Jun.2003 -- 10:32 AM, Tim Bachta wrote:
My code now looks like this w/out the user-results tag:
esql:execute-query
esql:call{call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
Sorry, I should have been more verbose, try:
esql:execute-query
esql:call{call rptLocationDeviations(
esql:parameter
direction=intype=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:results
esql:row-results
testesql:get-string column=1//test
/esql:row-results
/esql:results
/esql:execute-query
(In addition, call-results does not apply when a result set is returned)
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]
RE: esql:query problem
Chris,
That was it, thank you for the help. All of you that helped thank you.
Tim Bachta
-Original Message-
From: Christian Haul [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 10:56 AM
To: [EMAIL PROTECTED]
Subject: Re: esql:query problem
On 25.Jun.2003 -- 10:48 AM, Tim Bachta wrote:
Well I tried that and no error, the only problem is I get no results
either. I was looking at the example that I am working from
Maybe you need to add the needs-query attribute. Some drivers don't
like it if a CallableStatement is just execute()'ed and your java code
uses executeQuery(). So, try
esql:execute-query
esql:call needs-query=true{call rptLocationDeviations(
esql:parameter
direction=intype=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,
esql:parameter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:results
esql:row-results
testesql:get-string column=1//test
/esql:row-results
/esql:results
/esql:execute-query
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
And it uses the call-results tag as well as the use-results tag. I
guess this may be bad documentation? I don't know I just wish I could
get this to work. Thanks again for the help it is really appreciated.
This topic is difficult because each and every driver bahaves
differently in this respect. But documentation is indeed slim. Please
feel free to add to http://wiki.cocoondev.org
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]
xsp question
I am trying to use logic in an xsp page to get the output formatted
correctly, here is what I want the output to look like
taskanddate
date2003-05-20/date
tasks
deviation0/deviation
completed-bySomebodys, Name/completed-by
deviation0/deviation
completed-bySomebodys, Name2/completed-by
deviation0/deviation
completed-bySomebodys, Name3/completed-by
/tasks
/taskanddate
here is the code that I am using
xsp:logic
String date = esql:get-string column=3/;
if(!date.equalsIgnoreCase(oldDate))
{ oldDate = date;
taskanddate
date
esql:get-string column=3/
/date
tasks
}
compleated-by
esql:get-string column=4/
/compleated-by
if(!date.equalsIgnoreCase(oldDate))
{
/tasks
/taskanddate
}
/xsp:logic
and here is the result that I am getting:
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-22 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-23 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-24 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
If anyone knows of a way to do this correctly I would greatly appreciate
the help.
Thank you
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: xsp question
I tried using more tags like you suggested and I get an error:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error
and then click the Refresh button, or try again later.
End tag 'content' does not match the start tag 'tasks'. Error processing
resource
'http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1'.
Line 167, Position 3
/content
--^
Thanks
Tim Bachta
-Original Message-
From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: xsp question
You need to put more starts and stops(only where your doing Java) to the
xsp:logic...see below. at the bottom I pasted some xsp with logic that I
know is working.
- Original Message -
From: Tim Bachta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:33 PM
Subject: xsp question
I am trying to use logic in an xsp page to get the output formatted
correctly, here is what I want the output to look like
taskanddate
date2003-05-20/date
tasks
deviation0/deviation
completed-bySomebodys, Name/completed-by
deviation0/deviation
completed-bySomebodys, Name2/completed-by
deviation0/deviation
completed-bySomebodys, Name3/completed-by
/tasks
/taskanddate
here is the code that I am using
xsp:logic
String date = esql:get-string column=3/;
if(!date.equalsIgnoreCase(oldDate))
{ oldDate = date;
/xsp:logic
taskanddate
date
esql:get-string column=3/
/date
tasks
xsp:logic
}
/xsp:logic
compleated-by
esql:get-string column=4/
/compleated-by
xsp:logic
if(!date.equalsIgnoreCase(oldDate))
{
/xsp:logic
/tasks
/taskanddate
xsp:logic
}
/xsp:logic
and here is the result that I am getting:
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-22 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-23 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- taskanddate
date2003-05-24 00:00:00.0/date
http://localhost:8080/cocoon/vyzo/Room_Report_pdf?cocoon-view=debug1##
- tasks
}
compleated-by /
if(!date.equalsIgnoreCase(oldDate)) {
/tasks
/taskanddate
If anyone knows of a way to do this correctly I would greatly appreciate
the help.
Thank you
Tim Bachta
xsp:logic
if(!selectMap amp;amp; parameterNames!=null amp;amp;
parameterNames.lengthgt;0)
{
//System.out.println(here);
str=mapIDValues[0];
boolean check=false;
int index=str.length()-1;
while(!check amp;amp; indexgt;=0)
{
if(!Character.isDigit(str.charAt(index)))
{
check=true;
index++;
}
else if(index==0)
{
check=true;
}
else
{
index--;
}
}
if(check)
{
mapIDPrefix=str.substring(0,index);
mapIDIndex=Integer.parseInt(str.substring(index,str.length()));
}
/xsp:logic
table border=1
CAPTIONMap Locations/CAPTION
trthLocation
#/ththX/ththY/ththMAP_ID/th/tr
xsp:logic
int count=1;
for(index=0;indexlt;xValues.length;index++)
{
if(removeRowSet.elementAt(index)==null)
{
str=xValues[index];
/xsp:logic
trtdxsp:exprcount/xsp:expr/td
tdinput type=text
xsp:attribute name=nameX/xsp:attribute
xsp:attribute
name=valuexsp:exprstr/xsp:expr/xsp:attribute
/input/td
xsp:logic
str=yValues[index];
/xsp:logic
tdinput type=text
xsp:attribute name=nameY/xsp:attribute
xsp:attribute
name=valuexsp:exprstr/xsp:expr/xsp:attribute
/input/td
xsp:logic
str=mapIDPrefix+mapIDIndex;
/xsp:logic
tdinput type=text
xsp:attribute name=nameMAP_ID/xsp:attribute
xsp:attribute
name=valuexsp:exprstr/xsp:expr
RE: esql:query problem
Here is what I am trying, I am getting an invalid parameter bindings
error, do I need to register the out parameters?
esql:execute-query
esql:call
{? = call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,
esql:parameter direction=in type=String
xsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in type=String xsp:exprbeginTime/xsp:expr
/esql:parameter,esql:parameter direction=in type=String
xsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expresql:get-object
column=1 from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Michael Raffenberg [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 7:25 PM
To: [EMAIL PROTECTED]
Subject: AW: esql:query problem
Hi Tim,
did you try the esql:call Tag?
Here you find a introduction:
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
--Raffy
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 23. Juni 2003 22:55
An: [EMAIL PROTECTED]
Betreff: esql:query problem
I am attempting to call a stored procedure using esql:query.
Other stored procedures work using this so it is not a
connection issue. I have narrowed down the issue to being
the procedure itself. I am selecting data and inserting it
into a temp table then selecting more data and joining the
two data sets. I need to use the temp tables there is no way
around it. The problem is the stored procedure will not
return a result set in cocoon because it sees the insert
statement then stops thinking there is not a result set. My
code from my xsp is below, if anyone has any information
about why this does not work it would be greatly appreciated.
Thank you
Tim Bachta
esql:execute-query
esql:query
execute a_joe
'xsp:exprroom/xsp:expr','xsp:exprbeginTime/xsp:expr','
xsp:expr
endTime/xsp:expr'
/esql:query
esql:results
task-dates
esql:row-results
task-date
date
esql:get-string column=1/
/date
/task-date
/esql:row-results
/task-dates
/esql:results
/esql:execute-query
-
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]
Stored Procedure Help
I am using MS SQL 2000 as a database. I am trying to run a stored
procedure using the following code:
esql:execute-query
esql:call
{? = call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expresql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
I am getting back an error message of invalid parameter bindings. I
checked my input parameters and they are set up correctly. Any
suggestions would be greatly appreciated.
Thank you
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Stored Procedure Help
It's a different error this time.
Error getting ascii data for column ActionName
Thanks for the help
Tim Bachta
-Original Message-
From: Frank Taffelt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedure Help
try the following:
esql:execute-query
esql:call
{call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:results
esql:row-results
test
!-- I'm not sure if this is correct,
because param 1 is the returned resultset.
use an explicit column name from your resultset
instead --
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:execute-query
-
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]
esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
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]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: esql !!!HELP!!!
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
room_report_xsp:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Line 0, column 0:
4 errors
Please any help is greatly appreciated.
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]
-
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: esql !!!HELP!!!
Geoff,
Thanks for the help that was really helpful. Now I was able to get a
step further in my quest. I am running the following code:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and I am now getting this error message:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: {? = rptLocationDeviations(?,?,?,?)} :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
Does anyone have any ideas? Maybee where I can find
ServerPagesGenerator or even what I am doing wrong here. Thanks
Tim Bachta
-Original Message-
From: Geoff Howard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:38 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Yes. The .java file is in your servlet container's work directory under
cocoon-files. There will be an org/apache/cocoon... structure the path
and
name will mimic your xsp file's name and location after a certain point.
If you're using tomcat, the work dir is under %tomcat_home%\work
in jetty, it's in your window's temp dir (documents and
settings\your.user\...
some where. the dir is called something like Jetty_)
HTH,
Geoff Howard
At 01:35 PM 6/24/2003, you wrote:
Does cocoon compile an xsp into a Java class file? If so where does it
put it. The reason why I am asking is that my procedures that I am
having trouble with in cocoon work fine in a java class file.
Tim Bachta
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:21 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
I wish I could make the stored procedure easier, but unfortunately this
is the procedure that I have been given.
Tim Bachta
-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Hello Tim,
your code is quite complex.
I had heaps of problem with similar code.
Can you break it down to 1 or 2 parameter?
Your error:
Line 702, column 45: ')' expected
Line 707, column 65: ';' expected
Line 710, column 6: illegal start of expression
Line 702, column -1: inconvertible types
Seeing the last error I reckon that MS SQL have a different type of
data
then you expect.
-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 6:54 PM
To: [EMAIL PROTECTED]
Subject: esql !!!HELP!!!
Ok, I am using the syntax exactly like that of the example at
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su
p
port
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+S
u
pport and I am getting errors. I am really confused on why I am
getting these errors. Here is the code for the xsp that has the stored
procedure in it:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:paramete
r
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:par
a
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:result
xsp:expr
esql:get-object
column=1 from-call=true/
/xsp:expr
/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and the error message that I am getting is:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:
Language Exception
More precisely
RE: esql !!!HELP!!!
Thanks, I have gotten past that problem, and on to the next. I was able
to view the actual java code that cocoon compiled my page into and
figured out a few errors on my end now I am stuck again. I am getting
an error of Invalid parameter binding(s). My code now looks like this:
esql:execute-query
esql:call{call rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
I have no Idea what invalid parameter binding(s) means. Any help is
greatly appreciated.
Tim Bachta
-Original Message-
From: Roger I Martin PhD [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 3:37 PM
To: [EMAIL PROTECTED]
Subject: Re: esql !!!HELP!!!
Hi,
Every one that your driver supports. The error message your getting
appears
to be from the SQLServer 2000 Driver for JDBC showing
java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
talking about a syntax error it exceptions on. Do simple queries work
in
you Cocoon based project? Are stored procedures supported by the
SQLServer
2000 Driver for JDBC? Can you test this driver directly?
If you need to explore Cocoon more, look in
cocoon-2.1\src\blocks\databases\java\org\apache\cocoon\components\langua
ge\m
arkup\xsp\java\esql.xsl at particularly
xspdoc:desc internal. set one parameter of a callable statement
/xspdoc:desc
xsl:template name=set-call-parameter
xsl:if test=@direction='out' or @direction='inout'
xsl:text_esql_query.getCallableStatement()./xsl:text
registerOutParameter(xsl:value-of select=position()/,
xsl:call-template
name=get-Sql-Typexsl:with-param name=typexsl:value-of
select=@type//xsl:with-param/xsl:call-templatexsl:if
test=@typename, xsl:value-of select=@typename/ /xsl:if);
/xsl:if
xsl:if test=not(@direction) or @direction='inout' or @direction='in'
xsl:text_esql_query.getCallableStatement()./xsl:text
xsl:call-template name=set-query-parameter/
/xsl:if
/xsl:template
and what it calls and does. If you look at your generated *_xsp.java
files
under tomacat (C:\Program
Files\jakarta-tomcat-5\dist\work\Catalina\localhost\wita\cocoon-files\
working mount) or other work directory of another server you will see
that
they extend
org.apache.cocoon.components.language.markup.xspXSPGenerator
but it looks like most of your parameters are direction='in' so you can
look
more at the esql.xsl set-query-parameter template. Note you can put
System.out.println() inside this esql.xsl prove to yourself that the
stylesheet is working. You can write a lot of Java code in here to
explore
the driver classes and the queries they manage. The output from
System.out.println()'s will show up in the launch window of your server.
-Roger
- Original Message -
From: Tim Bachta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 2:41 PM
Subject: RE: esql !!!HELP!!!
Does anyone know what the different types of parameters there are for
esql:parameter. I know String and Int.
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
-Original Message-
From: Tim Bachta
Sent: Tuesday, June 24, 2003 12:56 PM
To: [EMAIL PROTECTED]
Subject: RE: esql !!!HELP!!!
Geoff,
Thanks for the help that was really helpful. Now I was able to get a
step further in my quest. I am running the following code:
esql:execute-query
esql:call
{? = rptLocationDeviations(esql:parameter direction=in
type=Intxsp:exprnumber/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprroom/xsp:expr/esql:parameter,esql:parameter
direction=in
type=Stringxsp:exprbeginTime/xsp:expr/esql:parameter,esql:para
meter direction=in
type=Stringxsp:exprendTime/xsp:expr/esql:parameter)}
/esql:call
esql:call-results
esql:use-results
esql:resultxsp:expr(ResultSet)esql:get-object column=1
from-call=true//xsp:expr/esql:result
esql:results
esql:row-results
test
esql:get-string column=1/
/test
/esql:row-results
/esql:results
/esql:use-results
/esql:call-results
/esql:execute-query
and I am now getting this error message:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: {? = rptLocationDeviations(?,?,?,?)} :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Syntax
error at token t, line 0 offset 7.
Does anyone have any ideas? Maybee where I can find
ServerPagesGenerator or even what I am doing wrong here. Thanks
Tim Bachta
-Original Message-
From
java docs?
Where are the cocoon javadocs located? Thanks Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
esql:query problem
I am attempting to call a stored procedure using esql:query. Other stored procedures work using this so it is not a connection issue. I have narrowed down the issue to being the procedure itself. I am selecting data and inserting it into a temp table then selecting more data and joining the two data sets. I need to use the temp tables there is no way around it. The problem is the stored procedure will not return a result set in cocoon because it sees the insert statement then stops thinking there is not a result set. My code from my xsp is below, if anyone has any information about why this does not work it would be greatly appreciated. Thank you Tim Bachta esql:execute-query esql:query execute a_joe 'xsp:exprroom/xsp:expr','xsp:exprbeginTime/xsp:expr','xsp:expr endTime/xsp:expr' /esql:query esql:results task-dates esql:row-results task-date date esql:get-string column=1/ /date /task-date /esql:row-results /task-dates /esql:results /esql:execute-query - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Query issue
This is really strange. I am trying to run this stored procedure and I am not getting anything. It looks like it is skipping over the entire section. I have verified that data should be coming back and that it is spelled correctly and have even tried other procedures that worked and they work. Does anybody have any clue on to why this stored proc would not work? esql:connection esql:execute-query esql:query execute rptLocationDeviations 'xsp:exprroom/xsp:expr','xsp:exprbeginTime/xsp:expr','xsp:expr endTime/xsp:expr' /esql:query esql:results task-date esql:row-results date esql:get-string column=TaskDate/ task esql:get-string column=ActionName/ deviation esql:get-int column=hasDeviation/ name esql:get-string column=UserName/ /name /deviation /task /date /esql:row-results /task-date /esql:results /esql:execute-query /esql:connection Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
No results from a stored procedure
Is there a reason why cocoon would not execute a certain stored procedure? I have one that I have verified returns a result set but when I run it in cocoon I am not getting anything back. It looks like it is skipping over the section completely. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: No results from a stored procedure
Here is the code from the page: ?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:esql=http://apache.org/cocoon/SQL/v2; xmlns:xsp-session=http://apache.org/xsp/session/2.0; create-session=true page xsp:logic String beginTime =5-20-2003; String endTime = 6-20-2003; String room = Rm 130 B; String qry = rptLocationDeviationsgetTasks 'Rm 130 B','5-20-2003','6-20-2003'; /xsp:logic titleRoom Report for xsp:exprroom/xsp:expr xsp:exprbeginTime/xsp:expr to xsp:exprendTime/xsp:expr/title content esql:connection esql:poolvyzo/esql:pool esql:execute-query esql:query execute rptLocationDeviationsgetTasks 'xsp:exprroom/xsp:expr','xsp:exprbeginTime/xsp:expr','xsp:expr endTime/xsp:expr' /esql:query esql:results tasks esql:row-results task name esql:get-string column=2/ /name /task /esql:row-results /tasks /esql:results /esql:execute-query esql:execute-query esql:query execute rptLocationDeviations 'xsp:exprroom/xsp:expr','xsp:exprbeginTime/xsp:expr','xsp:expr endTime/xsp:expr' /esql:query esql:results task-date esql:row-results task task-name esql:get-string column=2/ /task-name /task /esql:row-results /task-date /esql:results /esql:execute-query /esql:connection /content /page /xsp:page and this is the output that I am getting: ?xml version=1.0 encoding=UTF-8 ? - page xmlns:xsp-session=http://apache.org/xsp/session/2.0; xmlns:xsp=http://apache.org/xsp; xmlns:xspdoc=http://apache.org/cocoon/XSPDoc/v1; xmlns:esql=http://apache.org/cocoon/SQL/v2; xmlns:xsp-request=http://apache.org/xsp/request/2.0; titleRoom Report for Rm 130 B 5-20-2003 to 6-20-2003/title - content - tasks - task nameChange Bottles/name /task - task nameCheck Room/name /task - task nameSpecial Feed/name /task - task nameSpecial Water/name /task - task nameCages/Feed/H20/Mop/name /task /tasks /content /page Tim Bachta -Original Message- From: Tim Bachta Sent: Thursday, June 19, 2003 11:57 AM To: [EMAIL PROTECTED] Subject: No results from a stored procedure Is there a reason why cocoon would not execute a certain stored procedure? I have one that I have verified returns a result set but when I run it in cocoon I am not getting anything back. It looks like it is skipping over the section completely. 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]
DHTML Help
I know this is not the place to ask DHTML Questions but maybe somebody knows where I can get some information. I am having an issue with a div panel being blocked by a combo box. Any help would be greatly appreciated. I guess this does have something to do with cocoon since the page is being generated by cocoon. Thanks. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JSP Exception
I ma trying to pass a jsp page through cocoon using the following code in my sitemap. map:readers default=resource ... map:reader logger=sitemap.reader.jsp name=jsp src=org.apache.cocoon.reading.JSPReader/ ... /map:readers . map:match pattern=reports map:read type=jsp src=jsp/reports.jsp mime-type=text/html/ /map:match The jsp page itself is very simple so I know it is not the problem. The error I am getting is : ServletException in JSPReader.generate() More precisely: org.apache.cocoon.ProcessingException: ServletException in JSPReader.generate() Thanks for the help. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JSP
Is this the right place to ask this question? I asked it earlier today and no answer and all that I find in the books matches what I did. Please help I am stuck. Tim Bachta -Original Message- From: Tim Bachta Sent: Friday, June 13, 2003 11:50 AM To: '[EMAIL PROTECTED]' Subject: JSP Does anyone have a working example of a sitemap that reads a jsp page. I am using version 2.0.4 and have not been able to get my simple jsp page to work. My code for my sitemap is below. map:reader logger=sitemap.reader.jsp name=jsp src=org.apache.cocoon.reading.JSPReader/ map:match pattern=reports map:read type=jsp src=jsp/reports.jsp mime-type=text/html/ /map:match Thank you for the help. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JSP
content=text/html; charset=iso-8859-1 /head % % body You are at the report handler screenbr Date is %= new java.util.Date() % /body /html thank you Tim Bachta -Original Message- From: Geoff Howard [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:44 PM To: [EMAIL PROTECTED] Subject: RE: JSP Yes this is the right place - and yes what you did looks right. You'll need to send more specific information about what went wrong. A full stack trace for example. Geoff -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:20 PM To: [EMAIL PROTECTED] Subject: RE: JSP Is this the right place to ask this question? I asked it earlier today and no answer and all that I find in the books matches what I did. Please help I am stuck. Tim Bachta -Original Message- From: Tim Bachta Sent: Friday, June 13, 2003 11:50 AM To: '[EMAIL PROTECTED]' Subject: JSP Does anyone have a working example of a sitemap that reads a jsp page. I am using version 2.0.4 and have not been able to get my simple jsp page to work. My code for my sitemap is below. map:reader logger=sitemap.reader.jsp name=jsp src=org.apache.cocoon.reading.JSPReader/ map:match pattern=reports map:read type=jsp src=jsp/reports.jsp mime-type=text/html/ /map:match Thank you for the help. 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Using xsl:if
I am trying to do an if statement to select a template according to
values of an element. I have this
http://localhost:8080/cocoon/vyzo/login?cocoon-view=first## -
parameter
http://localhost:8080/cocoon/vyzo/login?cocoon-view=first## -
parameter-name
BeginEndDate
/parameter-name
http://localhost:8080/cocoon/vyzo/login?cocoon-view=first## -
parameter-name
Locations
/parameter-name
/parameter
and I want to do :
if(element(parameter-name) == BeginEndDate)
{
do this;
}
else if (element(parameter-name) == Locations)
{
do that;
}
Any help will be greatly appreciated. Thank you.
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Mapping a htc file
I am trying to call a htc file but am not able to get it working. I
have it mapped in my sitemap like such:
map:match pattern=support/*.htc
map:read mime-type=htc src=support/{1}.htc/
/map:match
Am I doing this correct?
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Query within a query
I am trying to do a query nested within another query and am getting errors, is it possible to do this and if so what am I doing wrong. My code is below: esql:queryexecute getReportsByRole xsp:exprlogin/xsp:expr/esql:query esql:results reports esql:row-results report report-name esql:get-string column=Name/ /report-name /report esql:execute-query esql:queryexecute getAttributesForReport esql:get-int column=1//esql:query esql:results parameters esql:row-results parameter parameter-name esql:get-string column=2/ /parameter-name /parameter /esql:row-results /parameters /esql:results /esql:execute-query /esql:row-results /reports /esql:results /esql:execute-query Thanks for the help Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Running a query in xsl page
Is it possible to run an query in my xsl style sheet based on the input I get from an xsp page using the connection pool from cocoon? Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
making an esql value an element in the xsp
How do I make an esql value an element. I have : parameter-name esql:get-string column=3/ /parameter-name which results in parameter-namebob/parameter-name I want the result to be parameter-name bob/bob /parameter-name Thanks for the help Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: making an esql value an element in the xsp
Works for me -Original Message- From: Christian Haul [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:55 AM To: [EMAIL PROTECTED] Subject: Re: making an esql value an element in the xsp On 11.Jun.2003 -- 10:47 AM, Tim Bachta wrote: How do I make an esql value an element. parameter-name esql:get-string column=3/ /parameter-name xsp:elementxsp:param name=nameesql:get-string column=3//xsp:param/xsp:element Sorry, no shortcut available. 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]
XML file
Is there a way/place to view the xml file that is created from my xsp. Thank you Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: XML file
I tried this and it does not work for me. It shows me the xml but it does not run the query correctly so I am not getting the same info that I am getting on a regular view. Is there another way? Tim Bachta (913)693-0538 Office (913)486-5213 Mobile -Original Message- From: Conal Tuohy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:10 PM To: [EMAIL PROTECTED] Subject: RE: XML file http://wiki.cocoondev.org/Wiki.jsp?page=DebuggingWithViews -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 June 2003 10:10 a.m. To: [EMAIL PROTECTED] Subject: XML file Is there a way/place to view the xml file that is created from my xsp. 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]
RE: XML file
map:match pattern=login map:generate type=serverpages src=xsp/login.xsp label=debug1/ map:transform type=xslt src=style/dialog.xsl label=debug2 map:parameter name=css-stylesheet value=global.css/ /map:transform map:serialize type=html/ /map:match the view element looks just like the site. I am getting an xml page back but it is not the same as what I would see. What is happening is that I have a login form that submits to this page. In this page I run a query to validate login. In the xml that I get back I am seeing invalid login but in the actual html that is produced the login is validated. That is why I am saying the xml does not match up. Tim Bachta (913)693-0538 Office (913)486-5213 Mobile -Original Message- From: Conal Tuohy [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 9:49 PM To: [EMAIL PROTECTED] Subject: RE: XML file Try posting the pipeline from your sitemap, so we can see what you have done, and get an idea of what is going wrong. Otherwise we are just guessing. Cheers! Con -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 June 2003 2:44 p.m. To: [EMAIL PROTECTED] Subject: RE: XML file I tried this and it does not work for me. It shows me the xml but it does not run the query correctly so I am not getting the same info that I am getting on a regular view. Is there another way? - 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]
Gif image
I am trying to show an image in my final file. I am using the following code in my xsl file but when I go to the page as all I get is the blank image icon. Can anyone please help me with my little issue here, I know it is probably a stupid mistake but I have not been able to find it anywhere. Thanks. img src=C:\Program Files\Apache Group\Tomcat 4.1\webapps\cocoon\vyzo\images/icons/disabled/keypad.gif /br /Keypad Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Gif image
Ok, I tried this and no luck, I don't understand what I am doing wrong?
Xsl:
img src=images/icons/disabled/keypad.gif /
Sitemap:
map:match pattern=**.gif
map:read src=images/{1}.gif mime-type=image/gif/
/map:match
map:match pattern=images/icons/disabled/**.gif
map:read src=images/icons/disabled/{1}.gif mime-type=image/gif/
/map:match
The images a located in an images folder off of the root from there they
have subfolders in this case icons with a subfolder called disabled.
Thanks
Tim
-Original Message-
From: Geoff Howard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 10:30 AM
To: [EMAIL PROTECTED]
Subject: Re: Gif image
Well, first of all that image src reference is to the image on your
local
computer - so even if you get it working locally, it won't work for
anyone
but you. Actually, it starts off that way and then ends with what was
probably
meant to be the reference to the server location via http.
Second, be sure you have a pipeline set up to serve static content, or
your
webserver/cocoon setup causes static images to be served directly from
the
webserver.
See: http://wiki.cocoondev.org/Wiki.jsp?page=ServingStaticFiles
Geoff Howard
At 11:23 AM 6/10/2003, you wrote:
I am trying to show an image in my final file. I am using the
following
code in my xsl file but when I go to the page as all I get is the blank
image icon. Can anyone please help me with my little issue here, I
know
it is probably a stupid mistake but I have not been able to find it
anywhere. Thanks.
img src=C:\Program Files\Apache Group\Tomcat
4.1\webapps\cocoon\vyzo\images/icons/disabled/keypad.gif /br
/Keypad
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]
Spacing issues?
How come I am getting huge amounts of space between
hard-coded items and database items in my view source when they should be no
space according to my code?
Ex.
Code = div id=panel_sw{report-name} class=dlgPanel
I would expect div id=panel_swReportName class=dlgPanel
Source = div
class=dlgSwitch id=sw
Overdue
Task Report
Tim Bachta
(913)693-0538 Office
(913)486-5213 Mobile
image001.jpg
RE: Spacing issues?
Where do I put that?
-Original Message-
From: Joerg Heinicke [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Spacing issues?
{normalize-space(report-name)}
Joerg
Tim Bachta wrote:
How come I am getting huge amounts of space between hard-coded items
and
database items in my view source when they should be no space
according
to my code?
Ex.
Code = div id=panel_sw{report-name} class=dlgPanel I would
expect
div id=panel_swReportName class=dlgPanel
Source = div class=dlgSwitch id=sw
Overdue
Task
Report
* *
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]
RE: Spacing issues?
I do not have a xsl:variable named report-name how do I declare that?
I am going to get that book this evening.
-Original Message-
From: Andre Thenot [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Spacing issues?
That was an XPath expression.
Use (assuming you have an xsl:variable named report-name):
div id=panel_sw{report-name} class=dlgPanel
xsl:attribute name=idpanel_swxsl:value-of select=normalize-
space($report-name)//xsl:attribute
/div
Further reading: XML in a nutshell, published by O'Reilly, look
at chapter on XSL.
A.
On Tuesday, June 10, 2003, at 05:19 PM, Tim Bachta wrote:
Where do I put that?
-Original Message-
From: Joerg Heinicke [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Spacing issues?
{normalize-space(report-name)}
Joerg
Tim Bachta wrote:
How come I am getting huge amounts of space between hard-coded items
and
database items in my view source when they should be no space
according
to my code?
Ex.
Code = div id=panel_sw{report-name} class=dlgPanel I would
expect
div id=panel_swReportName class=dlgPanel
Source = div class=dlgSwitch id=sw
Overdue
Task
Report
* *
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]
--
André Thénot - [EMAIL PROTECTED]
p e a c e : p a i x : p a x : s h a l o m
-
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]
conditions in xsl
Is it possible to do if statements in an xsl page. What I am trying to
do is set the first value I get back as selected then set the rest as
unselected. Example since it is hard to explain.
I currently have this:
xsl:template match=report
xsl:variable name=report-namexsl:value-of
select=report-name//xsl:variable
div id=sw{normalize-space(report-name)} class=dlgSwitchSelected
img src=images\icons\occurrenceOverview.gif /xsl:value-of
select=normalize-space(report-name)//div
/xsl:template
this gives me back this:
div class=dlgSwitchSelected id=swOverdue Task Report
img src=images\icons\occurrenceOverview.gifOverdue Task Report/div
div class=dlgSwitchSelected id=swTask Status Report
img src=images\icons\occurrenceOverview.gifTask Status Report/div
div class=dlgSwitchSelected id=swUn-Assigned Task Report
img src=images\icons\occurrenceOverview.gifUn-Assigned Task
Report/div
What I want is to get this back:
div class=dlgSwitchSelected id=swOverdue Task Report
img src=images\icons\occurrenceOverview.gifOverdue Task Report/div
div class=dlgSwitch id=swTask Status Report
img src=images\icons\occurrenceOverview.gifTask Status Report/div
div class=dlgSwitch id=swUn-Assigned Task Report
img src=images\icons\occurrenceOverview.gifUn-Assigned Task
Report/div
where the only one that has the selected class is the first one. Any
help would be great. Thank you very much.
Tim Bachta
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
CSS in Cocoon
I am trying to use a stylesheet in a xsl page and am getting a null pointer exception coming from my xsl page. My syntax is below, I am new to Cocoon so please excuse my mistakes. I appreciate the help. dialog.xsl xsl:param name=html.stylesheet select=global.css'/ xsl:param name=html.stylesheet.typetext/css/xsl:param sitemap map:match pattern=login map:generate type=serverpages src=xsp/login.xsp/ map:transform type=xslt src=style/dialog.xsl map:parameter name=css-stylesheet value=global.css/ /map:transform map:serialize type=html/ /map:match map:match pattern=global.css map:read src=global.css mime-type=text/css/ /map:match Thank you Tim B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: CSS in Cocoon
So if I replaced the dialog.xsl to read: headxsl:param name= css-stylesheet select=global.css'/ xsl:param name=css-stylesheettext/css/xsl:param Assuming the sitemap has not changed, it should work? It does not. ??? -Original Message- From: Conal Tuohy [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:41 PM To: [EMAIL PROTECTED] Subject: RE: CSS in Cocoon Tim, presumably dialog.xsl is supposed to insert a link element into the html, pointing at the stylesheet which is passed as a parameter? But the dialog.xsl appears to expect a parameter called html.stylesheet, whereas the parameter you are actually passing it (from the sitemap) is called css-stylesheet. Cheers! Con -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 June 2003 08:19 To: [EMAIL PROTECTED] Subject: CSS in Cocoon I am trying to use a stylesheet in a xsl page and am getting a null pointer exception coming from my xsl page. My syntax is below, I am new to Cocoon so please excuse my mistakes. I appreciate the help. dialog.xsl xsl:param name=html.stylesheet select=global.css'/ xsl:param name=html.stylesheet.typetext/css/xsl:param sitemap map:match pattern=login map:generate type=serverpages src=xsp/login.xsp/ map:transform type=xslt src=style/dialog.xsl map:parameter name=css-stylesheet value=global.css/ /map:transform map:serialize type=html/ /map:match map:match pattern=global.css map:read src=global.css mime-type=text/css/ /map:match Thank you Tim B - 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: CSS in Cocoon
Thanks, that worked. -Original Message- From: Amelie Cordier [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: RE: CSS in Cocoon Hello Why using params in your xsl? Why don't you try something like that : In your xsl : link rel=stylesheet type=text/css href=style.css/ And in the sitemap : map:match pattern=style.css map:read mime-type=text/css src=stylesheets/style.css/ /map:match This is what I do and it works perfectly but I don't know if it'a a good solution :) Cheers ! Amelie So if I replaced the dialog.xsl to read: headxsl:param name= css-stylesheet select=global.css'/ xsl:param name=css-stylesheettext/css/xsl:param Assuming the sitemap has not changed, it should work? It does not. ??? -Original Message- From: Conal Tuohy [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:41 PM To: [EMAIL PROTECTED] Subject: RE: CSS in Cocoon Tim, presumably dialog.xsl is supposed to insert a link element into the html, pointing at the stylesheet which is passed as a parameter? But the dialog.xsl appears to expect a parameter called html.stylesheet, whereas the parameter you are actually passing it (from the sitemap) is called css-stylesheet. Cheers! Con -Original Message- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 June 2003 08:19 To: [EMAIL PROTECTED] Subject: CSS in Cocoon I am trying to use a stylesheet in a xsl page and am getting a null pointer exception coming from my xsl page. My syntax is below, I am new to Cocoon so please excuse my mistakes. I appreciate the help. dialog.xsl xsl:param name=html.stylesheet select=global.css'/ xsl:param name=html.stylesheet.typetext/css/xsl:param sitemap map:match pattern=login map:generate type=serverpages src=xsp/login.xsp/ map:transform type=xslt src=style/dialog.xsl map:parameter name=css-stylesheet value=global.css/ /map:transform map:serialize type=html/ /map:match map:match pattern=global.css map:read src=global.css mime-type=text/css/ /map:match Thank you Tim B - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: MS SQL Stored Procedure Help
Ok, I am not having a problem with the input parameters it is the output
parameter that I am having issues with. This is more of a callable
statement than a stored procedure. Here is what I am trying to no
avail.
esql:execute-query
esql:call
{esql:parameter type=Int direction=out/=call
getLoginResult(esql:parameter type=String
direction=inxsp:expruser/xsp:expr/esql:parameter,esql:paramete
r type=String
direction=inxsp:exprpassword/xsp:expr/esql:parameter)}
/esql:call
esql:results
esql:call-results
xsp:logic
login = esql:get-int column=1 from-call=yes/;
/xsp:logic
/esql:call-results
/esql:results
/esql:execute-query
Thanks
Tim
-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):
esql:call
{call proc_info(
esql:parameter
type=Intxsp:exprInteger.parseInt(id)/xsp:expr/esql:parameter
)}
/esql:call
esql:results
esql:row-results
...
/esql:row-results
/esql:results
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 this a jdbc driver issue or strictly enforced by jdbc,
but
this drived my crazzy.
hth,
Frank
-
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]
Redirect from within an xsp page
Is there a way to redirect from within the xsp page itself based on the result of data from a query? Thanks Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
cocoon to xml or CSV
I am new to cocoon and am trying to find a way to create an CSV or excel file. I have found a little information on the HSSF Serializer but do not know how to implement it. Can anyone help me or show me an example of how to do this properly. Thanks for the help. Tim Bachta - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
