try running this sproc using CFQUERY and not cfstoredproc...
---------- Original Message ----------------------------------
From: "Houk, Gary" <[EMAIL PROTECTED]>
Date: Thu, 21 Jun 2001 09:26:59 -0400
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
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
