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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum