InfoPath Dev

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

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.