It is a smalldatetime column that is pulled straight out of the database no computations.
Joshua TIpton On Mon, 04 March 2002, "Garza, Jeff" wrote: > > There are a few questions on what columns you are working with... > > I'm assuming that timeon.acd_total is the column, is this a computed column > from SQL? > > What is report_time? > > It appears that you have two separate columns that you are trying to put in > here... > > Try something like > > <CFSET report = valuelist(timeformat(timeon.report_time, 'HH:MM'), ",")> > > Jeff Garza > Lead Developer/Webmaster > Spectrum Astro, Inc. > 480.892.8200 > [EMAIL PROTECTED] > http://www.spectrumastro.com > > > > -----Original Message----- > From: Joshua Tipton [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 10:08 AM > To: CF-Talk > Subject: value list of a timeformat > > > What is wrong with this? > > > <cfset report = #valuelist(timeon.acd_total(timeformat(report_time, > "HH:MM"),',')#> > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
