InfoPath Dev

That helped alot thanks, I used the OnAfterChange.. my problem now is that the variable used in the first list box isnt being written to a node (its populated by a secondary data source) before the script is run.. i think. This means that the variable I am putting into the query, that is in a field in my form, is empty and thus returning sql ...

I need script to execute once a listbox entry has been selected, but you cannot set script execution in a rule. I have worked out how to do a conditional sql query using the default data connections string, that all works fine. The data connection is used to populate a list box, in which the contents will populate furthur listboxes. I can set a ...

Me replying to my own post again. It seems somethings wrong with the database end of this. The table 'ad_details' is actually a view of our Active Directory user information. Apparently not all of the rows/users are populating and so some queries dont work. I might be back with furthur queries depending on what happens. Thanks, Mik

Ok I think I have the first bit worked out: 'get username dim objWscript set objWscript = CreateObject(''WScript.Network'') usr = objWscript.UserName 'create query dim objDataAdapter set objDataAdapter = XDocument.DataObjects(''ad_details'').QueryAdapter objDataAdapter.Command = objDataAdapter.Command + '' where Windows_Logon = ''' + usr + ...

I didnt create it from an existing SQL table because one didnt exist (infact the functionality of it wasnt really decided at that point) I understand that it can be done programmically by specifying what data connection you want to use, then adding to its default query (as a string) where i can use a variable in the WHERE condition, then execute ...

Hi, I am developing a form which will retrieve the users information from a table based on their username. I can get their username, but how do I query the database conditionally? I have set it up as a secondary data source (will be submitting to another database) I understand you can add additional commands to the query in the script (currently ...