Search Results

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

Page 26/943 | < Previous Page | 22 23 24 25 26 27 28 29 30 31 32 33  | Next Page >

• Converting SQL with subselect in select to HQL

  - by UltraVi01

  I have the following SQL that I am having problems converting to HQL. A NPE is getting thrown -- which I think has something to do with the SUM function. Also, I'd like to sort on the subselect alias -- is this possible? SQL (subselect): SELECT q.title, q.author_id, (SELECT IFNULL(SUM(IF(vote_up=true,1,-1)), 0) FROM vote WHERE question_id =…

  Read the article

• Select item in CascadingDropDown via JavaScript & invoke update

  - by akosch

  In code-behind I can do this to select something: // Select item in first DropDownList myCascadingDropDown_1.SelectedValue = itemValue_1+":::"+itemText_1; // Select item in second DropDownList myCascadingDropDown_2.SelectedValue = itemValue_2+":::"+itemText_2; How can I do this in JavaScript? (I'm aware, that I could search the list and…

  Read the article

• Drag and Drop Multiple select boxes

  - by Roland

  I have two multiple select boxes. I need to use JQuery to drag selected items from one combobox to the next. Is this at all possible? I need to drag items from this box <select id="select1" multiple=multiple> <option value="1">test1</option> <option value="2">test2</option> <option …

  Read the article

• select subquery cause mysql server to be unresponsive

  - by Xiao

  DELETE FROM item_measurement WHERE measurement_id IN ( SELECT (-id) AS measurement_id FROM invoice_item WHERE invoice_id = 'A3722' ) I've really tried hard to find what's wrong with the code. I tried to run this in a php page, which doesn't respond. I also tried the same line in phpmyadmin, infinite spinning circle…

  Read the article

