<cfqueryparam
value="#CreateODBCDate(FORM.paidThru)#"
cfsqltype="cf_sql_date"
Null="#YesNoFormat(Trim(FORM.transactionType LTE 5) AND
Len(Trim(FORM.paidThrough)) GT 0)#>
Michael T. Tangorre
> <scratches head> Could be, though this dump looks correct:
>
> In this case nothing is being passed to the CreateODBCDate()
> function, because no date (correctly) is being passed for "paidThru".
>
>
> AMOUNTPAID 10.00
> FIELDNAMES
> FIRSTNAME,MIDDLENAME,LASTNAME,MEMBERLEVELID,TRANSACTIONDATE,TR
> ANSACTIONTYPE,
> REASONCODE,TRANSACTIONDURATION,AMOUNTPAID,PAIDTHRU,REFERRALCRE
> DITNAME,REFERR
> ALCREDITDATE
> FIRSTNAME Teresa
> LASTNAME Morris
> MEMBERLEVELID G
> MIDDLENAME [empty string]
> PAIDTHRU [empty string]
> REASONCODE [empty string]
> REFERRALCREDITDATE [empty string]
> REFERRALCREDITNAME [empty string]
> TRANSACTIONDATE 08/03/2004
> TRANSACTIONDURATION 1
> TRANSACTIONTYPE 2
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
