> grass.run_command("db.execute", sql = "UPDATE %s SET %s='*'", WHERE "%s <
2" AND "%s > 3" % (A, B, C, C))
to answer my own question ;-), there WHERE clause is part of the sql command
... bingo.
grass.run_command("db.execute", sql = "UPDATE %s SET %s='*' WHERE %s < 2
AND %s > 3 % (A, B, C, C))
works fine, sorry for the noise.
-----
best regards
Helmut
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/how-to-use-the-WHERE-AND-in-a-python-script-using-variables-tp5139315p5139320.html
Sent from the Grass - Dev mailing list archive at Nabble.com.
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
