| Author |
Message
|
| Tony.Cui |
 Posted: Mon Aug 21, 2006 1:52 am Post subject: How to set condition update statement in DataUpdate node |
 |
|
Newbie
Joined: 21 Aug 2006
Posts: 2
|
I want to update database record according to messages in MQ Input. I want to update record whose primary key value is equal to message's. But I found no place to claim this statement. What should I do? Thanks very much.
Tony |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Aug 21, 2006 1:59 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Read the manual? 
What do you mean by "claim the statement"? Are you trying to use one of the database nodes, a Compute node with a data source or a custom Java node? What have you tried and what happened (error messages etc)?
Also what version of the broker are you using, on what platform and with what database?
Help us to help you 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| nathanw |
| Posted: Mon Aug 21, 2006 1:59 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
As above
BUT
If you only want to insert values based on teh content of the message itself then I would suggest a Compute Node rather than a Data ****** Node |
|
| Back to top |
|
|
| Tony.Cui |
| Posted: Mon Aug 21, 2006 5:21 pm Post subject: |
|
|
Newbie
Joined: 21 Aug 2006
Posts: 2
|
| I mapped a xml schema to a table of db using DataUpdate node. I want to update record according an element of this schema which is mapped to primary key of database. But if I simply mapped xml elements to database, it will update one record if there is only one record in db. If there are more than one record, there are some errors. So I want to set statement to tell it update record according primary key. Where to set this statement? Thanks. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Aug 22, 2006 12:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Follow the suggestion of nathanw and use a Compute node.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
