Ok, I just changed a bit the code you gave me and it's working perfectly:
$counter = 1;
foreach ($feature->attributes as $key => $val) {
$val = ($val == '') ? 'NULL' :
sprintf("'%s'", Encoder::decode(Utils::addslashes($val),
'config'));
if (in_array($key, $editableAttributes)) {
$attributesFieldsSql .= "$key";
$attributesValuesSql .= "$val";
if ($counter < sizeof($feature->attributes)) {
$attributesFieldsSql .= ",";
$attributesValuesSql .= ",";
}
}
$counter ++;
}
Thanks!
Claire
> Message du 26/09/08 12:15
> De : "Oliver Christen"
> A : "Claire Chastagnol" , cartoweb-users@lists.maptools.org
> Copie à :
> Objet : Re: [Cartoweb-users] edit plugin
>
> try something like this: $counter = 0;
> foreach ($feature->attributes as $key => $val) {
> $val = ($val == '') ? 'NULL' :
> sprintf("'%s'", Encoder::decode(Utils::addslashes($val),
> 'config'));
> if (in_array($key, $editableAttributes)) {
> $attributesFieldsSql .= "$key";
> $attributesValuesSql .= "$val";
> }
> if ($counter < sizeof($feature->attributes)) {
> $attributesFieldsSql .= ",";
> $attributesValuesSql .= ",";
> }
> $counter ++;
> } ----- Original Message ----- From: Claire Chastagnol To:
> cartoweb-users@lists.maptools.org Sent: Friday, September 26, 2008
> 12:08 PM Subject: [Cartoweb-users] edit plugin
> Hi everybody,
>
> I'm trying to extend the edit plugin because I need to update some
> geographic data with atrributes which come from a different table.
>
>
>
> The sql query generated isn't right : I have some "," problems:
> I have this error message indeed:
>
>
Userinfo: INSERT INTO public.evenements_evolution (id_route, id_ev, id_etat,
localisation_pr, date, heure, description, )
> VALUES ('850', '2', '2', 'pr8 pr9', '1 octobre 08', '12h', 'chaussee
> glissante', ) [nativecode=ERREUR: erreur de syntaxe sur ou près de « ) »
> LINE 1: ..._etat, localisation_pr, date, heure, description, )VALUES ('...
> This is the code I put in my extension for updating:
>
> protected function updateFeature($feature) {
> $db = $this->getDb($this->layer);
>
> $editableAttributes =
> $this->getEditableAttributes($this->attributes);
>
> $this->editSchema = 'public';
> $this->editTable = $this->getMetadataValueString($this->layer,
> 'edit_table');
> $editTables = explode(',', $this->editTable);
>
>
> if (isset($feature->attributes) && $feature->attributes) {
> $attributesFieldsSql = $attributesValuesSql = '';
> foreach ($feature->attributes as $key => $val) {
> $val = ($val == '') ? 'NULL' :
> sprintf("'%s'",
> Encoder::decode(Utils::addslashes($val),
> 'config'));
> if (in_array($key, $editableAttributes)) {
> $attributesFieldsSql .= "$key, ";
> $attributesValuesSql .= "$val, ";
> }
> }
> if ($attributesValuesSql == '')
> $attributesValuesSql = NULL;
> } else {
> $attributesFieldsSql = '';
> $attributesValuesSql = NULL;
> }
> $sql = sprintf ('INSERT INTO %s.%s (%s)' .
> "VALUES (%s) ",
> $this->editSchema,
> $editTables[1],
> $attributesFieldsSql,
> $attributesValuesSql
> );
> $this->log->debug($sql);
> $queryId = $db->query($sql);
>
> Utils::checkDbError($queryId, 'Unable to insert feature in edit
> database');
> return $queryId;
>
> }
>
> How can I do? (I tried with the substr function but without success...)
>
> Thanks.
> Claire
>
>
>
> >
>
>
_______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users@lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users
>
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
