Hello all!

My question is:

is it possible with just 1 query update a recordset of n records?

I explain better:

I have an e-commerce application, I would like to turn a flag from no to yes when the order is confirmed. If i have a recordset of 10 records it is not simple to change my flag 10 times with an external http call (calling an xml document in a variable for example).

Something like an UPDATE SQL statement..

I hope my question is clear.. and I hope there will be an answer too (please.. don't tell me it is possible only via script!).

Thank you!

Yes, it is possible. See my multiple records example:

http://www.fmforums.com/forum/showtopic.php?tid/169687

:blush2: Thank you Martin,

I will try this solution as soon as possible!

Thank you!

It seems doesn't work.. error #101.

I update an xslt file because this forum doesn't let me to post code (i think that [ code ] tag has some problem or bug).

Could you help to understand better what to do?

thank you!

step1.1.txt

Edited February 2, 200619 yr by Guest

Not sure. Could it be that the & in

makes problems?

You may try with

Hello,

I tried with disable-output-escaping attribute but it doesn't works (in fact I use a valid entity instead of simple amperstand: & )

I really start thinking that this is a new kind of bug of FM 8 (this example is in the CWP guide, so, as it is really really simple, I think the new web engine has some problem)..

Ok Martin.. i finally discovered what doesn't work..

basically you don't have to use the 'position()' function, but the @record-id of the record in the related set..

like this

concat('A::FieldName.', @record-id '=value&-edit').

bye! :)