Testing for NULL in stored procedures

I am working on a poll which allows multiple selections. How do I get this strored procedure to work? I am passing null values from the cfstoredproc tag and want to conditionally run a query depending n whether the value of the variable is NULL or not. I have tried NULL, NOT NULL, !=. With

RE: Testing for NULL in stored procedures

Try IS NOT NULL Craig -Original Message- From: sebastian palmigiani [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 10:49 AM To: CF-Talk Subject: Testing for NULL in stored procedures I am working on a poll which allows multiple selections. How do I get

RE: Testing for NULL in stored procedures

]] Sent: 08 March 2001 15:49 To: CF-Talk Subject: Testing for NULL in stored procedures I am working on a poll which allows multiple selections. How do I get this strored procedure to work? I am passing null values from the cfstoredproc tag and want to conditionally run a query depending n whether

RE: Testing for NULL in stored procedures

2001 15:49 To: CF-Talk Subject: Testing for NULL in stored procedures I am working on a poll which allows multiple selections. How do I get this strored procedure to work? I am passing null values from the cfstoredproc tag and want to conditionally run a query depending n whether the value

Re: Testing for NULL in stored procedures

on 3/8/01 9:59 AM, Andy Ewings at [EMAIL PROTECTED] wrote: or rather! IF @ChoiceA IS NOT NULL Yep that did the trick. Thanks Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at