> Thanks Jochem now and how would I treat the following "between
> dates":
>
> '#DateFormat(dailydate, "DD-mmm-YYYY")#' between fromdate5 and
> todate5
>
> I tried <cfqueryparam cfsqltype="cf_sql_date"
> value="#dailydate#">between fromdate1 and todate1 but get the
> following error:
>
> Syntax error (missing operator) in query _expression_ 'approval = 'Y'
> AND Pa_RaM000between fromdate1 and todate1
The idea is correct, but notice that there is no space between
"Pa_RaM000between". Just add it in your code.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
