Search Results

Search found 49435 results on 1978 pages for 'query string'.

Page 228/1978 | < Previous Page | 224 225 226 227 228 229 230 231 232 233 234 235  | Next Page >

• add commas using String.Format for number and

  - by raklos

  Using String.Format how can i ensure all numbers have commas after every 3 digits eg 23000 = "23,000" and that 0 returns "0". String.Format("{0:n}", 0); //gives 0.00 which i dont want. I dont want any decimal places, all numbers will be integers.

  Read the article

• Removing word + wildcard number from string

  - by zx

  Hi, I have a string that is $str = "testingSUB1"; How can I strip out SUB* from the string? I assume using preg_replace but I'm not good with matching what I want with regex. Does anyone know how I can do this? Thank you

  Read the article

• editing a string using BufferedReader in Java

  - by pbs

  Exception handling aside, I'm using the following to input a line of text in Java: BufferedReader strin = new BufferedReader(new InputStreamReader(System.in)); String txt = null; txt = strin.readLine(); However, I want to be able to edit an existing string, so that if txt were initialized to "hello" instead of null, then the readLine() would have the "hello" text in the buffer for me to edit. I can't see how to do this. Any help would be appreciated.

  Read the article

• converting 6 bytes hex string to 8 byte raw data

  - by ron

  How can i convert a hex string lenght 6 bytes for example string ='1122aaccddff'; to raw binary data of lenght 8 byes the last 2 bytes shoul be padded with zeros,

  Read the article

