I have a stored procedure that is working fine in SQL 2000 when ran through the query analyzer. When I use the cfstoreproc tag, I can get CF to generate a columnlist, but no data! Not sure why, I have done this several times w/other SP's but this one doesn't seem to work when it's in the page. Here's the code:
<cfstoredproc procedure="sp_RsscInquiryBySource" datasource="teleproducts" returncode="yes">
<cfprocparam type="In"
cfsqltype="CF_SQL_CHAR"
dbvarname="Date1"
value="06/20/2001 00:00:00">
<cfprocparam type="In"
cfsqltype="CF_SQL_CHAR"
dbvarname="@Date2"
value="06/20/2001 23:59:59">
<cfprocparam type="In"
cfsqltype="CF_SQL_CHAR"
dbvarname="@SOURCE"
value="cssc_web_s">
<cfprocresult name="orders" resultset="1">
</cfstoredproc>
Outputting a columnlist works fine, but no data comes with it :-(
Thanks in advance,
Gary
