General

Re: Sorting a drop down list from SQL data source

fcoulter — Mon, 19 May 2014 14:57:44 GMT

Add me to the list of people who feel stupid.

I was working with InfoPath 2007 in my old job, and we had edited the SQL query in order to sort the results. Now that I'm at a new job, with InfoPath 2013 on my desktop, I lost access to my old notes. So I was going to come here to find how to modify the query so that it sorted the results.

AND IT'S BUILT INTO INFOPATH! AND IT'S BEEN IN INFOPATH THE WHOLE TIME.

Face plant time.

Thanks for letting me know about the obvious.

Re: Sorting a drop down list from SQL data source

Patrick_NPS — Mon, 19 Oct 2009 17:31:53 GMT

Thanks Hilary! It's nice when I don't have to spend more time than necessary to ahieve these simple things that seem to eat my lunch on many occasions :)

Re: Sorting a drop down list from SQL data source

djj66 — Wed, 27 May 2009 22:54:02 GMT

Hi Hilary,

Yes it's just a plain old SQL data connection - You're exactly correct - I can use the sort options after pressing the Modify button.

I've been working with InfoPath for about 4 months, but never pressed that button to see the sort options. (whoops, feel rather embarrassed now)

I've wasted hours and hours on this problem, looking at preserved code blocks, code behind etc. You've saved me hours more wasted effort.

Thanks so much,

regards
David

Re: Sorting a drop down list from SQL data source

Hilary Stoupa — Wed, 27 May 2009 15:26:16 GMT

This is just a plain SQL data connection? When you walk through the data connection wizard, you have the option to click the Modify Table button to the right of the window that displays your table and columns in a tree structure. When you click the Modify Table button, you can specify sort options. You also have the option to edit the SQL directly....

Re: Sorting a drop down list from SQL data source

Patrick Halstead — Wed, 27 May 2009 05:27:18 GMT

Hi David,

Indeed the preserve code block with xsl:sort is one way to do it. Greg's post: http://www.infopathdev.com/forums/p/4107/16226.aspx . You'll need to save your files as source and manually modify the XSL file. If you need help, send $50 to our PayPal account (Sales at no spam please Qdabra.com) and we'll walk you through it. It's not that hard, but will require about 30 minutes.

Cheers,

Sorting a drop down list from SQL data source

djj66 — Wed, 27 May 2009 02:08:36 GMT

Hi everyone,

I am using Infopath 2003, with VBScript where needed. I have created a form which is working well and which has several drop down lists which get their data from a SQL secondary data connection. As far as I can tell, there is no way to sort this drop down list(??) - it is always sorted using the Primary key field of the SQL table - is that correct?

I have read several articles on this site about how to sort DDL's but none seem to apply to my exact situtation - I'm not using a Sharepoint list, nor a browser enabled form.

Is it possible to resort the data coming into the Drop down list? - and how, do I need to use a "Preserve code block"? and do I need to use Code behind as well? (in VBSCRIPT)

I know how to create a preserve code block, but not what to put in it? If someone can tell me exactly what I need to do, and a few snippets of code, I'm sure I can do the rest.

Thanks in advance for your help, and hope to hear from someone soon :-)

regards, david