View previous topic :: View next topic |
Author |
Message |
MRG06 Basic Member
Joined: 08 Apr 2007
|
0. Posted: Wed Nov 05, 2008 12:23 pm Post subject: Machine location search errors. |
|
|
Is it me or is everyone else having the same problems searching for machine locations? Every time I put in a zip code or a city, I'll come to a page that looks like this. error in query: SELECT ML_Locations.locationID, ML_Locations.name, ML_Locations.city, shortName, miles, stateAbbr, modifyID, Location2.status as status FROM ML_Locations, ZipCodeDist left join ML_Machines on ML_Locations.locationID = ML_Machines.locationID left join versions on ML_Machines.versionID = versions.versionID left join ML_Modifications on ML_Modifications.locationID = ML_Locations.locationID left join ML_Locations as Location2 on Location2.locationID = ML_Modifications.modifyID left join ML_States on ML_States.stateID = ML_Locations.stateID WHERE ML_Locations.status='approved' and ML_Locations.zip5=zip2 and zip1='32569' and miles < 10 order by miles |
|
Back to top |
|
|
VxJasonxV Maniac Member
Joined: 08 Feb 2002 Location: Castle Rock, CO |
1. Posted: Sun Nov 09, 2008 9:40 am Post subject: |
|
|
It's not just you, but it's going to require a bit more involvement for me to figure out the root cause.
Just letting you know. _________________
|
|
Back to top |
|
|
VxJasonxV Maniac Member
Joined: 08 Feb 2002 Location: Castle Rock, CO |
2. Posted: Sun Nov 23, 2008 9:54 am Post subject: |
|
|
You may have already seen it, but: It's been fixed _________________
|
|
Back to top |
|
|
|