 Forum main
page
Most
active member
Login page
Register
Log out
Search page
Information Online
View our event calendar
Add general event such as an upcoming
software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the
most active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
Response from Oracle - 9 January 2007
|
|
|
shamir.ali
Posts: 17
Score: 0
Joined: 28 December 2006
Status: offline
|
Hello,
I have got a response from Request-Response communication port by requesting a select query.
Now a few of the fields that i have promoted in that response schema, when theres no records in the database for that specific select clause that i requested for, it gives an error, Infact it stops in the middle of the orchestration.
Text = SqlResponseMsgService(PropertySchema.ABC)
How can i resolve this issue.
|
|
|
|
|
RE: Response from Oracle - 10 January 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Another alternative would be to use the XPath function and perform a count() in the XPath Query, here you can simply look for the parent node of the field.
If the value returned is 0, then you know the fields don;t exist, otherwise it does exist and you can access the values.
Thisk this would be a pretty elegant solution.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML