Re: esql !!!HELP!!!

2003-06-25 Thread Christian Haul 
On 24.Jun.2003 -- 12:35 PM, Tim Bachta 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.

Please post relevant parts of that file. It will help to solve your
issues tremendously.

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

2003-06-25 Thread Frank Taffelt 
you could try annother msssql jdbc driver. I'm using
http://jtds.sourceforge.net also with stored procedures and it works. The
driver from microsoft is known to have some bugs.

hth,
Frank


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: esql !!!HELP!!!

2003-06-24 Thread Tim Bachta 
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:


{call rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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

 internal. set one parameter of a callable statement



_esql_query.getCallableStatement().
registerOutParameter(,
,  );


_esql_query.getCallableStatement().




 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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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:

Re: esql !!!HELP!!!

2003-06-24 Thread Roger I Martin PhD 
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\language\m
arkup\xsp\java\esql.xsl at particularly

 internal. set one parameter of a callable statement



_esql_query.getCallableStatement().
registerOutParameter(, ,  );


_esql_query.getCallableStatement().




 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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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

RE: esql !!!HELP!!!

2003-06-24 Thread Tim Bachta 
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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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:
>
>
>
> 
>
> {? = rptLocationDeviations(type="Int">number,direction="in"
>type="String">room,direction="in"
>type="String">beginTime,meter direction="in"
>type="String">endTime)}
>
> 
>
> 
>
> 
>
> 
>
> 
>
> column="1" from-call="true"/>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
>
>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.c

RE: esql !!!HELP!!!

2003-06-24 Thread Tim Bachta 
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:


{? = rptLocationDeviations(number,room,beginTime,endTime)}



(ResultSet)











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:
>
>
>
> 
>
> {? = rptLocationDeviations(type="Int">number,direction="in"
>type="String">room,direction="in"
>type="String">beginTime,meter direction="in"
>type="String">endTime)}
>
> 
>
> 
>
> 
>
> 
>
> 
>
> column="1" from-call="true"/>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
>
>
>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

RE: esql !!!HELP!!!

2003-06-24 Thread Geoff Howard 
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+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:




{? = rptLocationDeviations(number,room,beginTime,endTime)}





































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]

RE: esql !!!HELP!!!

2003-06-24 Thread Tim Bachta 
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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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

2003-06-24 Thread Tim Bachta 
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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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

2003-06-24 Thread Scherler, Thorsten 
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
  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:





{? = rptLocationDeviations(number,room,beginTime,endTime)}























 














 

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]

RE: ESQL help

2003-06-24 Thread Scherler, Thorsten 
Hello Tim,

first hint:
http://wiki.cocoondev.org/Search.jsp?query=esql

I think what you are looking for:
http://wiki.cocoondev.org/Wiki.jsp?page=DatabaseConnectionOverview

Hope that helps


-Original Message-
From: Tim Bachta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 24, 2003 6:08 PM
To: [EMAIL PROTECTED]
Subject: ESQL help

Does anyone know of a good place to get help with esql issues?  I am
having a very difficult time finding any information regarding how to
correctly call a MS SQL stored procedure.  I have looked at the official
cocoon documentation and have the Cocoon developers handbook, neither
have much useful information.  I am in desperate need of help.

 

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]