[Freeswitch-users] Calling stored procedure in freeswitch database or using luasql

[Shahzad_Sab]

Thanks for the replay
but when i try 
assert(
        con:execute("call csp_test();",
                function(qrow)
                        for key, val in pairs(qrow) do
                                myrow[key] = val
                                found = found + 1
                        end
                end
        )
)
*i got error:*
LuaSQL: Error executing query. MySQL: PROCEDURE test.csp_test can't return a
result set in the given context
and when i try 
assert(
        con:query("call csp_test();",
                function(qrow)
                        for key, val in pairs(qrow) do
                                myrow[key] = val
                                found = found + 1
                        end
                end
        )
)
*i got Error:*
attempt to call method 'query' (a nil value)

any further help.




-----
Regards

Shahzad Bhatti
+92-300-433-4033
+92-321-401-8917
--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Calling-stored-procedure-in-freeswitch-database-or-using-luasql-tp7590895p7595965.html
Sent from the freeswitch-users mailing list archive at Nabble.com.