I am having a problem getting a result set.
Proc:
CREATE PROCEDURE spFindVisitor
@fname varchar,
@lname varchar
AS
SELECT ID as visitorid
FROM tblVisitor
WHERE first_name = @fname and last_name = @lname
GO
I am calling it like this:
<cfstoredproc procedure = "spFindVisitor" datasource="#request.datasource#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbvarname="@fname" value="holly">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbvarname="@lname" value="bennet">
<cfprocresult maxrows="1" name="qFindVisitor">
</cfstoredproc>
I am not getting any results back, even though I know a record is there. Is
my syntax correct? I've done this times and again under CF 4.5, but now I
am debugging an app under MX, MS SQL 2000. I tried both JDBC and MS SQL
drivers in MX, same results.
Also, is there an advantage in using JDBC over MS SQL and vice versa? If
there is a link on MM's site, I'd greatly appreciate that.
Much thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
