Search Results

Search found 23568 results on 943 pages for 'select'.

Page 531/943 | < Previous Page | 527 528 529 530 531 532 533 534 535 536 537 538  | Next Page >

• IEnumerable<string> => unique string[]

  - by Maxim

  Hello, i have collection of IEnumerable (sentence = string) i want to split all sentences to words (ex: .Select(t = t.Split(' ')); and after i need group this query by words to get list of unique words. Please, Help

  Read the article

• MySQL full text search, why am I getting Incorrect arguments to MATCH

  - by vick

  SELECT * FROM company c INNER JOIN city ci ON ci.city_id = c.city_id INNER JOIN state s ON s.state_id = c.state_id WHERE MATCH ( c.name, ci.name, c.zipcode, s.name ) AGAINST ( 'los angeles' )

  Read the article

• Conditional sorting in MySQL?

  - by serg555

  I have "tasks" table with 3 fields: date priority (0,1,2) done (0,1) What I am trying to achieve is with the whole table sorted by done flag, tasks that are not done should be sorted by priority, while tasks that are done should be sorted by date: Select * from tasks order by done asc If done=0 additionally order by priority desc If done=1 additionally order by date desc Is it possible to do this in MySQL without unions? Thanks.

  Read the article

• Determining an Oracle SQL MERGE statement result

  - by petejamd

  Follow up to this question This (similar version from old link) works in SQL Server 2008, however, Oracle is giving me trouble: MERGE INTO wdm_test USING ( select '10000000000000000000000000000000' Guid from DUAL ) val ON ( wdm_test.Guid = val.Guid ) WHEN MATCHED THEN UPDATE SET test_column = null WHEN NOT MATCHED THEN INSERT (Guid, test_column) VALUES ('10000000000000000000000000000000', null) OUTPUT $action; SQL Error: ORA-00933: SQL command not properly ended Does Oracle not support OUTPUT $action;? If not, is there an alternative?

  Read the article

• NHibernate (or other worth recommendation ORM), real life example?

  - by migajek

  I'd like to learn database applications in C# and I'm about to select some framework. I heard many recommendations of NHibernate, however I haven't decided yet. Anyway, I'd like to know if there's any real-life example (with sources) of NHibernate in C#, to learn best practices etc.? I know all of them are probably covered in the docs, but working example helps a lot understanding the proper development pattern.

  Read the article

• How do I confirm a given page was displayed after calling ISelenium.open()?

  - by Randy Eppinger

  Using .NET (though I don't think it is relevant), I have opened a page, but I want to confirm that the page was actually opened. I have a few ideas like using .Select(), but I want to do what is considered the best practice by others in the Selenium community.

  Read the article

• In JQuery, does the advanced CSS 3 selection style work in all browsers?

  - by SLC

  I'm watching a tutorial learning JQuery for the first time, and it seems you can select items using pretty much CSS, like: $('ul li:nth-child(3)').addClass('biscuits'); Is that kind of selector going to work on all browsers, or just ones that support CSS 3 ?

  Read the article

• group by with value of another column

  - by phenevo

  Hi, I've got table Articles ID identity autoincement, IDArticle: nvarchar(100) ,IDCar nvarchar(100), createddate How to convert this: SELECT IDCar , MAX(createddate) FROM Articles GROUP BY IDCar to get IDArticle eg: 1 art1 BWM 5-21-2010 2 art2 BMW 5-24-2010 3 art3 BMW 5-31-2010 4 art4 Porshe 5-31-2010 5 art5 Porshe 6-1-2010 Expecting result is: art3 art5 It's not duplicated with: http://stackoverflow.com/questions/2736769/sql-query-number-of-occurance/2736809#2736809

  Read the article

• Sharepoint - how to set permission level to add item but not view?

  - by Stuart

  I want to allow a certain group of users to add items to a list, but not be able to view all items. This is so I can set up a workflow with certain parts of it private. I thought it'd be possible by defining a new permission level in: http://servername/_layouts/addrole.aspx ('Add a permission level' page) However, when you select the "add items" list permission, "view items" is automatically ticked also. Anyone know a solution to this?

  Read the article

• What is wrong with this javascript?

  - by bala3569

  i use this javascript syntax for validating a checkbox... alert(document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked); if (document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked == false) { document.getElementById("ctl00_ContentPlaceHolder1_ErrorMsg").innerHTML = "please select the checkbox"; document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").focus(); return false; } My alert showed me false but my if loop is not working... Any suggestion...

  Read the article

• pgSQL query error

  - by running4surival

  i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?

  Read the article

• Problem with File uplolad in javascript.

  - by Nikhil

  I have used javascript to upload more than one file. when user clicks on 'add more' javascript appends new object to older div using innerHTML. Now the problem is if I select a file and then click on "add more" then new file button exist but older selected file removes and two blank file buttons display. I want this old file must be selected when user add new file button. If anybody can, Help Plz!!! tnX.

  Read the article

• MySQL - Combine two fields to create a unix timestamp?

  - by Dan

  Hi, I'm trying to retrieve a UNIX timestamp from a query by combining a date and a time field in the table, however it keeps returning as zero. SELECT *, UNIX_TIMESTAMP(startdate starttime) AS start, UNIX_TIMESTAMP(enddate endtime) AS end FROM mytable; Can anyone help me out? Thanks.

  Read the article

• problem while place the radio buttons inside the liview in android?

  - by Niladri Prasad Padhy

  Dear Everyone, I have a listview with radio button. when i click any option and scroll that list view the previous select will cleared.How to do this. The actual problem is when scroll the view on every scorll the view is refreshed, that's why every time the view is refreshed. How to do this I can't get any solution, Plz. Help. Thanks & Regards Niladri Padhy

  Read the article

• MySQL only returning one result. Im Baffled.

  - by Tapha

  Here is te code: <?php //Starting session session_start(); //Includes mass includes containing all the files needed to execute the full script //Also shows homepage elements without customs require_once ('includes/mass.php'); $username = $_SESSION['username']; if (isset($username)) { //Query database for the users networths $sq_l = "SELECT * FROM user"; $sql_query_worth = mysql_query($sq_l); while ($row = mysql_fetch_assoc($sql_query_worth)) { $dbusername = $row['username']; } echo $dbusername; } ?>

  Read the article

• how to change color of table view title

  - by madhavi

  hello, Can we change the color of the table view title the string which i am showing appears in gray color can we choose color for it .Is there any property of table view title i am not asking for table view header or footer i mean the title - (NSString *)tableView:(UITableView *)tableView titleForHeaderInSection:(NSInteger)section { // Keep space in the following line ........ DONT REMOVE return [NSString stringWithFormat:@"Select your service:"]; }

  Read the article

• How to deploy to Tomcat from NetBeans?

  - by deamon

  I've added Tomcat in the "Tools Servers" menu and as you can see it appears in the list of servers: But when I try to run my project, I cannot select Tomcat! The drop-down with servers is empty. I tried it with NetBeans 6.8 and 6.9 Beta. Any idea?

  Read the article

• How to translate this query:

  - by xRobot

  How can I translate this 2 queries in postgresql ? : . CREATE TABLE example ( id int(10) unsigned NOT NULL auto_increment, from varchar(255) NOT NULL default '0', message text NOT NULL, lastactivity timestamp NULL default '0000-00-00 00:00:00', read int(10) unsigned NOT NULL, PRIMARY KEY (id), KEY from (from) ) DEFAULT CHARSET=utf8; . SELECT * FROM table_1 LEFT OUTER JOIN table_2 ON ( table_1.id = table_2.id ) WHERE (table_1.lastactivity > NOW()-100);

  Read the article

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• Php + MySQL banner rotator by order

  - by ilnur777

  I have table with advertisement in MySQL. I would like to rotate banners by order (NOT RANDOM). What function or mechanism I need to SELECT advertisement from MySQL table to show it in order, like 1, then 2, then 3 ... then again 1,2,3... ?

  Read the article

• How to find out if a Java ResultSet obtained is empty?

  - by Bruce

  Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:userdata.db"); Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("SELECT * from table WHERE is_query_processed = 0;"); How can I find out if rs is empty?

  Read the article

• what's wrong with this function?

  - by Joann

  function get_ibo_id() { if($registerquery = $this->conn->query("SELECT ibo_id FROM fasttrack WHERE count < 8 && flag = 1 ")){ $this->increase_count(); while ($row = $registerquery->fetch_assoc()) { return $row[ibo_id]; } } else return "No id"; } it always enters the if block even if the condition is not satisfied... going crazy

  Read the article

• group member dropdown in visual studio 2008

  - by knittl

  in visual studio is the member dropdown, where you can select all members of the current type alphabetically ordered. is there an option which allows grouping of the members? i.e. all constructors before all methods before all properties before all events before all fields? if there is not, bad for me, i guess—it would really enhance productivity

  Read the article

• IEnumerable<string[]> => unique string's

  - by Maxim

  Hello! I have IEnumerable - that i recieved(converted) from dattabase. i need to select from this collection only unique strings. i suppose that i need to use linq group by string... please help.

  Read the article

• Django: GROUP BY two values

  - by AP257

  I would basically like to do the same as this question, but grouping by combinations of two values, rather than just one: SELECT player_type, team, COUNT(*) FROM players GROUP BY player_type, team; Does anyone know whether, and how, this is possible in Django? I'm using 1.2.

  Read the article

< Previous Page | 527 528 529 530 531 532 533 534 535 536 537 538  | Next Page >