Duplicate of: http://stackoverflow.com/questions/712443/tsql-varchar-string-manipulation-problem/712453#712453 I'm building a dynamic SQL statement out of parameters from a reporting services report. Reporting services passes MutiValue Parameters in a basic CSV format. For example a list of states may be represented as follows: AL,CA...
I have a report containing seven tables, each table returning a different set of values for a list of id's selected in a parameter list. I have the tables enclosed in a rectangle so that they print together. Now I would like to group the results based on the id passed in from the multi-select parameter. So if I have a list of four ids i...
Currently, one of our production systems is handled by over 3000 programs written between 1986 and now . The code base is written in a non-standard language, which unfortunately lacks modern testing tools. In a bid to improve our code quality moving forward I have been working to incorporate processes and build tools that will improve d...
I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is that it is a bad idea to make use of multiple values in a single field. Traditionally if you wanted to allow for a record to have several values for a field you would create another two tables and link them with foreign ...
I have a web service I need to call which is expecting a string Array. I'm using the standard VS SSRS and am having troubles setting up the Data Source in my project. I've setup DataSet parameters and tried a number of different options but it seems it will always pass the value as text. I get thrown the error (Expecting state 'Element...
I'm trying to map my skills and responsibilities profile sections to one of the custom properties in Active Directory (extensionattribute1 , 2, etc). I'm entering comma seperated values in AD and it's importing the values fine but sees the comma seperated values as one value on import. i.e. 'C#,asp.net,javascript' rather than 'C#', 'asp....
I basically want Solr to search each record of the multivalued field for my search parameter.. read on for my example: I am using Solr to index my data. I have application data in parallel arrays (in the form of multi-valued fields) that match a given product. See the following example, where make, model, and year are multivalued fields...
I have an application where users can pick car parts. They pick their vehicle and then pick vehicle attributes as facets. After they select their vehicle, they can pick facets like engine size, for example, to narrow down the list of results. The problem was, not all documents have an engine size (it's an empty value in Solr), as it does...
Hi, I am trying to add nested multi value specifiers to my app's Settings bundle (something like what is done in the "Region Format" section of the International settings in the Settings app). I have tried to use a PSMultiValueSpecifier for the first set of values (first screen, like the list of languages in "Region Format") and then s...
I just started working with SSRS, so this question might seem silly. Anyway, for now I'm trying to avoid multi-valued parameters, because I want my parameters to be able to be NULL. So I'm just passing a comma-separated string of ID values to my stored procedure, and everything works. The problem I encountered is that I want to displa...
I am creating a report where the parameter selection = customer_name and the report is one page and has 5 tablix relating to the customer. What my team would like is to be able to select more than one customer at a time to save time; however they want a separate page per customer_name. Can this be done with multi-value parameter and if s...
I have the strange aversion to passing in multiple ID parameters to a single stored procedure. For example, this feels just wrong: GetMyObject(ListofIDs, OtherParam1, OtherParam2, ...) I understand HOW to do it (correctly if I must).. but I don't feel like I should do it. I feel like it defeats the purpose of a "get item" stored proced...
Consider The following is the json response i'm getting from the solr if i use multivalued = true for the fields. { "id":["1","2","3"], "TS":["2010-06-28 00:00:00.0","2010-06-28 00:00:00.0","2010-06-28 00:00:00.0"], "Type":["VIDEO","IMAGE","VIDEO"] } but i need the response like this { "0":["1","2010-06-2...
Hi, I've added a MultivaluedField to my index (haystack), I need to search for a ManyToMany related field, but it doesn't work. The engine is WHOOSH. This how my index looks like: class PostIndex(SearchIndex): text = CharField(document=True, use_template=True) author = CharField(model_attr='author') body = CharFiel...
I have a set of Solr documents containing (among other fields) multi-value fields with percentage data or -1 if the value is null, e.g. <doc> ... <arr name="alpha"> <float>0.23</float> <float>0.23</float> <float>0.43</float> </arr> <arr name="beta"> <float>0.52</float> <float>-1.0<...
I'm trying to export data from a multivalue database (Unidata) into MySQL. Lets say my source data was a person's ID number, their first name and all the states they've lived in. The states field is a multi value field and I'm exporting them so that the different values within that field are seperated by a ~. A sample extract looks like:...