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
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
-
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
Please sign in to leave a comment.
Comments 1