Search Results

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

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

• MySQL: SUM in WHERE clause

  - by checcco

  Hi guys, I've got this table CREATE TABLE `subevents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(150) DEFAULT NULL, `content` text, `class` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM Each row can have a different value in the 'class' field. I'd like to select any number of rows, ordered randomly, as long as the sum of the values in the 'class' field is equal to 100. How could I accomplish it directly in the MySQL query without doing it later in PHP? Thanks everybody!

  Read the article

• MySql Not Like Regexp?

  - by KnockKnockWhosThere

  I'm trying to find rows where the first character is not a digit. I have this: SELECT DISTINCT(action) FROM actions WHERE qkey = 140 AND action NOT REGEXP '^[:digit:]$'; But, I'm not sure how to make sure it checks just the first character...

  Read the article

• Shell script that iterates through a sql "delete" statement

  - by ming yeow

  I need a shell script that deletes 1000 rows from a massive database until it is done. It is very simple, but i am very weak in shell scripting, and the many tutorials online offer extremely similar, but different nuances in syntax

  Read the article

• Storing Data In ViewState From DataTable And Want To Back To DataTable After Inserting One More Row

  - by Hardeep

  Hi I want to store data in viewstate from datatable and then want it back from viewstate to datatable. My problem: I m not able to add two rows in gridview from datatable. Plese ask for more information if not clear.

  Read the article

• [SQL server] How to insert artificial data into a select statement

  - by user149578

  Hi guys: Suppose we got a original query as follows: SELECT A, B, C FROM tblA Now, I need to additional artificial rows like SELECT 'Kyala', B, C FROM tblA when, for example, C = 100 to be inserted into the resultset. How could I achieve it using a single SQL instead of relying on table variable or temp table?

  Read the article

• Problem with sql like

  - by phenevo

  Hi, I'm writing sql query to my SqlCommand, and some part of them looks like: WHERE Path like N'+(select top 1 path from [Paths] where objectcode=@objectCode and objecttype=@objectType)+%' order by path desc,objecttype desc I get no records , bu when I wrote the same in sql server 2005 i have plenty rows... where path like (select top 1 path from [Paths] where objectcode='eg' and objecttype='0')+'%' order by path desc What's wrong ?? @objectType is 'eg'

  Read the article

• 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

• Get Row of DataGrid in User Control Page

  - by Romil

  My Question is related to access the rows in one page and putting conditions in another page. I need to check whether a datagrid has row in it or not. DataGrid is in .aspx page. Based on this checking i need to write a condition in .ascx page. the .ascx on which condition is checked is linked to .aspx page. Meaning that UserControl1.ascx is Register with Default.aspx page I am using VS 2003 Please advice Thanks

  Read the article

• Oracle Minus query. How can I get a result with NULLS if the top SQL and the bottom SQL don't contai

  - by George

  CREATE TABLE NewTable AS SELECT A,B,C FROM Table1 minus SELECT A, B, C From Table2 Create a new table with NULL values for column A when neither Table1 or Table2 had NULL values for this column. Yet, SELECT * FROM ( SELECT A,B,C FROM Table1 minus SELECT A, B, C From Table2 ) WHERE A IS NULL return 0 rows?

  Read the article

• Get insert statement query

  - by Karthick

  Hi, Is there a way to get the insert statements for a table via some query in MySql? for ex: if the table name is Cards,which has 5 rows, i need to get the insert statements for that particular table. Thanks.

  Read the article

• how to fit div into the corner

  - by user650749

  I have a div whose height span 2 rows. But I want to the following div fit into the bottom left and bottom right corner: http://jsfiddle.net/netnet/NNH6V/ before browse, please drag the splitter to left and you will see the checkbox2 and "2222222222" could be fit into bottom left and bottom right perfectly. I can use the relative position(.VerticalUp class). But the problem is it will leave a empty row underneath, which I don't want. Any idea?

  Read the article

• Multithreaded ActiveRecord requests in rspec

  - by jeem

  I'm trying to recreate a race condition in a test, so I can try out some solutions. I find that in the threads I create in my test, ActiveRecord always returns 0 for counts and nil for finds. For example, with 3 rows in the table "foos": it "whatever" do puts Foo.count 5.times do Thread.new do puts Foo.count end end end will print 3 0 0 0 0 0 test.log shows the expected query, the expected 6 times: SELECT count(*) AS count_all FROM `active_agents` Any idea what's going on here?

  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

• Unset an array element inside a foreach loop

  - by Summer

  I'm accessing an array by reference inside a foreach loop, but the unset() function doesn't seem to be working: foreach ( $this->result['list'] as &$row ) { if ($this_row_is_boring) { unset($row); } } print_r($this->result['list']); // Includes rows I thought I unset Ideas? Thanks!

  Read the article

• Alternative rowclasses in IE7 (richfaces)

  - by bananmuffins

  The use of rowClasses in a datatable with 2 different rowclasses renders successfully in FF,IE8,Opera,Safari but not in IE7. It defaults all rows to white background color. Is there any workaround for this ?

  Read the article

• how store date in mysql database?

  - by Syom

  i have date in dd/mm/yyyy format. how can i store it in databse, if i fant to do some operations on them after? for example i must find out the rows, where date > something what type i must set to date field? thanks

  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

• mysql: Can I use two "where"s? Like, "SELECT * FROM table WHERE something and something"?

  - by KeriLynn

  I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php): $query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')"; But I only want to select rows where the value for the column "category" equals "bracelet". I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

  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

• javascript validation: comparing 2 text box values

  - by coure06

  I have a table with 5 rows and 2 columns. Each cell contains a text box. I want to show error if one of the text boxes in each column is empty. I want both text boxes in a row shld be filled or both shld empty. How can i do this via Asp.net validation controls?

  Read the article

• Database with great read performance

  - by mscava

  I have 10 tables from which 4 contain each up to million rows. All values are inserted at once, and afterwards I only read the data many times. I am searching for a database that would perform greatly when it comes to selecting, joining or other reading etc. What is the most recommended option?

  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

• import utility in oracle

  - by Abhiram

  i do export of an tablespace. This tablespace contains table1 with two rows say rowa and rowb/ now i delete rowb and insert new rowc into this tablespace. Now i do import of this tablespace. after importing i see the table1 in tablespace contains rowa, rowb,rowc but it was suppose to contain rowa and rowb. Can anybody tell why is this happening so?

  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

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