comma

retrieve comma delimited data from a field in using SQL

I've created a form in PHP that collects basic information. I have a list box that allows multiple items selected (i.e. housing, rent, food, water). If multiple items are selected they are stored in a field called Needs separated by a comma. I have created a report ordered by the persons needs. The people who only have one need are...

Send comma delimited CSV through SFTP?

I am collecting registration information on my site and need to figure out how to pass all data stored in the MySQL DB (or just portions of it) as a CSV file through an SFTP so our partners can access the information. The pages are built using PHP. I literally have no idea how to do this and am hoping somebody has experience doing so. ...

Separating arguments to a function, in locales with comma as decimal marker

In locales, e.g. French, with comma as decimal indicator (where "5,2" means five and two-tenths), how do users separate function arguments from each other? For example, in many programming/scripting languages, I could specify MAX(1.5, X) in a EN-US locale. How do you avoid the ambiguity between the comma as decimal indicator, and as ...

using jquery selector with ids with comma

I am using MyTableGrid to show an Excel like control in my webpage. The cells are referenced with ids like "mtgIC1_0,2" for table 1, column 0, row 2. Unfortunately, when I try to use the jquery selector with this id $("#mtgIC1_0,2"), it never works. I figured it is because of the "," since it works for any other ids in the page withou...

From a one to many SQL dataset Can I return a comma delimited list in SSRS?

I am returning a SQL dataset in SSRS (Microsoft SQL Server Reporting Services) with a one to many relationship like this: ID REV Event 6117 B FTG-06a 6117 B FTG-06a PMT 6117 B GTI-04b 6124 A GBI-40 6124 A GTI-04b 6124 A GTD-04c 6136 M GBI-40 6141 C GBI-40 I would like to display it as a comma d...

jQuery tablesorter plugin - comma decimals

Hello, I've been searching the web for an answer but there simply isn't a solution that works. I have a table with prices in this format: "1.234,56", so the decimals are after the comma and the dot is for separating thousands. This format doesn't work, tablesorter plugin sees it as strings rather than a number whenever there's a differe...

How can I retrieve data from an array, 3 at a time?

Is there a better way in PHP to access this array in groups of three? Let's say my array is a comma separated string like : ("Thora","Birch","Herself","Franklin Delano","Roosevelt","Himself (archive footage)","Martin Luther","King","Himself (archive footage) (uncredited)") although the array can end up being much larger, each one wil...

Limiting Keywords with jQuery by counting commas?

I'm using a CMS to allow users to add keywords to their profiles, but I'm wanting to limit that to 10 keywords, which are comma delimited, by counting the number of commas (in this case, 9). Any ideas on how to go about doing this with jQuery? I'll be doing a double-check on the server-side, but I'd like a quick little, live error check...

Obtuse Javascript coalescing with commas

Can someone explain the potential logic behind a group assignment like this in javascript: var next, output = null, thisNode; It appears like it's some type of coalescing like var foo = bar || baz;, but I'm not so familiar with the commas. Thoughts? ...