Skip to main content
M
MidOhioIT
Participating Frequently
April 6, 2008
Answered

Cold Fusion Error

  • April 6, 2008
  • 2 replies
  • 1032 views
First of all I am not new at programming and db connections but I am really new at coldfusion...

It seems that I have having problems connection to a database that did not have any problems in the past. I am involved in a new project so I dont know a lot of history about this system, still learning it.


When trying to run the query:
<cfquery name="qGetLL" datasource=#application.dsn#>
select Latitude, Longitude, rLatitude, rLongitude from zip
where Zip = <cfqueryparam value="#zip#" cfsqltype="CF_SQL_CHAR">
</cfquery>
I get the following error:
General error: Table 'zipcodes.zip' doesn't exists.

The thing is, the db I think it is connecting to does exists. How do I know for sure what db it is hitting ?

Thanks for any help in advanced
Text General error: Table 'zipcodes.zip' doesn't exists.
This topic has been closed for replies.
Correct answer paross1
I have changed the database that I know connects. I am now getting the following error:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'SQRT' in expression.
The error occurred on line 94.
SQRT() is not an Access function. Try SQR()

Sqr Function

Returns a Double specifying the square root of a number.

Syntax Sqr(number)

The required number argument is a Double or any valid numeric expression greater than or equal to zero.


Phil

2 replies

M
MidOhioITAuthor
Participating Frequently
April 6, 2008
Phil,

I am not sure, I am still waiting on the username and password from our client so that I can access that area. I was not sure how that was even setup so my first post indicated that I needed someeone to tell me where that connection was made. thanks for your help
P
paross1
Participating Frequently
April 6, 2008
Looks like your connection is probably fine. What this error is telling you is that you are attempting to select from a table named zip in a schema named zipcodes where that table name does not exist. Does the database associated with the DSN named in #application.dsn# actually have a table named zip?

Phil
M
MidOhioITAuthor
Participating Frequently
April 6, 2008
The table "zip" does exists, for at least the database that I am looking at. That is why I am not sure if the db I am looking at is the actual one it is connecting to. How do I verify ?
P
paross1
Participating Frequently
April 6, 2008
What value is application.dsn set to in application.cfm, and what DSN does that correspond to under Data Sources in the ColdFusion administrator?

Phil
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices