-
Awesome tip! Thanks for sharing this.
Have you verified that every one of those <script/> blocks are actually needed to accomplish this? It looks like all you might need is the one for Core.js. I'd rather not include any additional blocks than are required.
-
This is the expected behavior. The value MUST be unique. This is the stored value. The display name is just for show purposes only. The stored value must be unique in order for the drop-down to know which selection was made.
-
When you say "uniquely identified" -- does that mean uniquely identified across sessions, or just within a session? If just within a session, then you can assign a default value formula to get the count(previous::day_id)+1, for example. These then will always be numbered based on order.
If you need to have it unique across sessions, ...
-
I don't have an answer to this. Is there someone else who can answer this question?
-
The easiest way is to go into the XML file for the data source, and manaully create the string using the fully-qualified node names (i.e. including namespaces). It's a real pain without the new IP07 feature..
-
Are you using InfoPath 2007? If so, right click the field in the Data Source task pane, and click "Copy XPath". This will give you the fully qualified XPath (with the namespaces in it).
-
Are you talking about on submit? If so, don't use the default submit. Write code, and in your code you can walk through the errors collection and report any errors you need to with their details, then cancel the submit. If there's no errors, then do the submit.
-
Yes, editing the data connection SQL command permanently changes the default query. However, the query command is available to be updated at any time using code before you query.
When using LIKE, you need to use the "%"s. The LIKE clause *is* your wildcard...
So if you use:
SELECT * FROM table WHERE column LIKE '%an%'
This ...
-
It doesn't appear that XPath 1.0 (which is what IP03/07 uses) has any way to do this. Your better bet would be to use code to accomplish the cacluations.
-
User name is available to full trust forms. Otherwise, you will need to use a Web service to accomplish this.