Search Results

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

Page 545/943 | < Previous Page | 541 542 543 544 545 546 547 548 549 550 551 552  | Next Page >

• How to know device/emulator layout (landscape/portrait) is changed

  - by android_novice

  I am using two xml layout file layoutPotrait.xml and layoutLandscape.xml.When device/emulator is in portrait mode i want to select layoutPortrait.xml and vice versa.How can i acheive this ? Thanks.

  Read the article

• numeric choice field:How to let the user set a value by incrementing/decrementing the displayed valu

  - by con_9

  Hi,I have a range say,1-100 and i want the user to select a value from this range.Ofcourse showing this with a spinner will be awful.I want to use the functionality of date widget,where we can pick a date by pressing a +/- sign,the longer the press ,higher the iteration speed. I found numberpicker.java that has the code the date widget uses to get this functionality, but do i have to paste that entire code to achieve this functionality!

  Read the article

• sql 2008 query. I am trying to correct this error message

  - by getbruce

  What is wrong with this code? What would be the correct syntax? SELECT EmployeeID, SUM('More than 2 orders') FROM Orders WHERE EmployeeID 2 GROUP BY EmployeeID Msg 8117, Level 16, State 1, Line 1 Operand data type varchar is invalid for sum operator.

  Read the article

• generating random enums

  - by null_radix

  How do I randomly select a value for an enum type in C++? I would like to do something like this. enum my_type(A,B,C,D,E,F,G,h,J,V); my_type test(rand() % 10); But this is illegal... there is not an implicit conversion from int to an enum type.

  Read the article

• How To Get YEARWEEK() To See Sunday As The Start Of The Week?

  - by tan

  I'm trying to get the YEARWEEK function to see Sunday as the 1st day of the week. An example date is: Sunday 1st Mar 2009 Here is my sql SELECT YEARWEEK('2009-03-01') and the result is - 200909 Which is week 9. I believe it is telling me this is week 9 because it sees the sunday as the last day of the previous week. How would I get this function to see sunday as the 1st day of the week and therefore return as week 10?

  Read the article

• Why does this sql code give error 1066 (Not unique table/alias: ‘customer)?

  - by aadersh patel

  SELECT customer.id, customer.firstName, account.id FROM customer, account INNER JOIN customer ON customer.id = account.customerId ORDER BY customer.id appologies for the poor editing...

  Read the article

• help for a query

  - by stighy

  Hi, i've a problem for a table update. follow table structure: Table1 tableid ... ... productID_1 productID_2 productID_3 Table2 productID Total I've to totalize each product in table2. For example: SELECT COUNT(*) as tot, ProductID_1 FROM Table1 GROUP Table1 then the UPDATE table2 SET total =..??? (how can i do) WHERE productID_1 = .... Hope you can help me. Thank you

  Read the article

• jquery quering the database

  - by mazhar

  the thing is that there are number of items in the html select list,what i want to do is to click on any of the item, then query the database on the id of that item. retrieve the value and then display that in the textbox, how would i query the database? I would really appreciate that if someone provides the code sample for querying the database

  Read the article

• How to escape LIKE %$var% with Doctrine?

  - by Peter Smit

  I am making a Doctrine query and I have to do a wildcard match in the where clause. How should I escape the variable that I want to insert? The query I want to get: SELECT u.* FROM User as u WHERE name LIKE %var% The php code until now: $query = Doctrine_Query::create() ->from('User u') ->where(); What should come in the where clause? The variable I want to match is $name

  Read the article

• Check Directories in C# using Linq

  - by pm_2

  Can someone tell me what I'm doing wrong with the following Linq query? I'm trying to find the directory with the highest aphanumerical value. DirectoryInfo[] diList = currentDirectory.GetDirectories(); var dirs = from eachDir in diList orderby eachDir.FullName descending select eachDir; MessageBox.Show(dirs[0].FullName);

  Read the article

• How do i insert 1000 times in one statement? with SQLITE?

  - by acidzombie24

  I want to fill this table with 10000000 values but first i want only 1000. I tried this in sqlite database browser but 3 isnt inserted unless i drop everything after it. But more importantly i dont know how to have num go from 1 to 1000. create table if not exists test1(id integer primary key, val integer); insert into test1(val) select '3' as num where num between 1 and 1000

  Read the article

• Selector for a range of ids

  - by Kiffin

  I need to select all span tag elements within a div with an id list_{[0-9]}+ having the following form: <div id="list_1234" ...> <!-- can be nested multiple levels deep --> ... <span class="list_span">Hello</span> </div> How can I do that, e.g. without using jQuery? Is that possible?

  Read the article

• Android Password GUI

  - by ranjanarr

  I am looking for Android GUI which is wheel type number lock, with numbers on the wheel. The password GUI looks like a wheel with numbers on it and user can roll the wheel to select a number when wheel stops, only the numbers are visible that are on the surface of wheel.

  Read the article

