Hello CF-Linux,
I'm moving my first CF app from my Windows desktop, where it
works, to the Linux server, where it doesn't. The server has CF
4.5 installed and uses Interbase as the database. The latest
error is that it can't find the table. I've tried capitalizing
the table name, capping the first letter, all lower case, reFTPing
the db, but nothing is working.
the message...
-------------
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)
[Easysoft][Interbase]Dynamic SQL Error, SQL error code = -204,
Table unknown, RELEASES
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to
(2:45).
Date/Time: Fri Jun 1 17:46:25 2001
Browser: Mozilla/4.73 [en] (Win98; U)
Remote Address: 12.126.76.50
HTTP Referer: http://www2.eli.org/pressadmin/yearlist.cfm
Query String: releaseyear=2001
------------------------
My query....
--------------------
<cfquery name="getmonths" datasource="press">
select distinct releasemonth
from releases
where releaseyear=#url.releaseyear#
</cfquery>
<cfset monthlist=ValueList(getmonths.releasemonth)>
<cfquery name="releaselist" datasource="press">
select title, releasedate, releaseid, releasemonth
from releases
where releaseyear=#url.releaseyear#
order by releasedate
</cfquery>
------------------
Also, is there a web site or an article, _anything_ that can tell
me what things I need to change in my code when moving from
Windows to Linux? I wasn't expecting it to be this frustrating and
I don't want to drive everyone nuts everytime I have a problem.
Wearily yours,
Jennifer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
