On 10/20/2003 at 16:20, you wrote:
TL> null ="#YesNoFormat(NOT Len(form.exp_years))#"
Len() is being used as a boolean (zero=false, non-zero=true). In this
case, you have to use NOT Len() in order to get the appropriate value
for the NULL attribute. YesNoFormat() just converts the boolean to
'yes' or 'no'.
So the CFQUERYPARAM is going to pass a NULL to the database if
Len(form.exp_years) eq 0.
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
