-
Great -- glad you have it all working. Yes, Notepad2 is *wonderful* for figuring out where all your parentheses go. Also, it has syntax highlighting availble, so if you open an XML file (for example) with it, it is easier to read.
-
Everything has been working great. Thanks again for all your help. That notepad2 is very helpful.
-
Did you ever get resolution to this issue? I'm having the same problem.
-
There are two kinds of store. You can choose them when you convert or modify your Data Connection in Infopath.
When you choose:
- local Data Connection Library
then the udcx File has to be stored in the "Data Connections" Library of your Site
- central managed Data Connection Library
then the udcx ...
-
Your second fomula you are showing:
substring(eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ")'), ".."), 1, string-length(eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ")'), "..") - 3)
Should be:
substring(eval(eval(rsResourceName, ...
-
Ohhhhhh!!!!!
I need to put that extra parenthesis in front of the -3 like this:
concat(substring(eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ")'), ".."), 1, string-length(eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ")'), "..")) - 3), " - ", ...
-
I'm sorry but I'm not sure I follow.
I took the first sample you sent me and it worked just fine: eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ")'), "..")
When I applied that to your next line of code : substring(eval(eval(rsResourceName, 'concat(my:tbResourceName2, " , ...
-
Again, you have an error with your parentheses. You have closed the parentheses for the substring function, but not for the concat function. The error is saying 'Hey, weren't you concatenating here? Did you want to add another value?' It's looking for a comma and another value, and a closing parenthesis.
There is a great, ...
-
I did that and got this error:
Expected value type: ,
Actual value: end-of-string
concat(substring(eval(eval(../my:group5/my:rsResourceName, 'concat(my:tbResourceName2, " , ")'), ".."), 1, string-length(eval(eval(../my:group5/my:rsResourceName, 'concat(my:tbResourceName2, " , ")'), ...
-
You have a little issue w/ your parenthesis at the end of your formula. Instead of - 3)) try ) - 3)