fedkris
asked on
stored procedure, retrieve data
hi,
the stored procedure works, but, he doesn't goes inside the if
if objRecPeriode0("source") = "agenda" then
how can we change that? thx
the stored procedure sends us back
objRecPeriode0("source") = agenda
objRecPeriode0("nbr") = 5000
the stored procedure works, but, he doesn't goes inside the if
if objRecPeriode0("source") = "agenda" then
how can we change that? thx
the stored procedure sends us back
objRecPeriode0("source") = agenda
objRecPeriode0("nbr") = 5000
<%
CmdPeriode = "exec statgeneral " & _
"@periode=0"
Set objRecPeriode0 = cn.Execute(CmdPeriode)
do while not objRecPeriode0.eof
response.write objRecPeriode0("source") & "-" & objRecPeriode0("nbr") & "<br>"
exclu0 = 0
if objRecPeriode0("source") = "agenda" then
exclu0 = exclu0 + objRecPeriode0("nbr")
agenda0 = agenda0 + objRecPeriode0("nbr")
end if
if objRecPeriode0("source") = "commerce monitor" then
exclu0 = exclu0 + objRecPeriode0("nbr")
commercemonitor0 = commercemonitor0 + objRecPeriode0("nbr")
end if
objRecPeriode0.movenext
loop
response.write exclu0
response.write agenda0
response.write commercemonitor0
%>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.