Search Results

Search found 7311 results on 293 pages for 'rows'.

Page 162/293 | < Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >

• MSYQL ~ Why does this query only select a single row?

  - by Joe

  SELECT * FROM tbl_houses WHERE (SELECT HousesList FROM tbl_lists WHERE tbl_lists.ID = '123') LIKE CONCAT('% ', tbl_houses.ID, '#') ^ It only selects the row from tbl_houses of the last occuring "tbl_houses.ID" inside tbl_lists.HousesList I need it to select ALL the rows where any ID from tbl_houses exists within tbl_lists.HousesList

  Read the article

• Troubleshoot div that won't stretch

  - by xain

  Hi, I have a web page that has several divs embedded and I'm having a problem when a table has too many rows; when it does, the containing div falls short and bottom ones are displayed on top of the background instead. Any hints on how to troubleshoot this ? I've tried setting several attributes to the different divs with no luck? Thanks in advance

  Read the article

• One table view cell/row bigger than others? (iphone, cocoa-touch)

  - by Jonathan

  I know it is possible to set the height of all rows in a UITable but is it possible to set one row to be bigger than the others. For example when the user touches on the cell with 2 fingers I want the cell to expand and show a description. But only that cell. Is that possible without overlapping the cells below it?

  Read the article

• sql delete from start

  - by Luke

  Is there anyway I can restrict the amount of rows allowed in a table to say 40, and then when 41st is added, the table deletes the first one?

  Read the article

• Getting dates based on week number

  - by meep

  Hello. I have some rows in my database that contains some dates. I need to select all dates based on a weeknumber, how is this possible?

  Read the article

• New help with SQL Server select statement

  - by gio_333m

  I need help with select statement in SQL Server / T-SQL My table looks like this: Id (int) QuestionId (int) GenreId (int) I want to select random N rows from this table so that maximum number of same GenreId in the result set is less than X for all GenreId-s except one. For that one GenreId, I need row count with that GenreId to be equal to Y.

  Read the article

• Getting screen height before first display?

  - by Mark

  Hi, I have a ListView. I populate it with 8 items, that's all that fits vertically on the G1. Some of my users are saying the Droid has a taller screen height, and so I can probably add one or two more items to the ListView to take up the additional space provided. How could I measure the available height the screen offers at startup, before the UI is displayed? If I see the height can fit more than 8 items, I'd like to add one or two more rows, Thanks

  Read the article

• R: optimal way of computing the "product" of two vectors

  - by Musa

  Hi, Let's assume that I have a vector r <- rnorm(4) and a matrix W of dimension 20000*200 for example: W <- matrix(rnorm(20000*200),20000,200) I want to compute a new matrix M of dimension 5000*200 such that m11 <- r%*%W[1:4,1], m21 <- r%*%W[5:8,1], m12 <- r%*%W[1:4,2] etc. (i.e. grouping rows 4-by-4 and computing the product). What's the optimal (speed,memory) way of doing this? Thanks in advance.

  Read the article

• limiting a query to a specific item

  - by Dev-Ria

  I have a db with thousands of domains and data. I want to list only 100 rows of each domain. i can't use LIMIT 100 cause that only limits 100 records but I want dom1 to list 100 dom2 to list 100 dom3 to list 100 all in one query. This is what I have so far. SELECT domain COUNT(Key) AS DomCount FROM table_domain GROUP BY user,location ORDER BY domain,DomCount DESC Could I use a CASE?

  Read the article

• Confused for creating Gtk+C Widget.

  - by PP

  I am really confused, I want to create one list that holds 2 Images and 2 labels as follows. +----------------------+ ROW1 |Image1 Image2 Lebel1 | | Lebel2 | +----------------------+ ROW2 |Image1 Image2 Lebel1 | | Lebel2 | +----------------------+ But i don't want it in a table/columns it should be simple selectable rows without any borders. Which widget i should use for this and how? Thanks, PP.

  Read the article

• What is the most efficient way to keep track of all user traffic inside a database

  - by Brendan

  Currently I am using mysql to log all traffic from all users coming into a website that I manage. The database has grown to almost 11m rows in a month, and queries are getting quite slow. Is there a more efficient way to log user information? All we are storing is their request, useragent, and their ip, and associating it with a certain website.

  Read the article

• How to set editable true for linktype column of gridview & how to set default value for diif types c

  - by Royson

  My gridview has link type column but am unable to edit it. how to edit such type of cell. Few more question i have i want to set checked to true for all rows in checkbox column. Also i want to set default value for combo box column Thanks

  Read the article

