The quotes are extra and not needed. I've just been trying every variation that I can think of.
-Brian
Have you looked at the generated java file under the work directory? That
usually clears up mysterious xsp problems for me.
Do you need the single quotes around the parameter value (thought esql would
put them in for you)
Geoff Howard
>
>
> -Brian
>
>
>
>
> >
> >Yeah, I caught that and fixed it already. It was a problem, but not the
> >end of my problems.
> >
> >-Brian
> >
> >
> >
> >
> >>From: Jacob Arnold <[EMAIL PROTECTED]>
> >>Reply-To: [EMAIL PROTECTED]
> >>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> >>Subject: RE: Cocoon/XSP/ESQL help
> >>Date: Fri, 10 Jan 2003 14:39:49 -0700
> >>
> >> >I have a simple XSP page. I want to use ESQL to call stored
> procedures
> >>in
> >> >a Microsoft SQL Server database. I've got my connection pool set up
> >> >correctly. I'm able to execute simple select statements and
> I'm able to
> >> >execute a stored procedure that doesn't take any parameters.
> But most
> >>of
> >> >my stored prcedures take parameters. Can't seem to find any good
> >>examples
> >> >anywhere. My code is below. Anyone able to tell me what I'm doing
> >>wrong?
> >> >Thanks.
> >>
> >><esql:call>{ call sp_DayShift_Report_ListByName((<esql:parameter
> >>direction="in" type="String"><xsp-request:get-parameter
> >>name="sQuerry"/></esql:parameter>) }</esql:call>
> >>
> >>On second glance, it looks like you may have an extra open parenthesis.
> >>
> >>J
> >>
> >>---------------------------------------------------------------------
> >>Please check that your question has not already been answered in the
> >>FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> >>
> >>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> >>For additional commands, e-mail: <[EMAIL PROTECTED]>
> >
> >
> >_________________________________________________________________
> >STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> >http://join.msn.com/?page=features/junkmail
> >
> >
> >---------------------------------------------------------------------
> >Please check that your question has not already been answered in the
> >FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> >
> >To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> >For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
