dateAdd() function. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_25.html#1102869
On Nov 5, 2007 6:07 AM, Toby King <[EMAIL PROTECTED]> wrote: > Hi there > > In an application I have a page where a user can select how long an event > goes - i.e. 30 minutes, 45 minutes, 60 minutes etc. > > In the MySQL database that I have two fields a starttime and a finishtime. > > Currently I have the following sql to update the database > > UPDATE tbl_bookings > SET starttime = #CreateODBCDateTime(form.startdate)#, > finishtime = #CreateODBCDateTime(form.startdate)#, > bookingstatus = '2' > Where bookingid = '#form.bookingid#' > > This is at least giving me data in the finishtime column. What I am > trying to do is use the value selected by the user i.e. 30, 45, 60 etc and > add it to the starttime to get the finishtime but I have not succeeded. > > Just wondering if anyone could offer suggestions. > > Many thanks. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
