I have Oracle db entries where three numbers represent a date. This
is because the user can enter in just the year, or just the year and
month, or the whole dang thing. Now though, I have to query on this
to find if the "date" is between two other dates in the search
parameters. Also, the month or day entries that weren't used are
left blank (null), so that when editing is done, they still appear as
not selected.
Do I do:
dbYear < searchYear AND dbyear > searchYear2
if so dbMonth < searchMonth AND dbMonth > searchMonth2
if so dbDay < searchDay AND dbMonth > searchDay2
or do I figure out some way to create a date in SQL variables, which
I really don't know how to do, and put in base numbers where the
entries are blank, like using 1 for a beginDay that is left blank and
28,30, or 31 for endDays that are left blank and similar for months.
Thanks for any assistance.
--
Daniel Kessler
College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
Phone: 301-405-2545
http://hhp.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276543
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
