search for: metres_x

Displaying 1 result from an estimated 1 matches for "metres_x".

Did you mean: metres_y
Wrong id after join!
2006 Feb 28
1
Wrong id after join!
...pc on substring_index(e.postcode,'' '', 1) = pc.outer_part " ) Produces the folowing SQL ------------------------- SELECT * FROM entities as e inner join postcodes as pc on substring_index(e.postcode,'' '', 1) = pc.outer_part WHERE (categories_id = 4 and pc.metres_x >= 367400.0 and pc.metres_x <= 399400.0 and pc.metres_y >= 380600.0 and pc.metres_y <= 412600.0) -- Posted via http://www.ruby-forum.com/.