cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Gallardo" <agalla...@agsoftware.dnsalias.com>
Subject Re: mod-db - Updating multiple rows
Date Mon, 09 Jun 2003 10:08:38 GMT
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: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message