This where clause:
<cfqueryparam cfsqltype="cf_sql_integer" value="#page[j][i]#">BETWEEN START_DAY AND END_DAY
AND
<cfqueryparam cfsqltype="cf_sql_integer" value="#URL.M#"> BETWEEN START_MONTH AND END_MONTH
AND
<cfqueryparam cfsqltype="cf_sql_integer" value="#URL.Y#"> BETWEEN START_YEAR AND END_YEAR
does not work when you have a date range that spans more than one month.
Example:
Start_Month = 1
Start_Day = 18
Start Year = 2004
End_Month = 2
End_Day = 8
End_Year = 2004
Basically, while looping, if my #page[j][i]# was on the number 3, it would return false, because 3 is not between 18 and 8.
Any way around this?
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 1/29/2004 9:40:34 AM >>>
Candace Cottrell said:
> Ok, it worked.... so was there a problem with my cfif's?
Apparently ;-)
It just seemed easier to replace the QofQ's with simple comparisons.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
