Hi,
I am using wm 6.1 i am picking the data from oracle using JDBC adapter service i have 3 records in the database(1,2,3) when i use the record id as 1 it gives the results 2,3 so on and when i give record id as 4 it shows the empty tag in results as i dunot want to see in the results tab as i dunot have any record in datbase
here are the steps i am using
sequence(On Failure)
map
inbound:selectservice
LoopOver/select/id
map
Dan,
This is the default behaviour of the JDBC Adapter,if no records found upon the query then output shows empty results recordlist in the pipeline which your loop will not work in this case.
Please elaborate more if i misunderstood your requirement correctly.
HTH,
RMG
my question is how to avoid the empty tag /structure in the results
do i need to drop that in pipline to avoid the structure when there is no record in the data base,
Thx
DANDI
When no records found Empty tag results structure is the default behaviour it will show up in the pipeline,if you dont want to see try to drop it.
HTH,
RMG
Okay if i drop that doc structure in the pipline
If once again i give the id =1 will the results are avaliable or not is my doubt,since i am droping the structure can i still see the result in the result tab,
Thx
Dandi
This is my output(this is part of my output XML)
when i give a valid id=xxx(which is existing in database)
<listoffvcmembership_eventweek>
<fvcmembership_eventweek>
<eventname>test</eventname>
<eventweekcost>56</eventweekcost>
<eventweeknumber></eventweeknumber>
<type>test</type>
</fvcmembership_eventweek>
This is my output(this is part of my output XML)
when i give a valid id=xxx(which is not existing in database)
<listoffvcmembership_eventweek>
<fvcmembership_eventweek>
</fvcmembership_eventweek>
<listoffvcmembership_eventweek>
i want to avoid this whole tag when i give any non existing id
Thx in advance
Dandi
is there no reason why you can not add simple flow logic to drop the empty tag i.e. use branch “set evaluate to true” and then sequence on a null result?
T
Thnaks topstar /rmg i tried top star logic its working,
Thnx
Dandi
no problem happy to help