Re: Concatenate multiple row values into one string

Hilary Stoupa — Wed, 21 Oct 2009 19:55:50 GMT

Hmmm. Most posts around the double eval() method are used to concatenate together things like email addresses, separating with a semicolon. That being said, I'd think you could use the double eval() method here, with a space for the separator, instead of a semi-colon. The InfoPath Team Blog has a good post about double eval() here.

Now, your scenario gets a bit trickier, because it is also conditional. There is a fantastic post about making double eval() conditional here. All that being said, however, it might be easier to be pulling your data from a view where the values had already been concatenated.Then you could use a simple rule to populate your text field when the work order has been entered into the text box on the form.

Concatenate multiple row values into one string

bradb — Fri, 16 Oct 2009 14:25:38 GMT

I have an Infopath form for printing off a work order summary. I have a text section that I want to auto-populate with data from the SQL database. The problem is, the software that handles our workorders stores multiple lines as multiple records with a possibility of up to 300+ lines.

For example:

SQL DB

WORK_ORDER_NO LINE_NO VALUE

11111111 1 This is the

11111111 2 value of

11111111 3 work order number 11111111

I need to be able to get the VALUE fields concatenated into one string where the WORK_ORDER_NO is equal to the work order entered in a text box in the Infopath form. (ie. "This is the value of work order 11111111")

I know how to do it IF I knew how many lines there were going to be, but there could be 3, or 300.

Any suggestions would be greatly appreciated!

Thanks

SQL Database Integration

Re: Concatenate multiple row values into one string

Concatenate multiple row values into one string