Domain error

[artists_envy]

I'm receiving a domain error while processing the following query. I am using
CFMX 6.1 and MS SQL 2005.

Any help is greatly appreciated. -Andy

<cfquery name="results" datasource="massageusa" username="massageusa"
password="ajm4283">
<cfloop from="1" to="#ListLen(zips[1])#" index="curZip">
SELECT ZipCode,
3963 * (ACOS((SIN(#ListGetAt(zips[2], curZip)#/57.29577951) *
SIN(latitude/57.29577951)) +
(COS(#ListGetAt(zips[2], curZip)#/57.29577951) * COS(latitude/57.29577951) *
COS(longitude/57.29577951 - #ListGetAt(zips[3], curZip)#/57.29577951)))) AS
distance
FROM location
WHERE (3963 * (ACOS((SIN(#ListGetAt(zips[2], curZip)#/57.29577951) *
SIN(latitude/57.29577951)) +
(COS(#ListGetAt(zips[2], curZip)#/57.29577951) * COS(latitude/57.29577951) *
COS(longitude/57.29577951 - #ListGetAt(zips[3], curZip)#/57.29577951))))) <=
#radius#
<cfif curZip NEQ ListLen(zips[1])>
UNION
</cfif>
</cfloop>
</cfquery>

[Ian Skinner]

I do not know what you mean by domain error, but you may want to be
careful in sending the username and password to a database that is
presumable accessable to the entire world on the internet.

Just a heads up that you may want to change them.


artists_envy wrote:

> I'm receiving a domain error while processing the following query. I am using
> CFMX 6.1 and MS SQL 2005.
>
> Any help is greatly appreciated. -Andy
>
> <cfquery name="results" datasource="massageusa" username="massageusa"
> password="ajm4283">
> <cfloop from="1" to="#ListLen(zips[1])#" index="curZip">
> SELECT ZipCode,
> 3963 * (ACOS((SIN(#ListGetAt(zips[2], curZip)#/57.29577951) *
> SIN(latitude/57.29577951)) +
> (COS(#ListGetAt(zips[2], curZip)#/57.29577951) * COS(latitude/57.29577951) *
> COS(longitude/57.29577951 - #ListGetAt(zips[3], curZip)#/57.29577951)))) AS
> distance
> FROM location
> WHERE (3963 * (ACOS((SIN(#ListGetAt(zips[2], curZip)#/57.29577951) *
> SIN(latitude/57.29577951)) +
> (COS(#ListGetAt(zips[2], curZip)#/57.29577951) * COS(latitude/57.29577951) *
> COS(longitude/57.29577951 - #ListGetAt(zips[3], curZip)#/57.29577951))))) <=
> #radius#
> <cfif curZip NEQ ListLen(zips[1])>
> UNION
> </cfif>
> </cfloop>
> </cfquery>
>