Hi guys, I have the following table...
Season_period ------------- Sp_id (PK) Season_id (FK) Sp_start_day (INT) Sp_start_month (INT) Sp_end_day (INT) Sp_end_month (INT) What I wish to do is select the season_id using a particular date. I am really not sure how to compare an actual date against just a day/month value. I am going to loop through a series of dates, and wish to know the matching season_id for a particular date. Any ideas on how I should go about building this query would be greatly appeciated. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
