This is really strange. I am trying to run this stored procedure and I
am not getting anything. It looks like it is skipping over the entire
section. I have verified that data should be coming back and that it is
spelled correctly and have even tried other procedures that worked and
they work. Does anybody have any clue on to why this stored proc would
not work?
<esql:connection>
<esql:execute-query>
<esql:query>
execute rptLocationDeviations
'<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>','<xsp:expr>
endTime</xsp:expr>'
</esql:query>
<esql:results>
<task-date>
<esql:row-results>
<date>
<esql:get-string
column="TaskDate"/>
<task>
<esql:get-string
column="ActionName"/>
<deviation>
<esql:get-int column="hasDeviation"/>
<name>
<esql:get-string column="UserName"/>
</name>
</deviation>
</task>
</date>
</esql:row-results>
</task-date>
</esql:results>
</esql:execute-query>
</esql:connection>
Tim Bachta
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
