cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Bachta" <tbac...@kopent.com>
Subject RE: esql !!!HELP!!!
Date Tue, 24 Jun 2003 17:35:02 GMT
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: cocoon-users@xml.apache.org
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:Thorsten.Scherler@weidmueller.de] 
Sent: Tuesday, June 24, 2003 12:07 PM
To: cocoon-users@xml.apache.org
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:tbachta@kopent.com] 
Sent: Tuesday, June 24, 2003 6:54 PM
To: cocoon-users@xml.apache.org
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="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>

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


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


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