summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFrédéric Péters <fpeters@entrouvert.com>2011-11-30 21:37:57 (GMT)
committerFrédéric Péters <fpeters@entrouvert.com>2011-11-30 21:37:57 (GMT)
commitc5ba6c48e6605b28fa9911fc1b02d7559083e142 (patch)
treec411006d0b2fcb5a9c3930a4451e57ff8186555d
parent1c3baa46c90841487eb437c156f92f738c9c1fe9 (diff)
downloadtabellio.pcfdb-c5ba6c48e6605b28fa9911fc1b02d7559083e142.zip
tabellio.pcfdb-c5ba6c48e6605b28fa9911fc1b02d7559083e142.tar.gz
tabellio.pcfdb-c5ba6c48e6605b28fa9911fc1b02d7559083e142.tar.bz2
fix sql select for persons
-rw-r--r--tabellio/pcfdb/sync.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/tabellio/pcfdb/sync.py b/tabellio/pcfdb/sync.py
index fbf2ccc..4307c73 100644
--- a/tabellio/pcfdb/sync.py
+++ b/tabellio/pcfdb/sync.py
@@ -643,8 +643,8 @@ class SyncFromPcfDbView(BrowserView):
where_ts = cursor.mogrify('AND t_pers.ts > %s', (timestamp,))
cursor.execute('''SELECT t_pers.id, t_pers.nom, prenom, sexe, datenaiss
FROM t_pers
- WHERE t_pers.st = 'S_CREATED' OR
- t_pers.st = 'S_DEAD'
+ WHERE (t_pers.st = 'S_CREATED' OR
+ t_pers.st = 'S_DEAD')
%s''' % where_ts)
count = 0