Search Results

Search found 27691 results on 1108 pages for 'multi select'.

Page 674/1108 | < Previous Page | 670 671 672 673 674 675 676 677 678 679 680 681  | Next Page >

• 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

• Compare two table and find matching columns

  - by Karthick

  Hi, I have two tables table1 and table2, i need to write a select query which will list me the columns that exist in both the tables.(mysql) I need to do for different tables (2 at a time) Is this possible? I tried using INFORMATION_SCHEMA.COLUMNS but am not able to get it right.

  Read the article

• 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

• 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

• Function equivalent to sprintf() with maximum number of characters to be copied?

  - by Tommy

  function(char* name) { char sql[50]; sprintf(sql, "select %s;", name); } What's the best way to make sure only 50 chars of name are copied to sql in the case name is larger than what sql can hold? (sprintf with a N parameter?) Thank You.

  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

• 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

• 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

• LINQ Query and DateTimes....

  - by AlwaysBeCoding

  Im trying to get the Sum() from an Entityset with the next query. (from MyObject p in SelectedObject.MyObjectEntitySet where p.AColumn.HasValue && (p.ADate >= dateTimeValue && p.ADate <= dateTimeValue2) select p.AColumn.Value).Sum(); with no luck retrieving correct sum. Any Ideas?

  Read the article

• How to set selected a file in File browser in linux using terminal?

  - by EEE

  How can I open a file browser and set selected a specified file in linux by using command line? In windows I am able to do it by writing: explorer /select, c:\path\to\file

  Read the article

• equal insread of distinct

  - by MirooEgypt

  SELECT DISTINCT IncreasmentAmount, Name, regionid FROM Pricing.GroupOfRegions where regionid in (6,7) i have this result 12.80 AB 6 13.00 ABC 6 15.00 AC 6 12.80 AB 7 13.00 ABC 7 i wanna add more condition where IncreasmentAmount are equals which means i got the rows where regionid in (6,7) and have the same IncreasmentAmount so i got finally 12.80 AB 6 12.80 AB 7

  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

• [Linq to sql] query result what should i use Count() or Any()...

  - by Pandiya Chendur

  I am checking login of a user by this repository method, public bool getLoginStatus(string emailId, string password) { var query = from r in taxidb.Registrations where (r.EmailId == emailId && r.Password==password) select r; if (query.Count() != 0) { return true; } return false; } I saw in one of the previous questions !query.Any() would be faster... Which should i use? Any suggestion....

  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

• 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

• 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

• 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

• Create folder for todays date

  - by Ram

  Hi, I have a folder named as 2010. In this I want a folder for each month like "Jan10", "Feb10"....."Dec10" In each month folder I want to create folder for "Todays date" I have create a shortcut for that 2010 folder with Target as C:\WINDOWS\explorer.exe /n, /e, /select, F:\2010 I want a functionality that will execute when I click the shortcut for f:\2010 icon. Any pointer would be great help.

  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

• Python BeautifulSoup Parse String

  - by user1159901

  string = ' onchange="_Pd.passAttr(this.value,'size','p0_v0_bd');" Select </option> size 6 </option> size 7 </option> size 9 </option> ' I want to extract a list [size 6, size 7, size 8]. How to do and thanks!

  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

• 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

• 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

• 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

• 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

< Previous Page | 670 671 672 673 674 675 676 677 678 679 680 681  | Next Page >