[#FC-427] Table names in query

FarCry Core Framework

Table names in query

Created: 05/Dec/05 10:35 PM Updated: 15/Feb/06 02:03 AM

Component/s:

Core Types

Affects Version/s:

FarCry 3.0

Fix Version/s:

3.0.1

Time Tracking:

Original Estimate:

5 minutes

Remaining Estimate:

5 minutes

Time Spent:

Not Specified

Environment:

Debian Linux, Mysql 4.1, Apache2

Description

« Hide

"General error: Unknown table 'dmCSS' in field list"

SELECT dmCSS.objectid, dmCSS.filename, dmCSS.mediaType, dmCSS.bThisNodeOnly, dmnav.objectid as callerObjectID FROM dmCSS dmCss, dmNavigation_aObjectIDs dmnav WHERE dmCSS.objectid = dmnav.data AND dmnav.objectid = 'FEA9D190-CD88-3344-DD1EE739AC69C980' AND dmCSS.label != '(incomplete)' ORDER BY dmnav.seq

rename "FROM dmCSS dmCss" to "FROM dmCSS dmCSS" and it will work!

/ danieln

All

Comments

Work Log

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Geoff Bowers - 19/Dec/05 12:39 PM

Bah.. the alias look like crack to begin with. This definitely needs to be fixed for the next maintenance release.

[ Permlink | « Hide ]

Tim Lucas - 15/Feb/06 01:55 AM

Is the alias even needed?