I knew that just hard-coding the IS NULL would be ok...but I thought that consistently using the <cfqueryparam> would be..."better". And knowing about the NULL attribute of the tag (thanks to Dave's article up on MM*), thought it could/should work.
Just wanted to make sure i wasn't overlooking anything or trying to use the tag incorrectly.
Thanks!
charlie
* which is a must-read, btw...if you haven't yet, it's at http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html
----- Original Message -----
From: Dave Watts
To: CF-Talk
Sent: Tuesday, September 30, 2003 10:33 AM
Subject: RE: cfqueryparam and NULL values (SELECT)
> There is no way to use CFQUERYPARAM to pass a NULL to the
> database, so for that 'value' (and that value alone) you
> HAVE to use it directly.
This may be true sometimes, but isn't always true. That's why CFQUERYPARAM
has a NULL attribute - for exactly those cases. Some databases do allow the
use of NULL with the equality operator.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
