Actually, I went back and looked at my code.
The code starts off as
<sql_salesorder>
<OUTBOUND_SALES_ORDER>
<PRFX></PRFX>
<PRFX></PRFX>
</OUTBOUND_SALES_ORDER>
</sql_salesorder>
My envelope processing leaves me with the message above. Which is a problem for me…. But appears to be more SQL related than Envelope processing… Anybody have an idea on how I can code an explicit XML query so that I'd get
<sql_salesorder>
<OUTBOUND_SALES_ORDER>
<PRFX>
</OUTBOUND_SALES_ORDER>
<OUTBOUND_SALES_ORDER>
<PRFX>
</OUTBOUND_SALES_ORDER>
</sql_salesorder>
Instead of the above where both of the PRFX's are in the same <OUTBOUND_SALES_ORDER> tags. I tried using a cursor to select one at a time, but it doesn't appear to be working.