On 19/12/2007, at 12:59 AM, Rajesh nair wrote:
This code crashes when I do a ns_db select with SQL = “Exec procedure> @params”.
Crash is such a harsh word, don't you mean "throws an error"? I bet
the error is "... is not a statement returning rows" or similar.
I can do a ns_db exec “exec @pa
Thanks Bas,
Two Queries here :
1. Do you mean a code like this ?
<%
if {[catch {
set db [ns_db gethandle];
set sql1 "use rajesh";
ns_puts "RESULT1[ns_db exec $db $sql1] ";
set sql2 "EXEC myprocddd @param =";
###