I am trying to debug/get working an example app that covers cflogin and
makes extensive use of CFCs.
I keep seeing an error in the application log that looks like this:
Error Executing Database Query.[MERANT][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot find the input table or query 'state'. Make sure it exists and
that its name is spelled correctly. The specific sequence of files included
or processed is:
C:\CFusionMX\wwwroot\jobmachine\subscription\member\join.cfm
I have located a cfc that pulls in the list of states used in the join.cfm
page to register members.
The query looks like this:
Select
ID,
NAME
from state
order by NAME
As far as I can tell, neither changing the query (using MS Access query
builder) nor the DSN (it appears to be configured in the admin) does
anything to help.
I installed updater 2 and am working off a Win2K machine with a stand alone
development server (not using IIS). I have not been using CFCs so some of
this is new to me, but the app should have been working, I downloaded it
from http://tutorial67.easycfm.com/
Andrew Middleton
Software Applications Developer
Macromedia ColdFusion Certified Developer
AT&T Government Solutions
703 506-5266
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
