Search DaniWeb - seperator

Decimal seperator - thousand seperator when using sql server 16 Years Ago by serkan sendur … we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in…money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts &…quot;," as thousand and "." as decimal seperator. So there are two solutions to this problem; either … DIRECTORY SEPERATOR vs %5C 14 Years Ago by OmniX Hi Guys I have been using the DIRECTORY SEPERATOR and from time to time i get a %5C instead of the appropriate / or \ now. Any ideas what is the problem? Thanks, Regards X Remove seperator 11 Years Ago by code_rum Hi, I have following code and I want to remove first seperator using css here's the code <div id="sub_nav"> | <a href="#">Fashion Insider</a> | <a href="#">Leasing</a> </div> Re: Remove seperator 10 Years Ago by code_rum … was getting on using wp_nav_menu in wordpress. So i added seperator '|' into a span Now it looks like <div id… how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by blueguy777 … into var1 and field mobno2 into var2 by using comma seperator and pdo. my code is as follows. $pdo = Database::connect… Re: DIRECTORY SEPERATOR vs %5C 14 Years Ago by ShawnCplus My guess is that you're using it as a GET parameter and it's being encoded to it's respective URL entity Re: DIRECTORY SEPERATOR vs %5C 14 Years Ago by OmniX No im just using it as a reference in php and instead of being a "/" it is a "5%C". Re: DIRECTORY SEPERATOR vs %5C 14 Years Ago by amd_k8 The problem code please... I think that with "/" should not be problems at all, while the "\" in most cases has to be doubled, e.g. "\\". Re: Remove seperator 11 Years Ago by JorgeM What do you mean...you want to remove this character "**|**"? Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by broj1 Where does it stop? What is the error? The query: $sql = "SELECT mobno1,mobno2 FROM custreg"; presumably returns a set of rows, but $data = $q->fetch(PDO::FETCH_ASSOC); returns only one row. Is that what you aimed for? Note, you have a line of code saying: $message = urlencode($tempmsg); But where is teh… Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by cereal I don't understand: you're talking about the data you want to save into the `custreg` table? If yes, where are the form, the insert query and the table definition? Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by diafol >i would like store all the values of field mobno1 into var1 and field mobno2 into var2 What do you mean? Get `mobno1` for every record and place it into a comma separated string ($var1)? Likewise for `mobno2`? Do a `fetchAll(PDO::FETCH_ASSOC)` and placve the data into `$records`. If you have php5.5.0 you can use `array_column()`... $… Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by blueguy777 yes diafol you are right i would like to get mobno1 for every record and place it into a comma separated string ($var1)? Likewise for mobno2 my PHP version is 5.4.34 and not supporting array_column function any alternate solutions Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by pritaeas Why not use: SELECT GROUP_CONCAT(mobno1) AS mobno1, GROUP_CONCAT(mobno2) AS mobno2 FROM custreg Re: how to store mobile numbers in a variable with comma seperator using pdo 9 Years Ago by blueguy777 following is the working example with WHERE clause $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM custreg where reg_no = ?"; $q = $pdo->prepare($sql); $q->execute(array($cust_id)); $data = $q->fetch(PDO::FETCH_ASSOC); … Range marks of a student algorithm 13 Years Ago by mrar85 … studentid; int progassn; int lab; int test; int exam; char seperator; double finalmark; } stumarks[9]; using namespace std; int main… Re: Range marks of a student algorithm 13 Years Ago by mrar85 …50],test_marks[50],exam_marks[50]; //arrays of 50 student char seperator[50];//This is to read the comma that is a…infile>>student_id[student_count]>>seperator[student_count] >>assignment_marks[student_count]>>seperator[student_count] >>lab_marks[student_count]>… css cookie issue 15 Years Ago by Inny …cookie=getCookie(name); /* get existing cookie */ cookies=cookieCutter(cookie, seperator); /* get the cookies as an array */ if(testVar(cookies)){…vanilla=getCookie(name); if(testVar(vanilla)){ crumbs=cookieCutter(vanilla, seperator); for(var x=0; x< crumbs.length; x… Re: Range marks of a student algorithm 13 Years Ago by mrar85 …int progassn; int lab; int test; int exam; char seperator; double finalmark; } stumarks[9]; int get_grade(int&, …gt;stumarks[i].studentid >>stumarks[i].seperator>>stumarks[i].progassn >>stumarks[i… Re: Range marks of a student algorithm 13 Years Ago by Clinton Portis …;>stumarks[i].studentid >>stumarks[i].seperator>>stumarks[i].progassn >>stumarks[i…].seperator>>stumarks[i].lab >>stumarks[i].seperator >>stumarks[i…].test>>stumarks[i].seperator >>stumarks[i].exam; //Populate grade … Re: Range marks of a student algorithm 13 Years Ago by Clinton Portis …;>stumarks[i].studentid >>stumarks[i].seperator>>stumarks[i].progassn >>stumarks[i…].seperator>>stumarks[i].lab >>stumarks[i].seperator >>stumarks[i…].test>>stumarks[i].seperator >>stumarks[i].exam; //Populate grade … Re: Range marks of a student algorithm 13 Years Ago by mrar85 …>>stumarks[i].studentid >>stumarks[i].seperator>>stumarks[i].progassn >>stumarks[i…].seperator>>stumarks[i].lab >>stumarks[i].seperator >>stumarks[i…].test>>stumarks[i].seperator >>stumarks[i].exam; //The get_range()… from DataTable to Multi-line Chart 12 Years Ago by rminator …new string[Set_len];//myReader.ReadLine().Split(new Char[] { seperator, '\t' }); //skip title // Title = …{ fieldValues = myReader.ReadLine().Split(new Char[] { seperator, '\t' }); myRow = myTable.NewRow(); for … Problem writing and reading files 13 Years Ago by fg_aa_c … not be created\n",filename); exit (5); } write(fd, seperator, strlen(seperator)); write(fd, "\n", 1); write(fd, argv…", 1); write(fd, buffer, strlen(buffer)); write(fd, seperator, strlen(seperator)); free(buffer); close(fd);[/CODE] Now if I cat out… Reading and posting a .csv file into a SQL database 13 Years Ago by dougancil …ReadContents = myReader.ReadToEnd(); fieldValues = myReader.ReadLine().Split(seperator) 'Create data columns accordingly For i = 0 To…() <> -1 fieldValues = myReader.ReadLine().Split(seperator) myRow = myTable.NewRow() For i = 0 To… Reading CSV file problem 13 Years Ago by ddanbe …string[] fieldValues = myReader.ReadLine().Split(new Char [] {seperator,';'}); // Adding the first line of data to data table…() != EOF) { fieldValues = myReader.ReadLine().Split(new Char [] {seperator}); myRow = myTable.NewRow(); for (int i = 0; i … Re: Reading CSV file problem 13 Years Ago by Mitja Bonca …{ string[] fieldValues = myReader.ReadLine().Split(new Char[] { seperator, ';' }); // Adding the first line of data to … != EOF) { fieldValues = myReader.ReadLine().Split(new Char[] { seperator }); myRow = myTable.NewRow(); for (int i = 0; i … Populating a Menu with an XML document 13 Years Ago by MaddTechwf …an ID MITEM's can have the following Type: seperator, item, popup MITEM TYPES ============================================= POPUP - will…- will indicate a child SEPARATOR - will indicate a seperator. --> <ToolboxMenu> <MENU ID… separator, then it will be a typical seperator. I'm hoping this will shed some … Generate line chart for the values in the database 9 Years Ago by sheelakumari … for the sequence, and can take an optional seperator */ function generateSequence($min, $max, $seperator = "") { $output = ''; for ($i =… $min; $i <= $max; $i++) { $output .= $i . $seperator; } return $output; } $chart = generateGoogleChart(); $html = '<div id="chart… modify script 18 Years Ago by clarkkent …($isWIN){ $S{S} = "\\\\"; } else { $S{S} = "/";} # seperator used in paths $ScriptURL = "http://$ENV{'SERVER_NAME'}$ENV{'SCRIPT_NAME… a WINDOWS server, each slash should be escaped. Eg. each seperator should look like this : \\\\ <p> Sometimes, the root…