Assuming you're using MS-SQL (not sure about other DBs), and assuming you're
only trying to 'get' the data into the variables:
Your variable should start with an '@'.
DECLARE @DeletedAreaName VARCHAR(50);
DECLARE @DeletedLft INTEGER;
DECLARE @DeletedRgt INTEGER;
SELECT TOP 1
@DeletedAreaName = SiteAreaName,
@DeletedLft = Lft,
@DeletedRgt = Rgt
FROM directoryLinks
WHERE SiteAreaName = '#ARGUMENTS.SiteAreaName#'
Oh and I'd use <cfqueryparam>, but you may have stripped that for the sake of
brevity.
Auke
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244619
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
