RE: CFusion: SQL (BASE) table not found err

Mark et al.,

The actual error message read "base table" not "root table"; sorry.
Actually, I had verified that the table does exist via SQLServer Executive.
I tried your suggestion of submitting query referencing a non-existent
table, and got the same err msg (base table not found).  Even renamed the
table, to no avail.

Following is the query and error message. I'm stumped!

**************** QUERY ********************************
<cfquery datasource="art2000" name="title" maxrows="100">
SELECT tblArtist.*, tblTitle.*, Entity.e_lname
FROM Entity INNER JOIN (tblArtist INNER JOIN tblTitle ON tblArtist.A_CODE =
tblTitle.A_CODE) ON Entity.E_CODE = tblArtist.A_CODE
WHERE t_name LIKE '%#session.title#%'
ORDER BY Entity.e_lname
</cfquery>
************* END QUERY *******************************

*************** ERR MSG *******************************

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Entity'.

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (39:1) to (39:57).

Date/Time: 09/01/00 10:30:26
Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
Remote Address: 127.0.0.1
HTTP Referer:
http://localhost:8081/public/q_title1.cfm?CFID=41&CFTOKEN=11802850

**************** END ERR MSG **************************

See anything else?  SQL syntax? (Probably not cause it bombed on a
straightforward SELECT * FROM TABLENAME) Table owner reference??? (dbo???)

Help.......

:)
Steve Ball

> -----Original Message-----
> From: owner-hwg-languages(at)hwg.org [mailto:owner-hwg-languages(at)hwg.org]On
> Behalf Of Mark Stradling
> Sent: Thursday, August 31, 2000 1:11 AM
> To: hwg-languages(at)hwg.org
> Subject: RE: CFusion: SQL root table not found err
>
>
> This means the name of the table your query is using doesn't exist on the
> datasource you have specified.
>
> Use SQL Enterprise Manager to look at the table names in your new SQL
> database.  It's possible the import wizard decided to rename some of your
> tables for you.
>
> If you want to double check this is the cause of your error, create a
> temporary page which queries your SQL datasource and tries to
> select * from
> a table name which doesn't exist.
>
> <cfquery name="getResults" datasource="mySQLDatasource">
> SELECT *
> FROM MadeupTablename
> </cfquery>
>
> This should generate the same error you have.
>
> HTH,
>
> Mark Stradling
> Allaire Spectra Developer
> Blueberry.Net
> Creating Fruitful e-Business
>
> > -----Original Message-----
> > From: Steve Ball [mailto:sball99(at)mindspring.com]
> > Sent: 30 August 2000 20:05
> > To: hwg-languages(at)hwg.org
> > Subject: CFusion: SQL root table not found err
> >
> >
> > List,
> > I have a ColdFusion application on Access backend which runs
> > great, but
> > needs to be scaled up.  I installed SQLServer7 under
> > NT4&NT2000.  I had no
> > problem using a SQL "wizard" to import the Access tables.  I
> > had no problem
> > registering the database with CF Administrator.  HOWEVER,
> > when I run a query
> > the first hit to the CF Server returns "root table not
> > found".  I think it
> > has something to do with the OWNER attribute in SQLServer
> > (default:dbo) but
> > I don't know if/how to script for this in ColdFusion.  Any thoughts?
> > TIA
> > Steve Ball
> >
>

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA