On 8/21/2011 1:59 PM, sushma wrote:
Hi guys, Below is my query result after calling the function written in pl/pgsql language. I wanted to display this result as a layer on the map using openlayer. As i am very new to json can u guys plz suggest me i could i format this in jsontestdb=# select road(1375,59); road ------------------------------- (12348,8059,249.737504252945) (12654,8286,219.425248073402) (12992,8613,123.671322795878) (13192,8699,55.2201869018148) (13433,8734,106.426985819356) (433,-1,0) (6 rows)
You need to provide more information when you post. Your questions tend to be vary vague, you do not provide any details of what your data tables look like, what have you tried already?
Your function outputs three columns, you do not tell us: what the columns are? What do expect to see on your map if you had it working? what data tables are you working with? -Steve _______________________________________________ Users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/openlayers-users
