Search Results

Search found 31129 results on 1246 pages for 'number of rows of tiles'.

Page 50/1246 | < Previous Page | 46 47 48 49 50 51 52 53 54 55 56 57  | Next Page >

• Update all table rows but top N in Mysql

  - by arthurprs

  I was trying to run the following query UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`='' WHERE `blog_post` NOT IN ( SELECT `blog_post` FROM blog_post ORDER BY `blog_post` DESC LIMIT 10) But Mysql doesn't allow 'LIMIT' in an 'IN' subquery. I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way. Thanks in advance.

  Read the article

• problem with selecting a rows in advanced datagrid using keydown event

  - by user365559

  Hi, I have advanced datagrid with list of items is displayed.I am using keydown for selecting the rows.But the actual problem is when i am selecting the items after the 2nd item it should move to the 3rd item but instead of that its moving back to the 1st item.I have defined selectionmode property to singlerows even then the result same to be same.can any one give me the soloution.

  Read the article

• SSIS Lookup component only returns matching rows when using partial mode

  - by Myat Htut

  I am attempting to use a lookup transformation in my data transformation package and all of the other lookup transformations went well but one component returns the matching rows only when I enable the partial cache mode. If I use the full cache mode, all data is routed to the error path. I am using SQL 2005 SSIS. Any help appreciated..

  Read the article

• How to filter rows on a complex filter

  - by dan

  I have these rows in a table ID Name Price Delivery == ==== ===== ======== 1 apple 1 1 2 apple 3 2 3 apple 6 3 4 apple 9 4 5 orange 4 6 6 orange 5 7 I want to have the price at the third delivery (Delivery=3) or the last price if there's no third delivery. It would give me this : ID Name Price Delivery == ==== ===== ======== 3 apple 6 3 6 orange 5 7 I don't necessary want a full solution but an idea of what to look for would be greatly appreciated.

  Read the article

• In R: How do I choose the first 4 Rows of a Data Frame

  - by Moe

  How Do I go about getting the first 4 rows of my Dataframe: Weight Response 1 Control 59 0.0 2 Treatment 90 0.8 3 Treatment 47 0.1 4 Treamment 106 0.1 5 Control 85 0.7 6 Treatment 73 0.6 7 Control 61 0.2 In 'R'?

  Read the article

• Getting the current item number or index when using will_paginate in rails app

  - by Rich

  I have a rails app that stores movies watched, books read, etc. The index page for each type lists paged collections of all its items, using will_paginate to bring back 50 items per page. When I output the items I want to display a number to indicate what item in the total collection it is. The numbering should be reversed as the collection is displayed with most recent first. This might not relate to will_paginate but rather some other method of calculation. I will be using the same ordering in multiple types so it will need to be reusable. As an example, say I have 51 movies. The first item of the first page should display: Fight Club - Watched: 30th Dec 2010 Whilst the last item on the page should display: The Matrix - Watched: 3rd Jan 2010 The paged collection is available as an instance variable e.g. @movies, and @movies.count will display the number of items in the paged collection. So if we're on page 1, movies.count == 50, whilst on page 2 @movies.count == 1. Using Movie.count would give 51. If the page number and page size can be accessed the number could be calculated so how can they be returned? Though I'm hopeful there is something that already exists to handle this calculation!

  Read the article

• How to enumerate returned rows in SQL?

  - by SilentGhost

  I was wondering if it would be possible to enumerate returned rows. Not according to any column content but just yielding a sequential integer index. E.g. select ?, count(*) as usercount from users group by age would return something along the lines: 1 12 2 78 3 4 4 42

  Read the article

• JDBC resulset total rows

  - by Zeeshan

  I am implementing Paging in my application. For this i run a query and get a resultset. Now i want to get total no of records in this resultset for my paging calculation. How can i get ? i dont want to execute a extra sql which gives me total rows

  Read the article

• Find amount of updated rows in T-SQL

  - by Alex

  I need to find the amount of updated rows UPDATE Table SET value=2 WHERE value2=1 declare @aaa int set @aaa = @@ROWCOUNT It doesn't work. How can I do that?

  Read the article

• Best way to fetch last 4 rows from a result set using mysql

  - by PHP-Prabhu

  Can any one please let me know, that, i need to fetch last 4 rows from a result-set using mysql. The result-set returns totally 6 records. but, i need the records to be fetch from last4...i.e, Record-3 Record-4 Record-5 Record-6

  Read the article

• Gridview rows blinking

  - by Bhavi

  Hi, I tried blink the rows of ASp:Gridview. Have succeded in IE but not working in FF and safari. FF error console says "Error: gridRef.childNodes is not a function" Can anybody tell me where exactly I am wrong... The Javascript used is: '); for (var i=0; i and on my gridview_rowdatabound I have e.Row.Attributes.Add("blinkingRow", "Y");

  Read the article

• classic asp delete rows and columns from an excel file

  - by rdm

  Hi, how can I remove specific rows and columns from an excel file using only classic ASP? For example, given the excel file col1 col2 col3 one two three four five six I want to be able to programmatically delete the first row and second column to produce one three four six Thanks!

  Read the article

• Invert WPF GridView to bind items to columns instead of rows

  - by emddudley

  Is there a simple way to invert a WPF GridView so that items are bound to columns instead of rows? Or would it be necessary to write a custom view mode?

  Read the article

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  Read the article

• Coding alternative shaded rows?

  - by ming yeow

  I want alternative rows in my table to be shaded. what is the best way to do this, javascript, rails? Today, i do a simple <% num % 2%, but this is such a common operation that i think there should be a smarter way to do it

  Read the article

• fetching only new rows from mysql with jquery ajax

  - by testkhan

  i have a table named news with 3 fields i.e (id, news, time) and i have a setInterval after every 3mints to fetch news from google or any news site .... now i want to fetch only new rows inserted after every 5 minutes...with jquery $.ajax()...how can i do that... do i reload the whole table or there is a way to fetch only the new ones...

  Read the article

• finding total no of rows in the textbox

  - by picnic4u

  how can i get the no. of rows in the multilines textbox through javascript function if some body inserted many no of text in that textbox

  Read the article

• Getting all rows from a Table where the column contains only 0

  - by Auro

  I got a little problem i need a sql query that gives all rows back that only contains 0 in it. the column is defined as varchar2(6) the values in the column looks like this: 0 00 00 100 bc00 000000 00000 my first solution would be like this: Oracle: substr('000000' || COLUMN_NAME, -6) = '000000' SQL Server: right('000000' + COLUMN_NAME, 6) = '000000' is there an other way? (it needs to work on both systems)

  Read the article

• Add rows to tables in Settings bundle?

  - by cannyboy

  Certain settings in the Settings app allow you to add rows to tables within the interface (for instance, within the Mail settings you can add accounts) Is this done with a settings bundle? How is this done?

  Read the article

• how to select rows from table.

  - by Ayyappan.Anbalagan

  my table contains category_name and parent_category_Id column My parent_category data contains, the same table primary key id. i need to select the all rows and insted my parent_category_Id i need to select the catogry_name

  Read the article

• Check if last characters of an NSString are numbers.

  - by Michael Matheus

  Is it possible to see of a string ends with a number which length is not known? "String 1" - 1 "String 4356" - 4356 "String" - nil If so, how can I determine that number?

  Read the article

• Formatting Numbers as Strings with Commas in place of Decimals

  - by DaveDev

  I have the following number: 4.3 I'd like to display this number as 4,3 for some of our European friends. I was under the impression that the following line would do the trick: string ret = string.Format("{0:0,0}", 4.3); // returns "04", not "4,3" Am I using the incorrect string?

  Read the article

• Detect iphone region

  - by camilo

  Hi. In my app, the user is supposed to insert a phone number, which is then displayed somewhere else. In the contacts application, when displaying a phone number, it automatically appears in the format of the language selected by the user. Is there a way to do this automatically, or a way to detect the region and then adapt the displayed string?

  Read the article

• Linux command line script to renumber files backward

  - by Donnied

  I have JPG files numbered 3006-3057 that I would like to reverse number. I would be content renaming them by adding a backwards number count to the beginning of the name: img_3006.jpg 99_img_3006.jpg and img_3057.jpg 48_img_3057.jpg.

  Read the article

• help with number calculation algorithm [hw]

  - by sa125

  Hi - I'm working on a hw problem that asks me this: given a finite set of numbers, and a target number, find if the set can be used to calculate the target number using basic math operations (add, sub, mult, div) and using each number in the set exactly once (so I need to exhaust the set). This has to be done with recursion. So, for example, if I have the set {1, 2, 3, 4} and target 10, then I could get to it by using ((3 * 4) - 2)/1 = 10. I'm trying to phrase the algorithm in pseudo-code, but so far haven't gotten too far. I'm thinking graphs are the way to go, but would definitely appreciate help on this. thanks.

  Read the article

< Previous Page | 46 47 48 49 50 51 52 53 54 55 56 57  | Next Page >