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="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</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>
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_8888)
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="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
>direction="in"
>type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:paramete
r
>direction="in"
>type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:par
a
>meter direction="in"
>type="String"><xsp:expr>endTime</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]
---------------------------------------------------------------------
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]