• ORA-00937 error during select subquery

  - by RedRaven

  I am attempting to write a query that returns the the number of employees, the average salary, and the number of employees paid below the average. The query I have so far is: select trunc(avg(salary)) "Average Pay", count(salary) "Total Employees", ( select count(salary) from employees where salary < (select…

  Read the article

• change selects value onchange of another select

  - by Syom

  i start learning jquery few days ago, and i like it very much. but now i have a problem, that can't solve alone. i have two selects <select id="select1"> <option value="1">1day</option> <option value="2">2day</option> <option value="3">3day</option> </select> …

  Read the article

• Jquery select add values from json

  - by brabertaser1992

  I have such json: [ { "MOD_AXL": 0, "MOD_CDS_ID": 110000168, "MOD_CV": 0, "MOD_CV_CTM": null, "MOD_ID": 168, "MOD_MFA_ID": 514, "MOD_PC": 1, "MOD_PCON_END": 199007, "MOD_PCON_START": 196303, "MOD_PC_CTM": null, "Name": "2 CV"}, { "MOD_AXL": 0, "MOD_CDS_ID":…

  Read the article

• Jquey: select tag onchange function problem

  - by Syom

  i start learning jquery few days ago, and i like it very much. but now i have a problem, that can't solve alone. i have two selects <select id="select1"> <option value="1">1day</option> <option value="2">2day</option> <option value="3">3day</option>…

  Read the article

• Selecting Data from select tag

  - by user2610240

  i have to select data from select tag rather then selecting value as its selects value for default <select name="time" > <option selected="selected" >timings</option> <option value="155">9:00AM - 12:00PM</option> <option…

  Read the article

• question about random select

  - by davit-datuashvili

  here is code print number in decreasing order import java.util.*; public class select { public static void Select(int m,int n){ Random r=new Random(); if (m>0) if (r.nextInt(0x3fff8001) % n <m ){ System.out.println(n-1); Select(m-1,n-1); } else{ …

  Read the article

• Exim 4 pipe select command/script from mysql db

  - by axel.klein

  Is there an option to run a mysql lookup in the pipe driver of exim? MYSQL_Q_SCRIPT=SELECT script FROM MYSQL_EMAILTABLE WHERE domain='${quote_mysql:$domain}' AND local_part='${quote_mysql:$local_part}' command = "${lookup mysql {MYSQL_Q_SCRIPT}{$value} I am always…

  Read the article

• GRANT SELECT to all tables in postgresql

  - by Adam Matan

  Hi, Is there a one-liner that grants the SELECT permissions to a new user postgresql? Something that would implement the following pseudo-code: GRANT SELECT ON TABLE * TO my_new_user;

  Read the article

• Select a word using keyboard special case

  - by wataka

  I know the Ctrl+Shift+Arrow_Key to select a word. But suppose this is the case: "Hello!, my na|me is Peter" Where the cursor is where the pipe is. I'm looking for some keyboard shorcut that select the word "name". The only way I found was: Ctrl+Right, Left,…

  Read the article

• select just pasted text

  - by ldigas

  Pretty simple - how can one select just pasted text (after pasting it) ? I'm editing some files which are purely data, and I get "lost" sometimes ... so it would help if I could select it or somehow otherwise mark the text I've just pasted as to have a visual…

  Read the article

• Powershell: Select-Object with additional calculated difference value

  - by David.Chu.ca

  Let me explain my question. I have a daily report about one PC's free space as in text file (sp.txt) like: DateTime FreeSpace(MB) ----- ------------- 03/01/2010 100.43 DateTime FreeSpace(MB) ----- ------------- 03/02/2010 …

  Read the article

• jQuery + Jeditable - detect when select is changed

  - by Bryan Roth

  I'm using Jeditable for in-place editing. One the controls I am working with has the select type. When a user clicks on the field, the following select control is generated: <div id="status" class="editable_select"> <form> <select…

  Read the article

• If I select from an IQueryable then the Include is lost

  - by Connor Murphy

  The include does not work after I perform a select on the IQueryable query. Is there a way arround this? My query is public IQueryable<Network> GetAllNetworks() { var query = (from n in _db.NetworkSet …

  Read the article

• Best way to randomly select rows *per* column in SQL Server

  - by LesterDove

  A search of SO yields many results describing how to select random rows of data from a database table. My requirement is a bit different, though, in that I'd like to select individual columns from across random rows in the…

  Read the article

• MySQL Stored Procedures not working with SELECT (basic question)

  - by TMG

  Hello, I am using a platform (perfectforms) that requires me to use stored procedures for most of my queries, and having never used stored procedures, I can't figure out what I'm doing wrong. The following statement…

  Read the article

• JSON Select option question?

  - by user303832

  Hello,I wrote somethinh like this, `$sql = "SELECT * FROM dbase"; $strOptions = ""; if (!$q=mysql_query($sql)) { $strOptions = "<option>There was an error connecting to…

  Read the article

• How can i get rid of 'ORA-01489: result of string concatenation is too long' in this query?

  - by core_pro

  this query gets the dominating sets in a network. so for example given a network A<----->B B<----->C B<----->D C<----->E D<----->C D<----->E F<----->E…

  Read the article

• SQL Aggregate all Purchases for a certain product with same rebatecode

  - by debuggerlikeanother

  Hi SO, i would like to aggregate all purchases for a certain product that used the same rebatecode (using SQL Server 2005) Assume we have the following table: ID ProductID Product …

  Read the article

• oracle select query - index on multiple columns

  - by CC

  Hello. I'm working on a sql query, and trying to optimise it, because it takes too long to execute. I have a few select and UNION between. Every select is on the same table but with different…

  Read the article

• Require reasonably random results from an SQL SELECT query within a Joomla article (Cache enabled)

  - by Shrinivas

  Setup: Joomla website on LAMP stack I have a MySQL table containing some records, these are queried by a simple SELECT on the Joomla article, as pasted below. This specific Joomla website…

  Read the article

• PHP & MYSQL: How can i neglect empty variables from select

  - by cash-cash

  hello all; if i have 4 variables and i want to select DISTINCT values form data base <?php $var1 = ""; //this variable can be blank $var2 = ""; //this variable can be blank $var3 = "";…

  Read the article

< Previous Page | 22 23 24 25 26 27 28 29 30 31 32 33  | Next Page >