Should work fine....how is it not working?......if nothing is happening then
I suggest @polltype is not YM or MC. You could use a CASE statement and
run a default query in the CASE ELSE part. If you don't want to do this
return the value of @polltype to see what it is.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 15:46
To: CF-Talk
Subject: Stored Procedures
In a stored procedure how can you run a conditional query based on the value
of a declared variable? The following does not work.
DECLARE @PollType CHAR
SELECT @PollType = PollType
FROM Polls
WHERE PollStatus = 1
-- Run query depending on PollType
IF @PollType = 'YN'
BEGIN
run query number 1
END
IF @PollType = 'MC'
BEGIN
run query number 2
END
Thanks,
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
