InfoPath Dev

In a nutshell, here's what I'm trying to accomplish: When I launch my InfoPath form it should contact a web service that returns a list of records and populates a drop-down list.  I choose one of those items in the list and hit a button which runs the main query and fills out the rest of the form based on the selected item.   I ...

Thanks for your reply.  I tried making the database field a char(1) to avoid getting stray characters, but that didn't help.  I would think that varchar(n), where n is any integer, would just return the value in the database field, because that's what the "v" is for.  To get by this problem I converted the database ...

I have a SQL Server database with a table that has a field, discussedOutside, which is of type varchar(2).   I also have a web service that accesses that table, and in that service the class that defines the data to be returned to InfoPath has a field, discussedOutside, which has a type of string.  Finally, my InfoPath form ...