Closed gouldingken closed 11 years ago
The tmpl function should support multiple values e.g.
UPDATE {table} SET {field}= {val} WHERE ({id}>=32 AND {id}<=42) OR {id} IN (26, 28, 66)
Currently only the first {id} is replaced.
This may not be the most efficient way, but you could rewrite:
s = s.replace('{'+p+'}', d[p]);
as
s = s.split('{'+p+'}').join(d[p]);
The tmpl function should support multiple values e.g.
UPDATE {table} SET {field}= {val} WHERE ({id}>=32 AND {id}<=42) OR {id} IN (26, 28, 66)
Currently only the first {id} is replaced.
This may not be the most efficient way, but you could rewrite:
s = s.replace('{'+p+'}', d[p]);
as
s = s.split('{'+p+'}').join(d[p]);