When I run the following query in SQLPlus, any row with a 'valid_to_date'
older than today's date is excluded. But when I run the same query in CF,
they are included. Why?
~~ CF 5 on Win2K hitting Oracle 8i on IBM Mainframe ~~
valid_to_date is a date field, not varChar2
SELECT ID, course_prefix, course_number, course_title, valid_to_date
FROM siswarehouse.course_description
WHERE course_prefix LIKE 'W%' AND
(valid_to_date IS NULL OR
valid_to_date = '' OR
valid_to_date > '02-Apr-2003')
ORDER BY course_prefix, course_number
Thanks,
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89
70.4
