diff options
Diffstat (limited to 'docs/04_examples.mkd')
| -rw-r--r-- | docs/04_examples.mkd | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/docs/04_examples.mkd b/docs/04_examples.mkd index 1f605e7..822bea5 100644 --- a/docs/04_examples.mkd +++ b/docs/04_examples.mkd @@ -55,6 +55,11 @@ db.from(p).set(p.productName).to("updated") .increment(p.unitPrice).by(3.14)
.increment(p.unitsInStock).by(2)
.where(p.productId).is(1).update();
+
+// reusable, parameterized update query
+String q = db.from(p).set(p.productName).toParameter().where(p.productId).is(1).toSQL();
+db.executeUpdate(q, "Lettuce");
+
%ENDCODE%
## Merge Statements
|