RE: Stored Procedure Help

[Tim Bachta]

It's a different error this time.  
Error getting ascii data for column ActionName

Thanks for the help

Tim Bachta
 

-Original Message-
From: Frank Taffelt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 24, 2003 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedure Help

try the following:




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

  
   
 
  


-
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: Stored Procedure Help

[Frank Taffelt]

try the following:




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

  
   
 
  


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

Stored Procedure Help

[Tim Bachta]

I am using MS SQL 2000 as a database.  I am trying to run a stored
procedure using the following code:

 



  

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

  

  



  

   

 

  

   

  

   

 



  



 

I am getting back an error message of invalid parameter bindings.  I
checked my input parameters and they are set up correctly.  Any
suggestions would be greatly appreciated.  

 

Thank you

 

Tim Bachta

 

 


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

Re: MS SQL Stored Procedure Help

[Frank Taffelt]

i'm not sure if the esql:results element is needed in your case.

try the following structure:

   ...


   ...



maybe this helps:
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=102752486530060&w=2

Frank

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

RE: MS SQL Stored Procedure Help

[Tim Bachta]

Ok, I am not having a problem with the input parameters it is the output
parameter that I am having issues with.  This is more of a callable
statement than a stored procedure.  Here is what I am trying to no
avail.


{=call
getLoginResult(user,password)}




login = ;





Thanks

Tim

-Original Message-
From: Frank Taffelt [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 06, 2003 2:40 AM
To: [EMAIL PROTECTED]
Subject: Re: MS SQL Stored Procedure Help

this is a snippet which works for me under mssql (jtds driver):


{call proc_info(
 Integer.parseInt(id)
 )}
 
 

   ...

 

i'm remembering problems with the positioning of "{" and the following
"call" keyword. You have to make sure that there is no space between
them.
I'm not sure if this a jdbc driver issue or strictly enforced by jdbc,
but
this drived my crazzy.

hth,
Frank


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

MS SQL Stored Procedure Help

[Tim Bachta]

I am trying to call this procedure using cocoon.  getLoginResult.  This
stored procedure takes 2 strings and returns an int.  My code is below
but I am getting an error of incorrect syntax near {.  I have tried
literally hundreds of different combinations with nothing working can
someone please show me the light?



vyzo





{ getLoginResult (user,password)}











 login = ;













 

 

Thank you

 

Tim

 


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

Re: MS SQL Stored Procedure Help

[Frank Taffelt]

this is a snippet which works for me under mssql (jtds driver):


{call proc_info(
 Integer.parseInt(id)
 )}
 
 

   ...

 

i'm remembering problems with the positioning of "{" and the following
"call" keyword. You have to make sure that there is no space between them.
I'm not sure if this a jdbc driver issue or strictly enforced by jdbc, but
this drived my crazzy.

hth,
Frank


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