mputhupa
12-29-2008, 03:29 PM
I have a problem passing selected values from the multiSelect tool to a SQL procedure if more than one value is selected.
My Stored Procedure takes one value that should hold all the values from the multi select that is parsed by a function.
The http:// value in the string that generates the report for the selected fields are Field=Selection1&Field=Selection2&Field=Selection3 etc.
It seems that this format is required by the xaction file to validate the selection.
The SQL Procedure expects just one field that represents all the selections. In this example it would be 'Selection1, Selection2, Selection3'
At this point I would be ok if I could get each of the selected fields into its own field but the {PREPARE:Field} statement seems to prevent this.
Any help in resolving this would be much appreciated.
My Stored Procedure takes one value that should hold all the values from the multi select that is parsed by a function.
The http:// value in the string that generates the report for the selected fields are Field=Selection1&Field=Selection2&Field=Selection3 etc.
It seems that this format is required by the xaction file to validate the selection.
The SQL Procedure expects just one field that represents all the selections. In this example it would be 'Selection1, Selection2, Selection3'
At this point I would be ok if I could get each of the selected fields into its own field but the {PREPARE:Field} statement seems to prevent this.
Any help in resolving this would be much appreciated.