you may or may not have data to insert.
That's generally what I use it for. If I'm checking for NULL, I usually use
IS NULL.
Steve
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 1:33 PM
To: CF-Talk
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/ <http://www.figleaf.com/>
voice: (202) 797-5496
fax: (202) 797-5444
_____
[ Todays Threads
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]