Search Results

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

Page 21/293 | < Previous Page | 17 18 19 20 21 22 23 24 25 26 27 28  | 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…

  Read the article

• Hide table rows except head

  - by Kemrop

  Without Jquery or any JavaScript library i need to hide the rows of a simple html table except for the table head on page load.

  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

• 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…

  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…

  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

• 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

• 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

• 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",…

  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' +…

  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

• 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

• Space Between Table Rows

  - by AGoodDisplayName

  This should be a simple problem, but I am have a tough time getting the html to display the way I want it... The problem is the space between my table rows...I don't want space between my rows. I just want my table to look like a spreadsheet with black borders. I am using a datalist and have a table in the datalist control's…

  Read the article

• dojox.grid.DataGrid can't display repeat rows?

  - by Robert

  We have a situation where we need to display data from a database in a grid which has repeat rows, but it seems at least the basic examples fail when the cell data is identical with Sorry, an error occurred. An example follows: <script dojo.require("dojo.data.ItemFileWriteStore"); …

  Read the article

• Disable rows in Flex DataGrid

  - by Christophe Herreman

  Unless I'm missing something obvious here, there is no way of disbabling one or more rows in a DataGrid. I would expect a disabledRows or disabledRowIndidices property on the DataGrid or List component but that doesn't seem to exist. I found a "rendererArray" property which is scoped to mx_internal and contains all…

  Read the article

• SQL..Sum two rows

  - by Cha

  Sample data: LOCATION NAME LABEL1 LABEL2 SERVICE TIME NY Andrew A B HOUSE 2555 NY Andrew A B CAR 35 NJ Copley C A HOUSE 1025 NY Copley A B HOUSE 650 VA Dalton D C PET 25 What I want to do…

  Read the article

• C#: Getting the number of rows/columns with ExcelPackage

  - by Napoli

  I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); using (ExcelPackage xlPackage = new ExcelPackage(newFile)) …

  Read the article

< Previous Page | 17 18 19 20 21 22 23 24 25 26 27 28  | Next Page >