• Wrong data retrieved from database

  - by holyredbeard

  So, I want to retrieve the order of the elements of a list. The order is set before by the user, and are stored in the table below. Because I also want to retrieve name and description of the list elements I need to combine two tables (see below). However, what is actually retrieved is an array containing 16 elements (should be four because it only exists four elements as for now). The array is too long to post here, but I put it in a phpFiddle to be found here if you're interested. Well, I have really tried to find what's wrong (probably something easy as always), but with no luck. Thanks a lot for your time and help! listModel.php: public function GetOrderedElements($userId, $listId) { // $userId = 46 // $listId = 1 $query = "SELECT le.listElemId, le.listElemName, le.listElemDesc, lo.listElemOrderPlace FROM listElement AS le INNER JOIN listElemOrder AS lo ON le.listId = lo.listId WHERE lo.userId = ? AND lo.listId = ? ORDER BY listElemId"; $stmt = $this->m_db->Prepare($query); $stmt->bind_param("ii", $userId, $listId); $listElements = $this->m_db->GetOrderedElements($stmt); return $listElements; } database.php: public function GetOrderedElements(\mysqli_stmt $stmt) { if ($stmt === FALSE) { throw new \Exception($this->mysqli->error); } if ($stmt->execute() == FALSE) { throw new \Exception($this->mysqli->error); } if ($stmt->bind_result($listElemId, $listElemName, $listElemDesc, $listElemOrderPlace) == FALSE) { throw new \Exception($this->mysqli->error); } $listElements = array(); while ($stmt->fetch()) { $listElements[] = array('listElemId' => $listElemId, 'listElemName' => $listElemName, 'listElemDesc' => $listElemDesc, 'listElemOrderPlace' => $listElemOrderPlace); } var_dump($listElements); $stmt->Close(); return $listElements; } from the database: listElemOrder: listElemOrderId | listId | listElemId | userId | listElemOrderPlace 1 1 1 46 1 2 1 2 46 4 3 1 3 46 2 4 1 4 46 3 listElement: listElemId | listElemName | listId | listElemDesc | listElemOrderPlace 1 Elem A 1 Derp NULL 2 Elem B 1 Herp NULL 3 Elem C 1 Lorum NULL 4 Elem D 1 Ipsum NULL Note: 'listElemOrderPlace' in the table listElement is the final order of the elements (all users average), not to be mixed with the one with the same name in the other table, that's only a specific user's order of the list elements (which is the interesting one in this case).

  Read the article

• Usage of std::string.append causes "Stack around the variable 'result' was corrupted"

  - by Yan Cheng CHEOK

  I have the following code : std::string Utils::get() { std::string result; result.append(1, 'x'); result.append(1, 'x'); result.append(1, 'x'); return result; } I expect 'xxx' to be returned. However, when I run under debug mode, I get the warning "Stack around the variable 'result' was corrupted" Am I using append function the wrong way?

  Read the article

• MySQL: Check if first character is _not_ A-Z

  - by dbemerlin

  I have to create an SQL Query to get all rows starting with a specific character, except if the parameter passed to the (PHP) function is 0, in that case it should get every row that does not start with A - Z (like #0-9.,$ etc). What is the easiest and fastest way to get those rows? DB: MySQL 5.1 Column: title

  Read the article

• How to apply two functions on the same string without using ">>"

  - by altair211

  Hi, I am writing a function like this. func :: IO() func = putStr print "func = putStr print" I know it is incorrect but the idea is I want the putStr applied to the string then print applied to the same string "fun = .." so that the output would be: func = putStr print "func = putStr print" which is the same as my function definition. Thanks

  Read the article

• Check if string is just white space?

  - by John Isaacks

  I do not want to change a string nor do I want to check if it contains white space. I want to check if the entire string is ONLY white space. What the best way to do that?

  Read the article

• extract all urls from a string

  - by codemonkey12

  I have a string of text that contains html, and I need to extract each url (most likely in img or a tags) to create a generic list of string objects. Is there an easy way to do this or will I have to resort to regular expressions? If I have to resort to regular expressions, would you mind helping me out with that as well? :)

  Read the article

• How to replace certain text/string in selected area using javascript

  - by B. Kumar

  I have written a text editor using JavaScript. Here I am not storing the written text in any variable, Now I want to replace some text/string of some selected text with other text/string. Can anyone suggest me, how to do it using JavaScript. Thanks

  Read the article

• How to get all post from facebook event wall?

  - by App_beginner

  I am trying to query all post that are made to the wall of a facebook event. But am not making any headway. Is this at all possible. How would you proceed? Create a multiquery FQL statement?

  Read the article

• SQL, Auxiliary table of numbers

  - by vzczc

  For certain types of sql queries, an auxiliary table of numbers can be very useful. It may be created as a table with as many rows as you need for a particular task or as a user defined function that returns the number of rows required in each query. What is the optimal way to create such a function?

  Read the article

• Lucene: How to have more than 100 results?

  - by zshis

  Hi all, my question is simple but i cant fin de answer. Is there a way to set in Lucene to retrieve an amount of results higher than 100 in a query? Im using lucene 2.4.0 now. Thanks all.

  Read the article

• String replacment in batch file

  - by Faisal

  We can replace strings in a batch file using the following command set str="jump over the chair" set str=%str:chair=table% These lines work fine and change the string "jump over the chair" to "jump over the table". Now I want to replace the word "chair" in the string with some variable and I don't know how to do it. set word=table set str="jump over the chair" ?? Any ideas?

  Read the article

• Help needed on resolving a string into MDX expression

  - by excel_newbie

  The string is stored in a parameter. Say, @FiscalPeriod = "[Date].[Fiscal Dates].[Fiscal Quarter]" Now, I need to use the parameter as SELECT Measures.[Revenue] ON 0, CLOSINGPERIOD("Parameter Here") ON 1 FROM [Sales] STRTOMEBER function gives error because it is looking for a member at the leaf left such as [Date].[Fiscal Dates].[Fiscal Quarter].&[Q1 - 2009] How can I resolve the string into the mdx expression to use it with closing period??

  Read the article

• PHP regex:Find all 6 digit numbers in a string that do not end in 00

  - by Argiropoulos Stavros

  Hello all I'm trying to find all the 6 digit numbers in a string that do not end in 00. Something like that /([0-9]{4})([^00])/ //i know this is wrong so the string asdfs dfg_123456_adsagu432100jhasj654321 will give me results=[123456,654321] and not 432100 Thanks Have a good day

  Read the article

• mySQL: Order by field size/length

  - by Sadi

  Here is a table structure (e.g. test): __________________________________________ | Field Name | Data Type | |________________|_________________________| | id | BIGINT (20) | |________________|_________________________| | title | varchar(25) | |________________|_________________________| | description | text | |________________|_________________________| A query like: SELECT * FROM TEST ORDER BY description; But I would like to order by the field size/length of the field description. The field type will be TEXT or BLOB.

  Read the article

• Does Oracle re-hash the driving table for each join on the same table columns?

  - by thecoop

  Say you've got the following query on 9i: SELECT /*+ USE_HASH(t2 t3) */ * FROM table1 t1 -- this has lots of rows LEFT JOIN table2 t2 ON t1.col1 = t2.col1 AND t1.col2 = t2.col2 LEFT JOIN table3 t3 ON t1.col1 = t3.col1 AND t1.col2 = t3.col2 Due to 9i not having RIGHT OUTER HASH JOIN, it needs to hash table1 for both joins. Does it re-hash table1 between joining t2 and t3 (even though it's using the same join columns), or does it keep the same hash information for both joins?

  Read the article

