<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<font size="+1"><tt>Using qgis 1.8 on Fedora 18.<br>
<br>
<font size="+1">I have a spatialite db with pointz values in a
table. I can display the table in qgis<font size="+1">
without problems. If I define a query I get results in the
<font size="+1">Result view but</font> if I try to <font
size="+1">Load the query to qgis t<font size="+1">o</font></font>
visualize<font size="+1"> it</font> nothing happens. No
error message no views?<font size="+1"> Just for grins I
installed Qspatialite and tried the same thing. Still no
results but at least there was an error message :<)
The error is about aliasing the geometry field correctly
which didn't help but at least there was some feedback.
Then I noticed that in QSpatialite in the Result window I
could right click on a result and either save to text or
send to qgis. When I tried to send it to qgis I got the
error incorrect Geometry POINTZ! <font size="+1">So I
added casttoxy to my query and it works! :<)<br>
<br>
<font size="+1">I<font size="+1"> tried a bunch of
google queries but never got anything on this so is
this fixed in the latest or should a bug be
submitted?<br>
<br>
<font size="+1">Thanks.</font></font></font></font>
</font></font></font><br>
</tt></font>
</body>
</html>