For what you are doing a date field does not seem appropriate. If you really want to store the data in a single field I would store it as a delimited string. (EX; ww:dd:mm:hh) You would then use the list functions *(EX: ListGetAt() ) to extract the data.
-John- At 06:17 PM 12/17/2002 +0000, you wrote: >I'm new to CF and I have hit a wall. >I have 4 select lists (numeric); >Weeks >Days >Minutes >Hours >and I need the user to select a value from each of these lists. The problem >is, how to store the selected values into one field of my database? >I cannot see how CreateDateTime as weeks is not included in the function. >Thanks in advance > >Lisa > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
