Search Results

Search found 43978 results on 1760 pages for 'select case'.

Page 88/1760 | < Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >

• mysql select top users problem

  - by moustafa

  i have users table and i have posts table i want select from users the top users that have the big amount of posts from posts table and order them by numbers of posts i can make it by array_count_values() by i cant order it now i think if i make it by one mysql query by left and join will be more better table structure posts id | auther_id

  Read the article

• SQL Server Select Distinct

  - by homam

  I want to write a query like this: For a table that has these columns: ColA ColB ColC, ColD select first(ColA, ColB, ColC, ColD) distinct(ColB, ColC) from table order by ColD The query is supposed to order the table by ColD, then group the results by the combination of ColB and ColC (they may have different data types) and returns the first rows (with all the columns of the table) in the groups. How is it possible in MS SQL Server 2005?

  Read the article

• using XPath how to select elements with absent attribute

  - by Vincenzo

  I would like to select all elements that have certain attribute or don't have it at all: //job[@salary<"100" or !@salary] This code is not valid. Which one is? Thanks!

  Read the article

• jquery - How to select all content between two tags

  - by ed.talmadge

  I have a document with headings and unordered lists. How can I use JQuery to select a given heading (by its unique class name) AND all content between that heading and the next heading?

  Read the article

• SQL query for select distinct with most recent timestamp first

  - by Josh

  I have a mysql table with three columns: username, location, timestamp. This is basically a log of user activity of what location they are in and the time that they were there. What I want to do is select a distinct username+location where only the most recent item (by timestamp) is provided. So say the table consists of: tom roomone 2011-3-25 10:45:00 tom roomtwo 2011-3-25 09:00:00 tom roomtwo 2011-3-25 08:30:00 pam roomone 3011-3-25 07:20:23 I would want only these to be selected: tom roomone 2011-3-25 10:45:00 tom roomtwo 2011-3-25 09:00:00

  Read the article

• how to use conditional select query ? in sqlserver

  - by Arunachalam

  how to use conditional select query ? in sqlserver i have a column in which i store date type variable .now i should retrieve one value from that column and find the difference with the curent_timestamp and if the difference is less than 10 mins i should a return 1 and if more than 10 mins i should return 0.is it possible ? 05-12-2010 13.58.30 - 05-12-2010 13.56.30 here the difference is 2 so it should return 1 .

  Read the article

• iPhone: Getting the Touch Events of Built In "Copy", "Paste" and "Select All buttons"

  - by hardik

  hello all, I am a newbie in iPhone development. In my project there is one requirement that while editing text the iPhone's built in buttons Copy, Paste and Select all are available. I want the touch event on all these buttons and also want to display an action sheet title upon their respective touch events.

  Read the article

• [struts2, jsp] onchange not working for <s:select>

  - by Kevin

  I have something that looks like this: <s:select ... onchange="javascript:alert('testing')"/> But when I run it and look at using firebug, the onchange is not there and so the javascript is not executed. Any ideas? This is driving me nuts.

  Read the article

• How to select top n rows from a datatable/dataview in asp.net

  - by skamale

  How to select top n rows from a datatable/dataview in asp.net.currently I am using the following code by passing the table and number of rows to get the records but is there a better way. public DataTable SelectTopDataRow(DataTable dt, int count) { DataTable dtn = dt.Clone(); for (int i = 0; i < count; i++) { dtn.ImportRow(dt.Rows[i]); } return dtn; }

  Read the article

