http://www.ibm.com/developerworks/opensource/library/os-ad-trifecta6/
looks like you can use cast to round values On Dec 9, 2007 8:25 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote: > If ROUND isn't there, look for another rounding function like CEILING, FLOOR > etc. > > Adrian > > -----Original Message----- > From: Dave l > Sent: 09 December 2007 04:18 > To: CF-Talk > Subject: Re: query help > > > if i change the select statement to: > SELECT center_id, address1, city, state, postalcode, state, > ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) + > > it changes the error to: > 'ROUND' is not recognized as a function or procedure. > > > so i might be sol on this tut > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:294413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4