# Update with DBOutputTable

**URL:** <https://forum.cloverdx.com/t/update-with-dboutputtable/249>\
**Category:** CloverDX Platform\
**Created:** [November 28, 2007, 12:00am UTC](https://forum.cloverdx.com/t/update-with-dboutputtable/249 "2007-11-28T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![alci](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@alci](https://forum.cloverdx.com/u/alci)\
**Post date:** [November 28, 2007, 12:00am UTC](https://forum.cloverdx.com/t/update-with-dboutputtable/249/1 "2007-11-28T00:00:00Z")

</div>

Hi,

I just found that updating with DBOutputTable takes :  
‘update table set field = ? where otherfield = ?’  
in sqlQuery and  
‘fieldmeta1;fieldmeta2’  
in cloverFieldMap.

So far so good. But the doc for the component says :

update mytable set f1 = $field1,…,fn=$fieldn  
- where f1,…,fn are database fields and field1,…,fieldn are input record fields

I couldn’t get this syntax to work.  
SO, am I missong something, or should the doc be corrected ?

Franck

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [November 29, 2007, 8:40am UTC](https://forum.cloverdx.com/t/update-with-dboutputtable/249/2 "2007-11-29T08:40:07Z")

</div>

Hello,  
this is new syntax, which will be available in the next release. At time being it is available in SVN only. But the syntax with ? works properly 🙂 .

Agata