I am trying to run a query in QGIS. The query below works in QGIS 1.7.4
but I cannot get it to open in 1.9 (Windows 7).
SELECT "units"."gid", "units"."name", "pipe"."section",
"units"."the_geom"
FROM "data"."units", "data"." pipe"
WHERE " pipe"."section" = 'W' and ST_DWithin("pipe"."the_geom",
"units"."the_geom", 500);
Does anyone know what I am doing wrong?
James Stott BSc (Hons) MSc | Senior Professional
Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN
T: 01225 445548 | M: -
http://www.npaconsult.co.uk/
http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp
http://www.npaconsult.co.uk/terms.asp
This Electronic Transmission is intended only for the attention of the
addressee. It may contain privileged and confidential information. If you are
not the person for whom it is intended, you must not copy, distribute or take
any action in reliance on it. If you have received this electronic transmission
in error please notify us immediately by telephone, delete the transmission and
destroy any hard copies.
Nicholas Pearson Associates has used all reasonable efforts to ensure that this
message and any attachments are free from viruses.
Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0)
01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