• How to programatically select all text inside a TinyMCE editor

  - by Edan Maor

  I'm looking for a way to programatically select all the content inside a TinyMCE editor instance. The reason I need this is that I'd like it if all the text inside the editor was selected, as soon as someone clicks on it (I'm using TinyMCE in conjunction with JEditable, by the way). Thanks, Edan

  Read the article

• SQL - Select all when filter value is empty

  - by iansinke

  I have a SQL query in my ASP.net web app that looks like this: SELECT * FROM [Records] WHERE ([title] LIKE '%' + @title + '%') @title, of course, is the value of a text box on the page. My question is, why, when the text box is empty, does this return nothing? And how can I make it return everything, like logic tells me it ought to?

  Read the article

• select, delete & update from multible tables using a single query in mysql

  - by mewis

  for example i use following command to find a record SELECT users.mail FROM users WHERE users.uid = %s if found an match, then i should like to delete this record, and update in the same query an another table. i can solve this with 'joins' ?

  Read the article

• Batch Select Sql in SQLite or SqlCE with C#

  - by David Osborn

  Is there anyway to batch two different select queries to either SQLite or SQLCE and get the two result sets back in C#? If not, is there an embedded database that handles this?

  Read the article

• SQL : Select a dynamic number of rows as columns

  - by Clint

  I need to select static colums + a dynamic number of rows as columns in SQL TABLE 1 ------- HotelID BlockID BlockName TABLE 2 ------- BlockDate (unknown number of these) NumberOfRooms Desired Result Row ------------------ HotelID | BlockID | BlockName | 02/10/10 | 02/11/10 | 02/12/10 | ...N Where the date columns are the unknown number of BlockDate rows.

  Read the article

• Struts2 using Map in select tag

  - by Chathuranga

  Hi all, You can easily use a List in struts2 select tag, but is there a way to use Map in tag?? If it is possible please provide a sample code... thanx !

  Read the article

• Adding a CSS class to the options tag inside a select wrapper w/ Rails

  - by Christian

  What if I need to add a class to the options tag? testme1 I haven't been able to do this. This is what I have <%= select(:user, :goalstext, Bodytarget.all.collect {|b| [ b.name, b.id ] }, {"class", "test"}, :class = "selected", :class = "selected") %

  Read the article

• MySQL - Select all as one string

  - by poru

  How could I select all as one string seperated with a ,? Example table: Table Stringtest Examplestring2 Anotherstring Otherstring And the selected result should be Stringtest,Examplestring2,Anotherstring,Otherstring.

  Read the article

• QT how to select and change all coulmns of QStandardItemModel

  - by user63898

  Hello im trying to programmatic select and change the background color of all the columns of QStandardItemModel i have this that paint me only the first column out of 5 that the row contains // getting the rows QStandardItem* standardItem = m_model->item(i); //set the color i like all the row to be painted standardItem->setBackground(QBrush(QColor(255,0,0)));

  Read the article

• How Do I Select for Multiple Classes Using Nokogiri and Ruby

  - by Russ Bradberry

  From a table element, I would like to select all rows that have the class even or the class odd. I tried the jQuery syntax: report.css("table.data tr[class~=odd even]").each{|line| parse_line_item(line)} but it threw an error, any help is appreciated, thanks.

  Read the article

• Transaction Isolation on select, insert, delete

  - by Bradford

  What could possibly go wrong with the following transaction if executed by concurrent users in the default isolation level of READ COMMITTED? BEGIN TRANSACTION SELECT * FROM t WHERE pid = 10 and r between 40 and 60 -- ... this returns tid = 1, 3, 5 -- ... process returned data ... DELETE FROM t WHERE tid in (1, 3, 5) INSERT INTO t (tid, pid, r) VALUES (77, 10, 35) INSERT INTO t (tid, pid, r) VALUES (78, 10, 37) INSERT INTO t (tid, pid, r) VALUES (79, 11, 39) COMMIT

  Read the article

• How to select records as columns in SQL

  - by Leigh

  Hi, I have two tables: tblSizes and tblColors. tblColors has columns called ColorName, ColorPrice and SizeID. There is one size to multiple colors. I need to write a query to select the size and all the colors (as columns) for a that size with the price of each size in its respective column. The colors must be returned as columns, for instance: SizeID : Width : Height : Red : Green : Blue 1---------220-----220----£15----£20-----£29 Hope this makes sense Thank you

  Read the article

• how to select all childs other than a element

  - by santose

  I have a element which contains 3 child. let says <div class="parent"> <div class="firstChild">firstChild</div> SecondChild <ul><li>thrid child</li></ul> </div> In the example I need to select first 2 childs and not the UL. how to do through jquery.

  Read the article

• Select in listview, to pass the index through to another form

  - by Luke

  I have a system where a listview is populated. I want to be able to select one of these files and press an edit button, which will then take the selected data into another form. I am trying to find a way to identify the selected item in the listview and take it to the next form. How can i achieve this? What code would I need to show? Thanks

  Read the article

• Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID

  - by Jian Lin

  Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID); ? The ( ) usually is for specifying grouping of something. But in this case, are we supposed to be able to use 2 or more field names... in the example above, it can be all clear that it is 1 field, is it just that the parser is not made to bypass the ( ) when it is all clear? (such as in the language Ruby).

  Read the article

• jquery select element inside a class

  - by Erwin

  Hi fellow programmer I want to select an anchor inside a div like this <div class="response content"> Disapproved Bank Mandiri<br><br> <p> <a class="showlist" href="#">Back to list?</a> </p> </div> What is the jquery to do this ?

  Read the article

< Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >