I'm having difficulty declaring sql variables. I've not done so
(correctly) before, but I think it may solve my problem. I've
assigned variables on the fly, though. The following fails with the
declare statement in. It's fine without it. I want to declare a var
and set it to empty, ''.
other sql
(
DECLARE @find varchar(30)
SELECT p.publication_name, p.publication_id,
o.dept,o.link AS author_link,
NVL(o.lname, a.a_lname) AS lastname,
NVL(o.mname, a.a_mname) || '.' AS middlename,
NVL(o.fname, a.a_fname) AS firstname,
a.publicationa_id
FROM publications p
INNER JOIN publications_authors a
ON p.publication_id = a.publication_id
)
So, the question is, how do I declare a variable and set it to
blank? I've used examples from sql tutorial web pages and it doesn't
seem to work (at least that part is consistent).
thanks.
--
Daniel Kessler
College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
Phone: 301-405-2545
http://hhp.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277264
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
