<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
The $ID gets replaced by PHP, but FDO SQL requires that strings are
quoted.<br>
Change the line to:<br>
<code>$filter = "KEY = '$ID'";<br>
</code><br>
It is a bit annoying because you have to get the column type before you
can do the query.<br>
<pre class="moz-signature" cols="72">Regards, Kenneth, GEOGRAF A/S
</pre>
<br>
<br>
J Manafi skrev:
<blockquote cite="mid:16492944.post@talk.nabble.com" type="cite">Does
anyone know...with an MgDeleteFeatures(or perhaps MgUpdateFeatures)
command, does the filter string have to be of a certain type? For
instance, we have features stored with a unique KEY value. It used to
be of type 'Int32', and it seemed that DeleteFeatures was working back
then. But then I changed the KEY value to type 'String' to make it more
dynamic, and that seems to be when this breakdown started happening. <br>
<br>
Our filter string looks like this: <code>$filter = "KEY = $ID";</code><br>
<br>
Should the fact that $ID is a string matter at all?
<blockquote class="quote light-black dark-border-color">
<div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">J Manafi wrote:</div>
<div class="quote-message">
I have not received any error messages. All of our php script files
execute fine and return all the expected values through FireBug as if
they are executing correctly. I am also not seeing your issue of not
being able to insert anymore, because I have now tried that, where I
have an UpdateFeatures followed by an InsertFeatures, and all of the
features are getting inserted every time but not updated. I have taken
the advice of the other threads and tried closing any and all
featureReaders I could find, but that has had no effect.<br>
Just for reference, I am using MG 1.2 with bundled php environment.<br>
<br>
Does anyone have any more suggestions?<br>
<br>
Thanks in advance for any help you give.
<blockquote class="quote light-black dark-border-color">
<div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">Ismael Cams
wrote:</div>
<div class="quote-message">
Hello,
I started a thread on the forum yesterday similar to what you are
describing. Did you get any error messages (I get an
MgResourceBusyException) ? After I try to delete or update a feature I
also not succeed anymore to insert features. Only after a restart of
mgserver I can insert features again.
My code was working fine with MGOS 1.2.
<blockquote class="quote light-black dark-border-color">
<div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">J Manafi
wrote:</div>
<div class="quote-message">
I am having a very similar problem. We are digitizing layers and
storing temporary feature sources in the session repository, and I,
too, cannot delete or update our temp. layers, but I can insert new
features. I checked the readonly flag, but it was already set to FALSE,
and my attempts at updating features are very similar programatically
to the posts I have already come across. We are able to do a mass
deletion, however, and delete all temporary layers from the map, but I
have been unsuccessful in trying to delete a singular feature from
specific layers. Has anyone been able to make any progress on this
topic?<br>
<blockquote class="quote light-black dark-border-color">
<div class="quote light-border-color">
<div class="quote-author" style="font-weight: bold;">mitcha
wrote:</div>
<div class="quote-message">
hello everybody,
i need help!!! i try tu update and delete a feature source (sdf file),
but it doesn't work! instead inserting new data into feature source
work very well! i searched for solutions in this forum and i found some
similar problems.
So I first tried to set the readonly flag of the schema to false with
the mapagent. now the xml presentation looks like this:
<FeatureSource
xsi:nonamespaceschemalocation="FeatureSource-1.0.0.xsd"><Provider>OSGeo.SDF</Provider>
<Parameter><Name>File</Name>
<Value>%MG_DATA_FILE_PATH%userPoints2.sdf</Value>
</Parameter><Parameter>
<Name>ReadOnly</Name>
<Value>FALSE</Value>
</Parameter></FeatureSource>
But it doesn't work!!!
furthermore i tried to set the identity property to readonly="false"
with the help of Fdo2Fdo. But it doesn't work, too. i always get an
error message. Could this be my fault? can i change this value of the
identity property?
. . .
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</blockquote>
<br>
<hr align="left" width="300">View this message in context: <a
moz-do-not-send="true"
href="http://www.nabble.com/can%27t-update-and-delete-from-feature-source-but-insert-works-tp12233926s16610p16492944.html">Re:
can't update and delete from feature source but insert works</a><br>
Sent from the <a moz-do-not-send="true"
href="http://www.nabble.com/MapGuide-Users-f14845.html">MapGuide Users
mailing list archive</a> at Nabble.com.<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
</body>
</html>