Web Development



XML Data capture for Infopath fields

By burnell3670 ·
I have a problem that i have been dealing with for several days.......

Created an ASP script file that takes a variable (user ID) and queries database. If the variable is not specified as a querystring variable (at the end of the URL) then it uses the person?s user id (their network login) that is requesting the URL. A record set is returned from the database as an XML file. This works. Technically, this is not a web service. Functionally, it behaves sort of like a web service. Anyway by simply putting it in the address bar, it works!!

OKay i created a secondary connection in the infopath form thinking i could capture those two data sets and bind them to two fields in my form. I thought using the "XML document" for receiving data, it would work....... and it does sort of. I did the binding for the fields.... it worked BUT regardless of whoever opens this published form up, it ALWAYS shows my info in these two fields..... i dont understand this....... SO i tried the web service.... but got an error because like i said this is not a web service........

my question is

1.) What "receiving " method do i use?

2.) How do I capture the two fields from the ASP script - XML and bind them two the fields in the form?. And it not be mine info all the time.

I figure on the OnLoad event but my code is not strong. the ASP URL is this: http://dascprd.intranet.dow.com/ebid/services/ebid_name_sup_service.asp

this script brings back the info i need in a XML file....... I just need to take that info out of the XML file (supervisorID, supervisorName):

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <userInfo>
<userName>Norris, Chris B</userName>
<supervisorName>Dolder, Sean C</supervisorName>

and bind it to the supervisor ID and Supervisor Name fields of the form......

Please help, been working on this for several days now.....

thank you


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums