Hi Amelie: Nice example!
This way we better explain things. The words sometimes are not too clear. Here right now is 4:00 a.m. At 9:00 a.m. comes other people to the office. We had a similar problem, but to be honest, I dont resolved it. The guru is my coworker Carlos Chavez. When he comes I will ask him about this stuff. And I promise to post to the list what he told. Of course he is on the list too, but never sent a mail. I think he found another solution using ESQL on XSP. Our problem was more related to insertion of files than to the update. Anyway when he comes I will ask him about this stuff. Best Regards, Antonio Gallardo. Amelie Cordier dijo: > Hi again > >> Christian Haul dijo: >>> One thing is impossible, though: update may not affect key columns. >>> This >>> has been requested by Antonio but he didn't come up with a patch so >>> far >>> ;-) > > Yes, I read that on the mailing list archive last week :) > > >> >> Hi! >> >> I dont made the patch since it is posible to create and alias of the >> table and change the key values. I know this is a hack, but it works. >> :) > > I've tried all the solutions you suggested to me but it doesn't work and > I can't find anything in the log files :( > > I may have badly explain my problem...because I don't want to update a > key field. As my english is poor, I think that an example is better than > a long explanation. > > In my table I've the following records : > idA idB idC idD MyString > ------------------------ > 1 3 5 6 > 1 3 5 7 > 1 5 5 9 > > And after the update, I want something like that : > > idA idB idC idD MyString > ------------------------ > 1 3 5 6 hello > 1 3 5 7 world > 1 5 5 9 ! > > The four numbers of each rows are the key of the field and they are > never modified during an update. Furthermore, during one update, only > the idD key part varies and, of course, the attribute "MyString"... > > > Here is a sample of code that I've tried. I've put idD either as a key > or as a value but with no results. > > > <table name="mytable"> > <keys> > <key name="idA" type="int"> > <mode name="request-param" type="request"/> > </key> > <key name="idB" type="int"> > <mode name="request-param" type="request"/> > </key> > <key name="idC" type="int"> > <mode name="request-param" type="request"/> > </key> > <key name="idD" type="int" set="master"> > <mode name="request-param" type="request"/> > </key> > </keys> > <values> > <value name="MyString" type="string" set="slave"/> > </values> > </table> > > Once again, I'm lost > Thanks in advance. > > > > --------------------------------------------------------------------- To > unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]