Search Results

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

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

• is it possible in javascript to create shortcuts with sequence like 123,345 instead of combo?

  - by frankB

  I already used some script to implement the shortcuts in my web page but i was wondering if could be possible to associate some combination not syncronic like Ctrl+X but more like a sequence typing 1..2..3 or any other combination to execute a script... lets assume this example: you have a long list with numbers: you could type 3..5...6, so you can go to the item 356 passing trough the item 3 then 35 then 356 more or less like when you type while selecting a select box i hope it was clear, id not easy to explain...

  Read the article

• Create ActiveRecord migration then edit in one step?

  - by geosteve

  I find myself doing this a lot: script/generate migration my_new_migration .. then select & copy the generated filename, then paste it into vi to actually write the migration. Is there any way to do this in one step? i.e. when the script/generate migration runs, it creates the file the automatically opens that file in an editor? (I'm working in an SSH terminal window on linux..)

  Read the article

• type casting in mysql

  - by muralikalpana

  i have passportno(varchar) in database. i am entering values like this 001,002,003. and i want to display like sorting order. now i wrote query like this "select * from passport_registration where status=1 ORDER BY passportno" then displaying output like this......077,088,099,100,1000,1001,1009,101,1010 i want to diplay sort order. how to do?

  Read the article

• Difference between dates when grouping in SQL

  - by CeejeeB

  I have a table of purchases containing a user_id and a date_of_purchase. I need to be able to select all the users who have made 2 purchases within 12 months of each other. The dates can be any point in time as long as they are less than 12 months apart. e.g. user_id date_of_purchase 123 01/Jan/2010 124 01/Aug/2010 123 01/Feb/2010 124 05/Aug/2008 In this example i want user_id 123

  Read the article

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• Refresh Service List of a paired Bluetooth device !

  - by sas-san

  Hi- Is there any possibility to refresh the service list of a paired device in a programm? At the moment, i have to go to the bluetooth options and select the device properties of the bluetooth device and have to refresh the service list manually. Is there any API that RIMM provides to do programmatically? thanks,

  Read the article

• How do I Increase cell value in Excel using VBA? Error: Type mismatch

  - by John

  I'm writing a macro, but because I'm working for first time in vb, I faced problems. My code: Cells (1, 1).Select Dim tempvar As Integer tempvar = Val(Selection.Value) // error Selection.Value = tempvar + 1 What my code should be: Cells(1,1).Value+=1 I get error "type mismatch". How do I accomplish that?

  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

• Calculating average (AVG) and grouping by week on large data set takes too long

  - by caioiglesias

  I'm getting average prices by week on 7 million rows, it's taking around 30 seconds to get the job done. This is the simple query: SELECT AVG(price) as price, yearWEEK(FROM_UNIXTIME(timelog)) as week from pricehistory where timelog > $range and product_id = $id GROUP BY week The only week that actually gets data changed and is worth averaging every time is always the last one, so this calculation for the whole period is a waste of resources. I just wanted to know if mysql has a tool to help out on this.

  Read the article

• How can I get the element wich currently has focus with jquery?

  - by eugene y

  I need to select the input element which has focus (or filter a set of input elements). How can I do this using jQuery?

  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

• 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 translate this 2 queries from Mysql to Postgresql? :

  - 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; Query: 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

• How do I modify the hundards of records based on my query result?

  - by Nano HE

  Hi, I inserted some error record to my table, I can query via the sql below and found hundards of record marked with half. SELECT * FROM `marathon` WHERE gender = 'male' && distance = 'half'; How to write a SQL then I can modify the result rows distance from 'half' to 'full'. Thank you.

  Read the article

• jQuery - Display the value of a textbox and input the value to another

  - by user1128694

  Basically I want to get the value of a textbox which is to select a date and output the value that is selected to another textbox. These textboxes are on the same page (different steps of the same page) and the document is loaded when the page is ready on click of the next step, I've tried using: $('#TextBox1').val($('#TextBox2').val()); But this doesn't seem to be working. What is it I am doing wrong?

  Read the article

• error with linq join

  - by Luca Romagnoli

  I have this linq query: var segreterie = from s in db.USR_Utenti join h in db.USR_Accounts on new {s.ID, settings.GruppoSegreteria} equals new {h.USR_UtentiReference,h.ID_Gruppo} select s; that has this problem: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'. how can i do to solve it?

  Read the article

• How to user IN operator in Linq?

  - by Umapathy

  Query: Select * from pu_Products where Part_Number in ('031832','027861', '028020', '033378') and User_Id = 50 and Is_Deleted = 0 The above mentioned query is in SQL and i need the query might be converted into Linq. Is there any option using the "IN" operator in Linq?. can you convert above mentioned query into Linq?

  Read the article

• Need cursor position at the end of the text

  - by user281947

  I have a composite combobox control (textbox and a listbox): Initially I have the cursor on the start, but when I select an item from the listbox and it gets displayed on the textbox then also the cursor remains at start position. I want the cursor to be at the end. Please suggest/help.

  Read the article

• How to get all elements inside "div" that starts with a known text

  - by misha-moroshko

  Hello, I have a div element in HTML document. I would like to extract all elements inside this div that starts with a known text (e.g. "q17_"). How can I achieve this using JavaScript ? (If needed, for simplicity, I can assume that all elements inside the div are of type input or select.) Thanks !

  Read the article

• self join table

  - by San82moon

  HI, i have a table, new_id----old_id----created_on 1234------5678------20100912 5678------3456------20100808 etc. i wrote this query, $q = "select event1.new_id, event1.old_id, event1.created_on,event2.new_id, event2.old_id, event2.created_on FROM replaced_isbns event1 JOIN replaced_isbns event2 ON event2.new_id = event1.old_id WHERE event1.new_id='$id'"; but i get result as 5678 - 1234, ie only one row, i want all rows... plz help me. Thanks, SLC

  Read the article

• Can I get the full query that a PreparedStatement is about to execute?

  - by ufk

  I'm working with PreparedStatement with MySQL server. example: String myQuery = "select id from user where name = ?"; PreparedStatement stmt = sqlConnection.prepareStatement(myQuery); stmt.setString(1, "test"); stmt.executeQUery(); ResultSet rs = stmt.getResultSet(); How can I receive the full SQL query that is about to be executed on the MySQL server? thanks!

  Read the article

• SHBrowseForFolder and shortcuts

  - by Lyndsey Ferguson

  In my C++ Windows application, I have a function that is supposed to allow the end-user select a folder. I'm using SHBrowseForFolder and it is working fine except that folder shortcuts are not being displayed in the dialog. Does anyone know if it is possible to configure SHBrowseForFolder so that the end-users will be able to navigate folder shortcuts?

  Read the article

• mysql :ordering table with day names

  - by Meko

  Hi.I am trying to get day of names with and correct order like Monday ,Tuesday.. But in my table I have records that after Monday comes Friday or I have Thursday between two Tuesday .I want to order them like Monday ,Monday ,Tuesday ,Tuesday, Wednesday so on .But I don`t want to group them. I used this query but it does not make order select Day_Name from mydb.schedule where Room_NO=(510) And Week_NO =(1) it outputs Monday Monday Tuesday Wednesday Wednesday Tuesday Thursday Thursday Thursday how can I correct it?

  Read the article

• Access database query locks ability to edit table?

  - by Sattvic

  I created a query in Microsoft Access like the one below: SELECT Deliverables.ID, Deliverables.Title, Deliverables.Summary, Deliverables.Header_Code, Deliverables.Header_Code.Value, Deliverables.Sort_order, Deliverables.Pillar, Deliverables.Pillar.Value, Deliverables.Misc_ID FROM Deliverables WHERE (((Deliverables.Pillar.Value)="Link Building")); But my problem is that this query locks my fields and I cannot make changes to the table using the query view. Any suggestions? I am using Microsoft Access 2007

  Read the article

• PHP Code Problem...

  - by aamir Fayyaz

  function check_login($array_val) { $strQury = "Select * from tblsignup where usr_email ='".$array_val[0]."' and usr_password = '".$array_val[1]."'" ; $result = mysql_query($strQury); $row_user = mysql_fetch_array($result); if(mysql_num_rows($result)>0) { $msg = "true"; } else { $msg = "false"; } return $msg ; } The return value is Object id #1true???? what is object id#1?

  Read the article

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