multiple select drop down box and oracle dates

[James Blaha]

Hi Folks,

I ran into an issue with a multiple select drop down box that has a list of 
dates i.e. mm/dd/yyyy. 

On my action page I have a cfquery that I would like to pass the list of dates 
to like:

Mydates IN ('08/01/2008','08/02/2008',…)

In oracle I need to do something like: TO_DATE('08/01/2008','mm/dd/yyyy'), ect

Any ideas how to do this passing the values from a multiple select box?

Thanks in advance!
-Jim


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4