multiple update of selected records

[AnFrusch@pepp]

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!

[Martin Brändle]

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

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

[AnFrusch@pepp]

:blush2: Thank you Martin,

I will try this solution as soon as possible!

Thank you!

[AnFrusch@pepp]

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, 2006 by Guest

[Martin Brändle]

Not sure. Could it be that the & in

makes problems?

You may try with

[AnFrusch@pepp]

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)..

[AnFrusch@pepp]

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! :)