Web Services

Re: populate text box from webservice

heath3106 — Wed, 12 Sep 2007 12:08:48 GMT

Clay,

Unfortunately I don't have admin rights for my pc at work. We can't download software that is not supported by our IT department. Any suggestions that would help without downloading the suite?

Re: populate text box from webservice

Clay Fox — Tue, 11 Sep 2007 17:09:14 GMT

Hey Heath,

I have done a similar project in HR.

I would strongly recommend you check out the Database Accelerator Web Suite. Qdabra Database Accelerator Suite Version 2.1.2808 - Developer

This gives you everything you need to identify the user and then more importantly secure it per user or to say a manager's direct reports. It is a whole toolkit of web services to interact with your databases.

If you need any advice or would like a demo of a similar project just email me by clicking on my name in the sidebar.

populate text box from webservice

heath3106 — Tue, 11 Sep 2007 13:42:40 GMT

I have a form that I am building based on an Access database. I am an InfoPath newbie and just trying to learn jscript. I want to receive data from our HR systems to prefill specific fields when the user opens the form. I've been able to get the LAN ID field to populate on the form but can't get the other data elements that are part of my secondary data connection (web service) to show up on the form .Below is the code I'm using. Any help on how to add the text box controls and get them to pull the data correctly would be appreciated.

function XDocument::OnLoad(eventObj)

{

XDocument.QueryAdapter.Timeout=60;

var userIDField=XDocument.DOM.selectSingleNode("dfs:myFields/my:LANUserID");

var userID=GetUserID();

if (userIDField.text == "") {userIDField.text=userID;}

}

//Also need for web service//

function GetUserID()

{

var objNetwork = new ActiveXObject("Wscript.network");

var uid = objNetwork.UserName;

return uid;

}