> Here's an OT quickie for all of you into that kinky whips, chains, and
> whipped stuff...
If that is an invitation you can contact me at [EMAIL PROTECTED]
> <cfquery name="getCurrent" datasource="ONCALL">
> SELECT *
> FROM
> DIVISIONS,
> DOCTORS,
> ONCALL_SHIFTS
> WHERE
> DOCTORS.Doc_ID = ONCALL_SHIFTS.Doctor_ID
> AND
> ONCALL_SHIFTS.Division_ID = DIVISIONS.DIVISIONID
> AND
> <cfqueryparam cfsqltype="cf_sql_date"
> value="#DateFormat(Now(),'mm/dd/yyyy')#"> BETWEEN shift_start AND
> shift_End
> ORDER BY DivisionName
> </cfquery>
Good to see you are using a date field now :-)
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