• How to get unmatched records using SQL query?

  - by Dev

  Actually if i am doing INNER JOIN of two tables then i will get all matched records from the two tables. But i want to get all the unmatched rows only. Is there any way to do that? Or Any JOIN available for that?

  Read the article

• Resize JTable in JScrollPane by dragging

  - by shuby_rocks

  Hello all, How can I implement the functionality of being able to resize a JTable by dragging a corner by mouse (to see more rows during a single view) which is embedded in a JScrollPane? Is their any other easy alternative way? Thanks a lot.

  Read the article

• SQL query to select records from three Tables seperatly

  - by Azhar

  SQL query which select the record from three tables and there is no relation between these tables. Actually I want to make it a VIEW. suppose there are three tales Table1, Table2, Table3 I want to show records of Table1 first with some filter criteria and then the records from Table2 and in last from Table3 as when we execute the view it show like the records like a Table. There can be any number of rows but the records must be in this sequence.

  Read the article

• reading from file

  - by lego69

  can somebody help me, how can I filter my file, inside the file I have rows with 3, 4, 5 elements, I want print using echo only these which have 5 elements, thanks in advance (I'm talkin about scripts)

  Read the article

• Shortest anagrams finder [C++]

  - by Cente

  Hey, take this as a challange, my informatics professor made it in less than 10 rows, it work perfectly and its very efficient. I'd like to "surprise" him giving a better/shorted version of it. Ofcourse i wouldn't take the credits, hah, u can trust in me. It's a simple anagras finder! If you can.. write it in c++! thanks!

  Read the article

• how to organize country data?

  - by fayer

  how do i organize country data (countries, states and cities etc) in mysql? cause every country has 3 tables: countries, states and cities. should i have each country in separate set of tables or should i have them all in these 3 tables? if i have all of them in same tables, im afraid that the amount of rows will be huge cause i tend to have a lot of countries! what is best practice for this?

  Read the article

• finding if an anniversary is coming up in n days in MySql

  - by user151841

  I have a table with anniversary dates. I want a query that returns me rows of anniversaries coming up in the next 10 days. For instance: birthdate --------- 1965-10-10 1982-05-25 SELECT birthdate FROM Anniversaries WHERE mystical_magical_mumbo_jumbo <= 10 +------------+ | birthdate | +------------+ | 1982-05-25 | +------------+ 1 row in set (0.01 sec) I'd like to keep the query in the form x <= 10, because I'll use that number 10 in other parts of the query, and if I set it to a variable, I can change it once everywhere by changing the variable, and not have to re-write the query.

  Read the article

• Not really a quaestion...but i need help

  - by Dan F.

  I have to make a process in Oracle/PLSQL.....i have to verify that the interval of time between start_date and end_date from a new row that i create must not intersect other start_dates and end_dates from other rows. Now I need to check each row for that condition and if it doesn't correspond the repetitive instruction should stop and after that to display a message such as "The interval of time given is not correct". I don't know how to make repetitive instructions in Oracle/PLSQL and I would appreciate if you would help me.

  Read the article

• How do I select count() and LIMIT?

  - by alex

  SELECT * FROM ...LIMIT 5, 10 But what if I want the total rows? I don't want to make another query without the limit.

  Read the article

• How do I delete every row except the last one for each day?

  - by A B

  I have a table with stock quotes that looks something like this: id, date, stock_id, value Every day has several rows for each stock_id (it is automatically updated every five minutes), so the table is rather big at the moment. How do i delete every row but the last one each day for every stock_id?

  Read the article

• How to get row by one column faster in C#?

  - by tomaszs

  I have a DataTable with column Value and column Name that has 30000 rows. Now i would like to get very fast Name from row that Value has specified. How to do this fast? I have like 40000 requests with various Values to this table.

  Read the article

• Write a JavaScript that accepts a number from the user using the “prompt” function

  - by A sw A

  Write a JavaScript that accepts a number from the user using the “prompt” function. Then it draws a table in the HTML document that has the user specified number of rows and columns. In each table data, it displays the result of the math operation (row raised to the power of column). For example, if the user enters the number 3, the JavaScript should draw the following table: 1 1 1 2 4 8 3 9 27

  Read the article

• Drupal - Break up content with different content (After every 12 products, show an ad?)

  - by kilrizzy

  Currently I have the homepage of a t-shirt site list a 4 column grid, each cell containing all the shirts on the website (using views). The client would like every few rows to display an ad (perhaps a random view/block item). Is this possible? I'm sure I will end up needing to set the grid display to something else but how could I program this in?

  Read the article

< Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >