Performing the procedure directly in MySQL Workbench returns correctly. The
error occurs in:
raw_rows = db.executesql(proc, fields=fields)
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
if auth.user_id:
user_id = auth.user_id
fields = [db.auth_user.generation, db.auth_user.id, db.auth_user.first_name]
proc = 'CALL sp_recursive_start(' + str(user_id) + ');'
raw_rows = db.executesql(proc, fields=fields)
while db._adapter.cursor.nextset():
#print db._adapter.cursor.fetchall()
pass
Not after.
Thanks...
On Tue, Mar 5, 2013 at 5:38 PM, Niphlod <[email protected]> wrote:
> ok, no problem. Seems the same error because you're trying to iterate over
> something that is not a list, but a None.
>
> English "aside", what difference there is between the working "location"
> and the "not working" one ?
> Are you sure that your recursive procedure returns rows instead of None in
> the "not working" one ?
>
>
> --
>
> ---
> 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 [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
