[GRASSLIST:8337] RE: db.execute syntax

[Glynn Clements]

Patton, Eric wrote:

> echo 'UPDATE Opil184a_ship_nav_med_smth SET MOD_60 = 1 WHERE CAT % 60 = 0' | db.execute
                                                                        ^

Here you've made the opposite mistake, using '=' for an equality check
when it should be '=='.

What does the following do:

echo 'UPDATE Opil184a_ship_nav_med_smth SET MOD_60 = 1 WHERE CAT % 60 == 0' | db.execute

?

-- 
Glynn Clements <glynn at gclements.plus.com>