Re: Problem with result field list
Try using between:
SELECT gis_id, lat, long, z1,z2,z3 FROM gis WHERE (lat BETWEEN 40.4660506896973 AND 40.4675506896973) AND (long BETWEEN -3.65449994277954 AND -3.65299994277954) LIMIT 10000;
You might also want to try getting rid of the single quotes surrounding the numbers.
Edited 1 time(s). Last edit at 10/24/2007 02:55PM by Chris Schneider.
Subject
Views
Written By
Posted
3652
October 02, 2007 10:40AM
Re: Problem with result field list
2286
October 24, 2007 02:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.