InfoPath Dev

it got it, it was sql queries not liking the single quotes.

I have a dropdown populated by a webservice, the webservice returns an array of string and one of the strings has a single quote and I get this error in infopath The query cannot be run for the following DataObject: QueryOppsFormByName InfoPath cannot run the specified query. The SOAP response indicates that an error occurred on the ...

got it, I put the rules on the dropdownbox field instead of the text field. thanks! here is the site for a reference: http://wssdevelopment.blogspot.com/2007/11/querying-web-service-with-infopath-2007.html

i found a good post on this subject and followed the directions but I'm not returning any data, does this look right? I create a new action to set a field’s value. For the field, I click on the Browse Icon and select my web service from the data source drop down. You should see query fields and data fields as nodes in the tree. Open ...

this is not working for me, this is what I did with the rules I took the button out of the picture so now I have a text field and dropdown 2 rules, 1) to "submit" the Client_ID to the webservice 2) to "query" using data connection I am not returning anything, I am "submitting" but then my ...

I am not very familiar with rules but I'm looking at them now. can you please guide me? I have a text field, a button and a dropdown box. do I create the rules on the button to: submit using a data connection? how does it then populate the dropdown?

I have a webservice and I want to pass a string to it and it should return an array of strings that populate a dropdownbox. Right now I'm at the point where if I hard code the value that I'm passing to the web service it will populate the dropdownbox. yay! Now I have to pass the value of a text field to the webservice, I'm using ...

 I am trying to dynamically populate a drop-down list by calling a web service, I have this example:  http://support.microsoft.com/kb/826994 but the code is vbscript or jscript, I need VB.    Can someone provide an example or help me change this to vb?    Dim fieldValue set fieldValue = ...

 I have a secondary data source set to an XML file, I want to change the "Entries" section below with vb.net, is this possible? My XML is formed so every "clientID" is a seperate node and I need to change the dropdownlist box dynamically