[web2py] Re: how do I call stored procedure containing parameters?

[isi_jca]

Charles:

You can use this expression:

status = db.executesql("exec mystored @adt_time = ?, @ai_usrid= 
?",placeholders = (ldt_time, auth.user_id)) 

In this case the stored procedure has two arguments.

Greeting.


El miércoles, 1 de junio de 2016, 8:05:53 (UTC-3), Charles tenorio escribió:
>
> hi I like Call stored procedure containing parameters?
> thanks!
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: how do I call stored procedure containing parameters?

[Niphlod]

for simple stored procedures, returning something, executesql() is the way 
to go.

On Wednesday, June 1, 2016 at 1:05:53 PM UTC+2, Charles tenorio wrote:
>
> hi I like Call stored procedure containing parameters?
> thanks!
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.