• Loop through list within a Groovy multi line string

  - by UltraVi01

  I am trying to create a multi line string in Groovy. I have a list of strings that I'd like to loop through within the multi line string. I am not sure what the syntax is for this. Something like below... def html = """\ <ul> <li>$awaiting.each { it.toPermalink()}</li> </ul> """

  Read the article

• MYSQL Order By Sum of Columns

  - by djs22

  Hi all, Any idea on how to order the results of a MYSQL query by the sum of two columns rather than by a single column? Select * FROM table ORDER BY (col1+col2) desc I know that won't work., but I hope it conveys what I want to do fairly well. Thanks!

  Read the article

• help for splitting a string in javascript

  - by Hero

  Hi everyone... I'd asked a question about the splitting the a string like below: Input string: "a=aa| b=b||b | c=cc" and the output: a=aa b=b||b c=cc Kobi's answer was: var matches = "a=aa|b=b||b|c=cc".match(/(?:[^|]|\|\|)+/g) his answer was correct. But I need to use "split" method and save store the outputs in a array. so I can't use the Match Method. So please help me...

  Read the article

• How can I get a COUNT(col) ... GROUP BY to use an index?

  - by thecoop

  I've got a table (col1, col2, ...) with an index on (col1, col2, ...). The table has got millions of rows in it, and I want to run a query: SELECT col1, COUNT(col2) WHERE col1 NOT IN (<couple of exclusions>) GROUP BY col1 Unfortunately, this is resulting in a full table scan of the table, which takes upwards of a minute. Is there any way of getting oracle to use the index on the columns to return the results much faster?

  Read the article

• how to get the comma seperated values of the column stored in the Sql server

  - by Innova

  how to get the comma separated values stored in the Sql Db into a individual values e.g in sql DB the column is stored with comma values as shown below, EligiblGroup A11,A12,A13 B11,B12,B13 I need to get EligibleGroup A11 A12 A13 B11 B12 ... I have written a query that will fetch me some list of employees with employee name and elibigle group XXX A11 YYY B11 ZZZ C11 I need to check that the employees(XXX,YYY,ZZZ) eligiblegroup falls within this EligiblGroup A11,A12,A13 B11,B12,B13 and retrun me only that rows.

  Read the article

• SQL WHERE.. IN clause multiple columns

  - by ala

  i need to implement the following query in SQL Server select * from table1 WHERE (CM_PLAN_ID,Individual_ID) IN ( Select CM_PLAN_ID, Individual_ID From CRM_VCM_CURRENT_LEAD_STATUS Where Lead_Key = :_Lead_Key ) but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select?

  Read the article

< Previous Page | 224 225 226 227 228 229 230 231 232 233 234 235  | Next Page >