|
Home > Archive > BizTalk Server Orchestration > April 2005 > Addl Info:Retrieve Distinguished Field value is empty
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Addl Info:Retrieve Distinguished Field value is empty
|
|
|
| Hi,
Sorry...I think I should add that the distinguished field I am trying to
read from is the result of an SQL query using the SQL Request/Response
mechanism. It DOES look to be a namespace issue, but I don't know how to
resolve because the SQLAdapter is putting extra namespace info in the result
set that isn't part of the generated schema for the message (i.e. namespace
doesn't exist during design time, if I change it to what the actual message
has then the distinguished field doesn't show up in the UI and I get compile
errors).
Why is something so simple so difficult? Please help me understand what I
am doing wrong!!! Thanks,
Mike
| |
|
| the namespace sometimes changes so the promote thing not working.
try using xpath. to find out the correct one u can try to find the correct
xpath syntax using a program called "visual xpath" which u can find for free
over the net.
"Mike" wrote:
> Hi,
>
> Sorry...I think I should add that the distinguished field I am trying to
> read from is the result of an SQL query using the SQL Request/Response
> mechanism. It DOES look to be a namespace issue, but I don't know how to
> resolve because the SQLAdapter is putting extra namespace info in the result
> set that isn't part of the generated schema for the message (i.e. namespace
> doesn't exist during design time, if I change it to what the actual message
> has then the distinguished field doesn't show up in the UI and I get compile
> errors).
>
> Why is something so simple so difficult? Please help me understand what I
> am doing wrong!!! Thanks,
>
> Mike
>
| |
|
| Amit,
Thank you for the info. This is the path I ultimately used (xpath). It is
unbelievable to me that I had to use a workaround to get the value from a
stored procedure call using the native functionality of BizTalk! On a
positive note, I am grateful that it is flexible enough to allow
"work-arounds" such as this.
Thanks for taking the time to write your response.
Michael
"Amit" wrote:
[vbcol=seagreen]
> the namespace sometimes changes so the promote thing not working.
> try using xpath. to find out the correct one u can try to find the correct
> xpath syntax using a program called "visual xpath" which u can find for free
> over the net.
>
> "Mike" wrote:
>
|
|
|
|
|