| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
ihtralam
   |
Posted - 2010.10.01 23:44:00 -
[1]
I'm trying to find the closest solarSystemID owned by a given factionID.
I have a starting point of SELECT DISTINCT a.[solarSystemName], [ebs_DATADUMP].[dbo].[mapDenormalize].[factionName] from [ebs_DATADUMP].[dbo].[map] a, [ebs_DATADUMP].[dbo].[map] b,
[ebs_DATADUMP].[dbo].[map] c, [ebs_DATADUMP].[dbo].[map] d, [ebs_DATADUMP].[dbo].[map] e, [ebs_DATADUMP].[dbo].[mapDenormalize]
WHERE a.fromSolarSystemID = b.toSolarSystemID
AND b.fromSolarSystemID = c.toSolarSystemID
AND c.fromSolarSystemID = d.toSolarSystemID
AND d.fromSolarSystemID = e.toSolarSystemID
AND e.fromSolarSystemID = 30000142
AND a.toSolarSystemID <> 30000142
but for some reason the query parser insists no matter where I put [ebs_DATADUMP].[dbo].[mapDenormalize].[factionName] that the column doesn't exist. Did I spell something wrong? Am I missing some syntax? Help!
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.10.02 00:14:00 -
[2]
Edited by: Tonto Auri on 02/10/2010 00:15:28
First, make your code lines shorter, don't break forum layout.
Second, simplify your query for test, make sure you have right addressation in first place.
I'm almost sure that
SELECT DISTINCT a.[solarSystemName], [ebs_DATADUMP].[dbo].[mapDenormalize].[factionName]
is wrong (again, in first place). Can't tell for sure as I didn't worked with ODBC for about ten years.
--
Thanks CCP for cu |
ihtralam
|
Posted - 2010.10.02 01:24:00 -
[3]
You know why it doesn't work? Because I forgot to join the region of mapSolarSystems on mapRegions which actually has factionIDs that aren't null, then join from there on chrFactions to get usable a usable factionName.
I must have been braindead this morning. Disregard all of the first post.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.02 14:43:00 -
[4]
Although you found the error yourself, it would still be cool if you edit your initial posting so that it doesn't break the forum (word wrap the first two lines of your query).
TIA,
Hel
--
EVEWalletAware - an offline wallet manager |
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |