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

[ Post a follow-up to this message ]

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 resu
lt
> set that isn't part of the generated schema for the message (i.e. namespac
e
> doesn't exist during design time, if I change it to what the actual messag
e
> has then the distinguished field doesn't show up in the UI and I get compi
le
> errors).
>
> Why is something so simple so difficult?  Please help me understand what I
> am doing wrong!!!  Thanks,
>
> Mike
>

[ Post a follow-up to this message ]

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 fr
ee
> over the net.
>
> "Mike" wrote:
> 

[ Post a follow-up to this message ]