What version of Windows? What version of SQL Server 2005 (have you applied all the service packs)? What version of ColdFusion?
On 26/06/07, Taco Fleur <[EMAIL PROTECTED]> wrote: > I just realized I did not post the offending code, the code that generates > the error is; > > > > > DECLARE @fromLatitude AS REAL > > , @fromLongitude AS REAL > > , @toLatitude AS REAL > > , @toLongitude AS REAL > > SET @fromLatitude = -31.111695 > > SET @fromLongitude = 117.792134 > > SET @toLatitude = -31.111695 > > SET @toLongitude = 117.792134 > > > > DECLARE @distance REAL > > SET @distance = ( ROUND ( ( ACOS( ( SIN( @fromLatitude / 57.2958 ) * SIN( > @toLatitude / 57.2958 ) ) + > > ( COS ( @fromLatitude / 57.2958 ) * COS ( @toLatitude / 57.2958 ) * COS( > @toLongitude/57.2958 - @fromLongitude / 57.2958 ) ) ) ) * 6378.135 , 3 ) ) > > SELECT @distance; > > > On 6/26/07, Taco Fleur <[EMAIL PROTECTED]> wrote: > > > > > > The following does not generate an error, replace the values with the > previous ones and the domain error occurs. > > > > DECLARE @fromLatitude AS REAL > > > > ,@fromLongitude AS REAL > > > > ,@toLatitude AS REAL > > > > ,@toLongitude AS REAL > > > > [EMAIL PROTECTED] = -27.339993 > > > > [EMAIL PROTECTED] = 152.936964 > > > > [EMAIL PROTECTED] = -27.339993 > > > > [EMAIL PROTECTED] = 152.936964 > > > > > > > > > > [EMAIL PROTECTED] REAL > > > > [EMAIL PROTECTED] = ( ROUND ( ( ACOS( ( SIN( @fromLatitude / 57.2958 ) * > > SIN( > @toLatitude / 57.2958 ) ) + > > > > (COS ( @fromLatitude / 57.2958 ) * COS( @toLatitude / 57.2958 ) * COS( > @toLongitude/57.2958 - @fromLongitude / 57.2958 ) ) ) ) * 6378.135, 3 ) ) > > > > [EMAIL PROTECTED]; > > > > > > > > > > > > > > On 6/26/07, Scott Thornton > <[EMAIL PROTECTED] > wrote: > > > > > > Would you mind posting the formula? also reformatting the code with > tab's? > > > > > > round( > > > ACOS( > > > ) > > > ,3) > > > > > > I have been playing around with it and got it to work but I am not sure > if it what was intended as I mucked around with the brackets. There seemed > to be spare brackets about. > > > > > > > > > >>> "Taco Fleur" < [EMAIL PROTECTED]> 26/06/2007 12:40 pm >>> > > > OK, I've narrowed it down to the following code and values. I also see > that > > > other people have had the same problem, no answers listed in the forums > > > though. > > > > > > The offending code is; > > > > > > > > > DECLARE @fromLatitude AS REAL > > > > > > , @fromLongitude AS REAL > > > > > > , @toLatitude AS REAL > > > > > > , @toLongitude AS REAL > > > > > > SET @fromLatitude = -31.111695 > > > > > > SET @fromLongitude = 117.792134 > > > > > > SET @toLatitude = -31.111695 > > > > > > SET @toLongitude = 117.792134 > > > > > > > > > > > > DECLARE @distance REAL > > > > > > SET @distance = ( ROUND( ( ACOS( ( SIN( @fromLatitude / 57.2958 ) * > > > SIN(@toLatitude > > > / 57.2958 ) ) + > > > > > > ( COS ( @fromLatitude / 57.2958 ) * COS( @toLatitude / 57.2958 ) * > > > COS(@toLongitude > > > /57.2958 - @fromLongitude / 57.2958 ) ) ) ) * 6378.135, 3 ) ) > > > > > > SELECT @distance; > > > > > > > > > > > > On 6/26/07, Scott Thornton < > [EMAIL PROTECTED]> wrote: > > > > > > > > > > > > could it be related to: > > > > > > > > > http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=208 > > > > > > > > but then you mentioned it runs ok on the database itself. > > > > > > > > >>> "Taco Fleur" < [EMAIL PROTECTED]> 26/06/2007 11:57 am >>> > > > > Hello all, > > > > > > > > I am getting the following error "A domain error occurred" > > > > [Macromedia][SQLServer JDBC Driver][SQLServer]A domain error occurred. > > > > > > > > The cfquery tag is calling a stored procedure, and when I call that > > > > procedure directly on the database with the same values there appears > to > > > > be > > > > no problem. > > > > > > > > So, I;m guessing it has something to do with the driver? Has anyone > seen > > > > this before? > > > > Any help or hints will be much appreciated. > > > > > > > > -- > > > > http://www.clickfind.com.au > > > > The new Australian search engine for businesses, products and services > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > *** { . } { . } **** > > > http://www.clickfind.com.au > > > The new Australian search engine for businesses, products and services > > > > > > > > > > > > > > > > > > > > > http://www.clickfind.com.au > > > The new Australian search engine for businesses, products and services > > > > > > > > -- > > *** { . } { . } **** > > http://www.clickfind.com.au > > The new Australian search engine for businesses, products and services > > > > > > > -- Peter Tilbrook ColdGen Internet Solutions President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA http://www.coldgen.com/ http://www.actcfug.com/ Tel: +61-2-6284-2727 Mob: +61-0432-897-437 Email: [EMAIL PROTECTED] MSN Messenger Live: Desktop General --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
