> DBVarName doesn't sound right either then, because I'm not
> trying to
> match anything in the database. Just trying to pass a
> variable which
> is declared in the sp. The variable I declare doesn't have
> to be the
> same as any column name in the db.
Yes... though that's not what dbvarname was designed to match...
dbvarname was designed to match the name of the stored procedure
parameter.
> Here's the sp:
> CREATE PROCEDURE dbo.qry_autotags3
> (@PINNumber char(11))
> AS
> BEGIN
> SET NOCOUNT ON
> SELECT *
> FROM DMVRenewals (NOLOCK)
> WHERE PINNumber = @PINNumber
> ORDER BY ExpDate desc
> RETURN(0)
> END
> GO
I think the BEGIN and END around your procedure body are
unnecessary... Also if you're not actually returning variables you can
omit the return statement.
CREATE PROCEDURE dbo.qry_autotags3 (
@PINNumber char(11)
) AS
SET NOCOUNT ON
SELECT *
FROM DMVRenewals (NOLOCK)
WHERE PINNumber = @PINNumber
ORDER BY ExpDate desc
GO
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207287
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