• Selecting min date excluding 0000-00-00

  - by nsw1475

  I am running a query in SQL, and I need to select a minimum date that is not 0000-00-00. Is there any way to exclude this value and choose the next minimum date?

  Read the article

• jQuery(formElement).val(null) : inconsistent results in different browsers

  - by Shehi

  Code is here: http://jsfiddle.net/jf7t2/1/ Please run it on the latest versions of all browsers, and see for yourself. When the button is clicked, on: on Chrome (and Safari of course) it just doesn't select anything, instead creates some ghostly empty option on Firefox and Opera, it works the way I expect and want it to work, resets the element value on Explorer, it does nothing So, which one is expected behaviour? Thanks.

  Read the article

• What does this query mean?

  - by zihado

  I'm reading a book about SQL. In that book, I saw strange query below: SELECT * into mycustomer from customer WHERE 1=2 In this query, what is "WHERE 1=2" ?

  Read the article

• What does the below query explain?

  - by Parth

  What does the below query explain? SELECT * FROM `jos_menu` WHERE (id = 69 OR id = 72) I know its very silly question, but sometimes easy things creates mess in my skulls interpreter.. Pls help EDIT Its giving me record for both IDs, why is it doing so? It should five me the record for either 69 or 72....

  Read the article

• Should I use AJAX or get every data beforehand

  - by rix501

  I have a web app where I need to change a drop down list dynamically depending on another drop down list. I have two options: Get all the data beforehand with PHP and "manage" it later with Javascript. Or get the data the user wants through AJAX. The thing is, that the page loads with all the data by default and the user can later select a sub category to narrow the drop downs. Which of the two options are better (faster, less resource intensive)?

  Read the article

• MySQL 'user_id' in where clause is ambiguous problem

  - by HoMe

  How can I correct the problem I keep getting from the code below which states 'user_id' in where clause is ambiguous. Thanks for the help in advance. Here is the mysql table. SELECT user.*, user_info.* FROM user INNER JOIN user_info ON user.user_id = user_info.user_id WHERE user_id='$user_id'

  Read the article

• hibernat createSQLQuery use CacheQuery?

  - by cometta

  Query query=getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery( "select... getHibernateTemplate().setCacheQueries(true); List result= query.list(); getHibernateTemplate().setCacheQueries(false); return result; may i know when i do manual "createSQLQuery" how to use cacheQuery? the above doesnt cache the result. show_sql still showing every request get from database

  Read the article

• Check value existance while performing a UPDATE query

  - by nimo

  Hi, I need to perform a simple update query where the update should only be done, if there is no value with updating value (item_name). For example, DB table [item_types] item_id(PK) | item_name Assuming there exist item_id with 6, My attempt is UPDATE item_types as k SET k.item_name = 'item_1' WHERE NOT EXISTS (SELECT * FROM item_types as a WHERE a.item_name = 'item_1') AND k.item_id = '6' But this gives me error "You can't specify target table 'k' for update in FROM clause" Could you please explain the error here and how can I achieve this ? Thank you

  Read the article

• PHP forms $_GET and $_POST methods

  - by user294705

  After I select the checkbox and press the button, the result data should display in the other page.I need to know the way I do this in php. My querry is working fine in the database and It shows the results.Now I need to display those results in the other page after selecting the first page checkbox and button(relevent to that checkbox).

  Read the article

• [Linq-To-Sql]How to return two values of different datatypes?

  - by Pandiya Chendur

  Here is my repository method which returns UserId , public IQueryable<int> getLoginStatus(string emailId, string password) { return (from r in taxidb.Registrations where (r.EmailId == emailId && r.Password == password) select r.UserId); } How to return UserName which is a string along with UserId... Any suggestion?

  Read the article

• sql clarification

  - by JPro

  Can anyone please clarify what this query will return ? SELECT TestCase FROM MyTable WHERE Verdict = 'PASS' AND StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTH)

  Read the article

• sql query help join (i think)

  - by milan

  I am having trouble figuring our how I can get results only when products.published, product_types.published, and product_cats.published = 1 but my query isn't working. Please help: SELECT `products`.`title`, `products`.`menu_id`, `products`.`short_description`, `products`.`datasheet_icon`, `products`.`datasheet`, `products`.`ordering`, `products`.`product_type_id`, CASE WHEN CHAR_LENGTH(`products`.`alias`) THEN CONCAT_WS(':', `products`.`id`, `products`.`alias`) ELSE `products`.`id` END AS slug FROM `products`, `product_cats`, `product_types` WHERE `products`.published=1 AND `product_cats`.published=1 AND `product_types`.published=1 AND `products`.`product_cat_id`='42' AND `product_types`.`id` IN (1,40,48,49,50) GROUP BY `products`.`id` ORDER BY `product_types`.`ordering`, `products`.`ordering`

  Read the article

< Previous Page | 541 542 543 544 545 546 547 548 549 550 551 552  | Next Page >