InfoPath Dev

Hey all,

Have an interesting issue. This is what I have, I have some stored procs on a SQL Server DB that use FOR XML statements. A web service wraps it and InfoPath calls the webservice. I am starting to test with some historical data and my InfoPath form is bombing out. I have narrowed down to this. Here is an example of what is being returned:

<remarks>
<remark>That blah blah & blah blah</remark>
</remarks>

If I run the web service outside of InfoPath and I look at the source I see the following:

<remarks>
<remark>That blah blah & amp ; blah blah</remark>
</remarks>

Note, I put the spaces are in there because if I didn't an "&" would get displayed <G>

Then lets say in script I do a selectNodes(...)(...).text and conact it with something else and set it into the UI. Well I get a generic exception saying "Invalid procedure call or arguement".

Anyways. I have narrowed it down to me removing the "&" in the datbase and then everything works. Anyone have any ideas why this is happening???

Well...I just found the solution <G>

I had to do something like the following to fix the issue:
Replace(sRemark, "&", "& amp ;")

Check out this thread of a similiar problem and an almost identical solutionhttp://infopathdev.com/forums/topic.asp?TOPIC_ID=1325



---------------
Matt Faus
InfoPath Dev Texas