<div>Thanks Brent</div><div> </div><div>Actually the problem was in my layer.ini and .map file.</div><div> </div><div>Could you please guide me in making delete service too.</div><div> </div><div>What I did sofar:</div><div>
</div><div>Step 1)</div><div> </div><div> </div><div><service name="modify_point"><br> <url>php/editor.php</url><br> <step type='spatial' name='feature:wkb_geometry' line='false' polygon='false' point='true' default='point' edit-point='true'> </div>
<div> <input type="hidden" name="op" value="update"/><br> <input type="hidden" name="table" value="test_points"/><br> <input type="hidden" name="feature:feature_id"/><br>
<input type="user" name="feature:attribute1" title="attribute1:"/><br> <input type="user" name="feature:attribute2" title="attribute2:"/><br>
</step><br></service></div><div> </div><div> </div><div><service name="delete_point"><br> <url>php/editor.php</url><br> <step type='input'><br> <input type="hidden" name="op" value="delete"/><br>
<input type="hidden" name="table" value="test_points"/><br> <input type="hidden" name="feature:feature_id"/> </div><div> </step><br>
</service></div><div><br>Step 2) </div><div> </div><div> <tool name="delete_point" title="Delete Point" type="service" service="delete_point"/> (gives me message of "No Feature ID specified to delete.")</div>
<div> </div><div>
Step 3) identify.html</div><div> </div><div><tr bgcolor="#AA55AA"><br> <td>Feature:</td><td>[feature_id]</td><br></tr><br><tr> <br> <td>Attribute1:</td><td>[attribute1]</td><br>
</tr><br><tr><br><td><br> <a href="javascript:GeoMOOSE.startService('modify_point', {'feature:id' : '[feature_id]','feature:wkb_geometry' : '[wkt_geometry]', 'feature:attribute1' : '[attribute1]', 'feature:attribute2' : '[attribute2]'})">Edit</a><br>
</td><br><td><br> <a href="javascript:if(confirm('Are you sure you want to delete this?')) { GeoMOOSE.startService('delete_point', {'feature:id' : '[feature_id]'}); }">Delete</a><br>
</td><br></tr><br><br></div><div>Now what step I need to perform, e.g., my identify.html is not recognizing (i guess so) to start the service of modify_point or delete_point etc.</div><div> </div><div>Kindly check the URL and files path from here:</div>
<div> </div><div><a href="http://216.58.43.167/geomoose2/">http://216.58.43.167/<u></u>geomoose2/</a></div><div> </div><div><a href="http://216.58.43.167/geomoose2/geomoose.html" target="_blank">http://216.58.43.167/<u></u>geomoose2/geomoose.html</a><br>
</div><div> </div><div>Regards</div><div>Sana</div><div> </div><div> </div><div><br> </div><div class="gmail_quote">On Sun, Jan 29, 2012 at 2:37 PM, Brent Fraser <span dir="ltr"><<a href="mailto:bfraser@geoanalytic.com" target="_blank">bfraser@geoanalytic.com</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Since the error message says it can't find a column named "id" (and your table uses "feature_id" as the key column), I expect the problem is a configuration problem in your mapbook.xml file. Check your column names in your service definitions (modify, delete, and especially add) in your mapbook.xml and confirm it has<br>
<br>
<input type="hidden" name="feature:feature_id"/><br>
<br>
Best Regards,<br>
Brent Fraser<div><br>
<br>
<br>
On 1/29/2012 3:11 AM, sana butt wrote:<br>
</div><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div>
Hi Brent<br>
I have added polygon feature and its working, Now I have added point using the same criteria available at feature editor guide, but its not working.<br>
Could you please test the URL:<br>
<a href="http://216.58.43.167/geomoose2/geomoose.html" target="_blank">http://216.58.43.167/<u></u>geomoose2/geomoose.html</a><br>
and add point.<br>
What I have done so far:<br>
CREATE TABLE test_points<br>
(<br>
feature_id integer NOT NULL,<br>
attribute1 character varying(100),<br>
attribute2 character varying(100),<br>
wkb_geometry geometry,<br>
CONSTRAINT pk_test_points PRIMARY KEY (feature_id)<br>
)<br>
CREATE SEQUENCE test_points_seq;<br>
insert into geometry_columns values ('', 'public', 'test_points', 'wkb_geometry', 2, 24, 'GEOMETRY');<br>
and follow the instructions available in feature editor guide.<br>
I got this error in firefox.<br>
URL:<br>
</div><a href="http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269" target="_blank">http://216.58.43.167/cgi-bin/<u></u>mapserv.exe?map=%2Fms4w%<u></u>2Fapps%2Fgeomoose2%2Fmaps%2F%<u></u>2Fdevelopment%2Ftest_points%<u></u>2Ftest_points.map&layers=<u></u>points&mode=map&mapext=457196.<u></u>607656+4917749.476731+517604.<u></u>607656+4948205.476731&imgext=<u></u>457196.607656+4917749.476731+<u></u>517604.607656+4948205.476731&<u></u>map_size=2517+1269&imgx=1258.<u></u>5&imgy=634.5&imgxy=2517+1269</a> <<a href="http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269" target="_blank">http://216.58.43.167/cgi-bin/<u></u>mapserv.exe?map=%2Fms4w%<u></u>2Fapps%2Fgeomoose2%2Fmaps%2F%<u></u>2Fdevelopment%2Ftest_points%<u></u>2Ftest_points.map&layers=<u></u>points&mode=map&mapext=457196.<u></u>607656+4917749.476731+517604.<u></u>607656+4948205.476731&imgext=<u></u>457196.607656+4917749.476731+<u></u>517604.607656+4948205.476731&<u></u>map_size=2517+1269&imgx=1258.<u></u>5&imgy=634.5&imgxy=2517+1269</a>><div>
<br>
Error:<br>
msDrawMap(): Image handling error. Failed to draw layer named 'points'. prepare_database(): Query error. Error declaring cursor: ERROR: column "id" does not exist LINE 1: ...b_geometry)),'NDR'),<u></u>feature_id::text from (select id as feat... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(<u></u>force_2d(wkb_geometry)),'NDR')<u></u>,feature_id::text from (select id as feature_id, attribute1, attribute2, astext(wkb_geometry) as wkt_geometry, wkb_geometry from test_points) as mytable WHERE wkb_geometry && setSRID('BOX3D(457184.<u></u>796930448 4917749.476731,517616.<u></u>418381552 4948205.476731)'::BOX3D, 24 )<br>
I dont know, where I made mistake in creating table, etc.<br>
Could you please help me solving this issue<br>
Regards<br>
Sana<br>
</div></blockquote>
<br>
</blockquote></div><br>