[Mapserver-users] Virtual Spatial Data - layer not visible

[Jenu Abraham]

hi,
Thanks a lot , i had totally messed up that latlong table...

but my problem still persists

i now have my latlong table as....

x                   |        y
-------------------------------
-87.9044722   |   41.9795833
-------------------------------------------
-97.52            |   35.46
------------------------------------------------

i can see the states layer but
i dont see any points on my map..from the truck layer-which is the virtual 
spatial layer
is something wrong in the projection? to tell the truth i am still stuggling 
with projections.....

when i tested with ogrinfo, "testing2.ovf" gave the expected output..

------------------------
mapfile
-----------

MAP
  NAME           e-test-rd-jbox-vsd_
  IMAGETYPE      GIF
  EXTENT          -2236857.50 -1744057.00  2786329.50 29069.36
  SIZE           800 600
  SHAPEPATH      "C:\cgi-bin\data\"
  FONTSET        "C:\cgi-bin\fonts\fonts.list"
  WEB
    TEMPLATE 'e-test-rd-jbox.html'
    IMAGEPATH 'C:\cgi-bin\tmp\'
    IMAGEURL  '/tmp/'
  END

  PROJECTION
    "init=epsg:2163"
   END


  LAYER # States polygon layer begins here
    NAME         states
    DATA         statesp020
    STATUS       DEFAULT
    TYPE         POLYGON
    PROJECTION
      "init=epsg:4326"
    END
    CLASS
        COLOR      240 240 100
    END
  END # States polygon layer ends here


LAYER # start of truck position from database

	NAME trucks
	TYPE POINT
	CONNECTIONTYPE OGR
	CONNECTION "testing2.ovf"
	DATA "mylayer"
	STATUS DEFAULT

	PROJECTION
      	  "proj=latlong"
	END
	CLASS
		SYMBOL 1
		SIZE 6
     		COLOR      255 0 0
	END
END # end of connection layer
# End of LAYER DEFINITIONS
END # end of map file
--------------------------
testing2.ovf
-----------------------

<OGRVRTDataSource>
<OGRVRTLayer name="mylayer">
<SrcDataSource>ODBC:user/pwd at localserver</SrcDataSource>
<SrcLayer>latlong</SrcLayer>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
----------------------------------------------

jenu

_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page – FREE 
download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/