Clint,
Thanks for the suggestion. I figured out the problem. However, we now have another issue that we are trying to work around: using the like statement in a sproc and CF. It seems that we cannot get any data returned from the sproc when we use a like statement. I've tried passing it w/the %% around the CF var within the sproc input and it was a no-go. We've tried to fix it on the sql side as well by putting the %% around the input it was expecting but no luck.
Any ideas?!
-----Original Message-----
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 12:48 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Stored Procedure & CF
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
