I can do even more with the generator, I found out ...
I extended my stored procedure to return 2 resultsets: 1 with the data,
and one with the "dashboard" data.
For instance, when I create my report on "Jobs per day", I have a little
box below my report stating how many days we have, how many
I don't know if it makes any difference, but we always use the SQL
escape syntax described in the CallableStatement javadocs[1]. Does it
make any difference if you use
{call spJobsperday 0, 2, '', '', '', '', '', '', '', '', ''}
?
Your suggestion gives this error
You have an error in your S
From: Yves Vindevogel <[EMAIL PROTECTED]>
Date: Sat, 27 May 2006 13:14:05 +0200
Ok, here's some more copy and pasting
This is the command line executed in putty or ssh with the results (which
are correct)
(0 means offset 0, 2 means limit 2)
[EMAIL PROTECTED]:~# mysql pdt2 --execute "call
Retry with CALL
call spJobsperday(0, 2, '', '', '', '', '',
'', '', '', '')
(ResultSet)column="1"/>
XSP with ESQL seems to give the same problem
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">
pdt10010
Ok, here's some more copy and pasting
This is the command line executed in putty or ssh with the results
(which are correct)
(0 means offset 0, 2 means limit 2)
[EMAIL PROTECTED]:~# mysql pdt2 --execute "call spjobsperday(0, 2, '',
'', '', '', '', '', '', '', '')"
++--+--
From: Yves Vindevogel <[EMAIL PROTECTED]>
Date: Sat, 27 May 2006 03:12:45 +0200
Hi,
This is my call to the db in the shell
mysql pdt2 --execute "call spjobsperday(0, 2, '', '', '', '', '', '',
'', '', '')"
++--+---+--+--+
| EventDate | Jobs | Pages | Fi
Just tried to put my simple select query instead of my "call" and that
works.
Is this a jdbc problem with calling stored procs ?
Or is this a sql transformer problem ?
Yves Vindevogel wrote:
Hi,
This is my call to the db in the shell
mysql pdt2 --execute "call spjobsperday(0, 2, '', '',
Hi,
This is my call to the db in the shell
mysql pdt2 --execute "call spjobsperday(0, 2, '', '', '', '', '',
'', '', '', '')"
++--+---+--+--+
| EventDate | Jobs | Pages | FirstJob | LastJob |
++--+---+--+--+
| -00-
