Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Friday, 13 February 2004 3:41 PM
To: CF-Talk
Subject: checking for no date...
I'm using this system of checking for available properties based on the fact
that there would be no data in my date_sold [ DateTime ] field.
I've ran these queries but it gets rejected...BTW using Access for testing,
will be ported to MySQL.
select * from estates where date_sold = null
select * from estates where date_sold = ''
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Daniel Farmer
Coldfusion Developer / Sales / Producer
613.284.1684
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
