Re: Create a search function in InfoPath using a web service

arif@HP — Tue, 01 Mar 2011 09:48:41 GMT

Hi, it seems I solved the problem myself.

The stringBuilder was not using speech marks around the where clause part.

i.e. - Select * from db where table = "day";

Many thanks.

Create a search function in InfoPath using a web service

arif@HP — Mon, 28 Feb 2011 13:52:11 GMT

Hi there,

I was wondering if someone can provide some guidance for creating a search and filter facility in my InfoPath form.

Currently, I have 4 fields in my form, which the user can conduct a search from.

I initially mapped each field to a query parameter from a web service, from which attempted to construct a SQL query using a StringBuilder.

The end result string was placed in an odbcAdapter, and dataset was used for filling the results. This dataset is then returned back to the InfoPath form. Unfortunately, my dataset object does not return any results from the database.

Any ideas?

Michael

Web Services

Re: Create a search function in InfoPath using a web service

Create a search function in InfoPath using a web service