Search Results

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

Page 155/293 | < Previous Page | 151 152 153 154 155 156 157 158 159 160 161 162  | Next Page >

• how to find duplicated field values and delete them in mysql

  - by Mac Taylor

  Consider we have a field named (username) in our table named (tpl_users), now this table has lots of duplicated rows I wrote this code to delete duplicated usernames: Delete FROM tpl_users WHERE username = username; How is it possible to delete duplicated usernames?

  Read the article

• MySQL MATCH AGAINST functionality....

  - by Webnet

  Currently I have the following query... SELECT id, LOWER(title) as title, LOWER(sub_title) as sub_title FROM ebay_archive_listing WHERE MATCH(title, sub_title) AGAINST ("key" IN BOOLEAN MODE) However it is not finding rows where the title contains the word "key". "key" is generated dynamically based on a set of keywords, so sometimes it contains + and - symbols.

  Read the article

• Can I optimize this at all?

  - by Moshe

  I'm working on an iOS app and I'm using the following code for one of my tables to return the number of rows in a particular section: return [[kSettings arrayForKey:@"views"] count]; Is there any other way to write that line of code so that it is more memory efficient? EDIT: kSettings = NSUserDefaults standardUserDefaults. Is there any way to rewrite my line of code so that whatever memory it occupies is released sooner than it is released now?

  Read the article

• How to use DataPager with Database Paged

  - by Fujiy

  I am using ListView/DataPager. For performance reasons I page my results at database, using ROW_NUMBER(SQl2005). At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?

  Read the article

• jQgrid: multiple column row headers

  - by Jonathan

  I am trying to extend my jQGrid to have multiple rows for the header. It will look something like this ----------------------- Level 1 - > | Application | ----------------------- Level 2 - > |Code | Name | ----------------------- | 0002827| Mobile Phone1 | 0202827| Mobile Phone2 | 0042827| Mobile Phon3e | 0005827| Mobile Phone4 | 0002627| Mobile Phon5e | 0002877| Mobile Phone6 | 0002828| Mobile Phone7 I am wondering how to do this with jQGrid 3.8.2? Any ideas?

  Read the article

• mySQL Inconsistent Performance

  - by Jon Hatfield

  Hi, I'm running a mySQL query that joins various tables of 500,000+ rows. Sometimes it takes a second, other times around 15 seconds! This is on my local machine. I have experienced similarly varied times before on other intensive queries, does anyone know why this is? Thanks

  Read the article

• SQL Server 2005 Partition Over Date Range

  - by zimdanen

  Is there a way in SQL Server to parition over a date range? I'm looking for something along these lines: SELECT ROW_NUMBER() OVER (PARTITION BY RANGE(DateTimeField) INTERVAL(1)) I want to group rows that are within one day of each other.

  Read the article

• To get data from table in script from sql server 2005

  - by Zerotoinfinite

  Hi Experts, I am using sql server 2005 I have a table [say tblHistory] and this table contains 100 rows. I have created the same table at the server, but the table doesn't have the data, I want data from tblHistory to convert into INSERT INTO tblHistory ------ so that I could run the script on the server to fill the database. Please help, it's urgent

  Read the article

• return list from view to controller via viewmodel

  - by user232076

  I have a controller that takes in a viewmodel and submitbutton public ActionResult AddLocation(AddLocationViewModel viewModel, string submitButton) My view is bound to the viewmodel. The viewmodel contains a list objects used to create an html table with checkboxes. Is there a way to access the selected "rows" through the viewmodel in my controller? So that I can iterate through and get the selected items? Thanks LDD

  Read the article

• mysql delete and foreign key constraint

  - by user121196

  I'm deleting selected rows from both table in MYSQL, the two tables have foreign keys. delete d,b from A as b inner join B as d on b.bid=d.bid where b.name like '%xxxx%'; MYSQL complains about foreign keys even though I'm trying to delete from both tables: Error: Cannot delete or update a parent row: a foreign key constraint fails (yyy/d, CONSTRAINT fk_d_bid FOREIGN KEY (bid) REFERENCES b (bid) ON DELETE NO ACTION ON UPDATE NO ACTION) what's the best solution here to delete from both table?

  Read the article

• sql query to replace a blank cell with any text in access 2007 column

  - by silverkid

  I have an access table which has some cells as blank ( no data ) in a particular column. how i write an sql query to replace a blank cell with any text in access 2007 column any help appreciated. i have already tried the sql query update tableA set colA = 'abc' where ISNULL(colA); It updates 0 rows.

  Read the article

• TypeError when applying a textarea's value to a variable

  - by Espresso

  JavaScript var textarea = document.getElementById("textarea").value; HTML <textarea id="textarea" cols="100" rows="10">du hello!</textarea>

  Read the article

• Jquery toggle input disabled attribute

  - by Tommy Arnold

  here is my code $("#product1 :checkbox").click(function(){ $(this) .closest('tr') // find the parent row .find(":input[type='text']") // find text elements in that row .attr('disabled',false).toggleClass('disabled') // enable them .end() // go back to the row .siblings() // get its siblings .find(":input[type='text']") // find text elements in those rows .attr('disabled',true).removeClass('disabled'); // disable them }); how do i toggle .attr('disabled',false); I cant seem to find it on google.

  Read the article

• Is there a 'RowSpan = "All"' in WPF

  - by Chris Spicer

  Take for the following for example: <GridSplitter Grid.Row="0" Grid.Column="1" Background="Yellow" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Width="Auto" Height="Auto" Grid.RowSpan="3" ResizeDirection="Columns etc etc This will create a GridSplitter across the 3 rows that I have in my grid. However, it's conceivable that I might add another row to my grid at a later stage, and I don't really want to go back and have all of my rowspans. My first guess was Grid.RowSpan="*", but that doesn't compile. Does anyone know the answer to this off hand?

  Read the article

• MySQL doesn't use index in join query

  - by Kocsonya Laci

  I have two tables: comments(id(primary key), author, ip(index)) and visitors(id(primary key), date_time, ip(index)) I want to join them like that: SELECT visitors.date_time FROM comments LEFT JOIN visitors ON ( comments.ip = visitors.ip ) WHERE comments.author = 'author' LIMIT 10 It works, but very slow.. In EXPLAIN it shows that it doesn't use the index on the visitors table: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE comments ref author author 78 const 9660 Using where 1 SIMPLE visitors ALL NULL NULL NULL NULL 8033 Any ideas? Thanks!

  Read the article

• Why is sys+user > real in "time command"?

  - by shadyabhi

  I have a program that uses pthread library to do the matrix multiplication of 500x500 matrix. Each thread calculates 50 rows of the matrix. When I run tiem command:- shadyabhi@shadyabhi-desktop:~$ time ./a.out real 0m0.383s user 0m0.810s sys 0m0.000s shadyabhi@shadyabhi-desktop:~$ How come sys+user is greater than real time?

  Read the article

• How to fill a two Dimensional ArrayList in java with Integers?

  - by eNetik

  I have to create a 2d array with unknown size. So I have decided to go with a 2d ArrayList the problem is I'm not sure how to initialize such an array or store information. Say I have the following data 0 connects 1 2 connects 3 4 connects 5 ....etc up to a vast amount of random connections and I want to insert true(1) into [0][1], true(1) into [2][3], true(1) into [4][5]. Can the array automatically update the column/rows for me Any help is appreciated thanks

  Read the article

• How to calculate "holes" in timetable

  - by genesiss

  I've got a 2-dimensional array like this (it represents a timetable): http://www.shrani.si/f/28/L6/37YvFye/timetable.png Orange cells are lectures and whites are free time. How could I calculate number of free hours between lectures in the same day? (columns are days and rows are hours) For example, in this table the result should be: 2 for first column 0 for second colum -- The function returns 2 (because 2+0=2)

  Read the article

• Longest item in array

  - by c00lryguy

  Is there an easier way than below to find the longest item in an array? arr = [ [0,1,2], [0,1,2,3], [0,1,2,3,4], [0,1,2,3] ] longest_row = [] @rows.each { |row| longest_row = row if row.length > longest_row.length } p longest_row # => [0,1,2,3,4]

  Read the article

• How to choose between UUIDs, autoincrement/sequence keys and sequence tables for database primary keys?

  - by Tim

  I'm looking at the pros and cons of these three primary methods of coming up with primary keys for database rows. So assuming I am using a database that supports more than one of these methods, is there a simple heuristic to determine what the best option would be for me? How do considerations such a distributed/multiple masters, performance requirements, ORM use, security and testing have on the choice? Any unexpected drawbacks that one might run into?

  Read the article

• How i can do the following querry to get needed information

  - by Night Walker

  Hello there I have two tables CompList table with following columns : CompId , McID , station , slot ,subslot , and several others BookingTable with columns: CompId , LineID , McID , station , slot ,subslot. I want to get following result: rows only that CompList.CompId == BookingTable.CompId (only CompId that is in both tables) and i need in the result columns from CompList: CompId , McID , station , slot ,subslot . and from BookingTable: LineID , McID , station , slot ,subslot and how i will be able to distinguish between same columns with same table in the result table them in the result table? Thanks for help.

  Read the article

• Is it possible to merge two MySQL databases into one?

  - by Mike L.

  Lets say I have two MySQL databases with some complex table structures. Neither database has the same table name. Lets say these tables contain no rows (they do but I could truncate the tables, the data is not important right now, just testing stuff). Lets say I need these 2 databases merged into one. For instance: DB1: cities states DB2: index subindex posts I want to end up with a single DB that contains: cities states index subindex posts Is this possible?

  Read the article

• Select count() max() Date HELP!!! mysql oracle

  - by DAVID

  Hi guys i have a table with shifts history along with emp ids im using this code to retrieve a list of employees and their total shifts by specifying the range to count from: SELECT ope_id, count(ope_id) FROM operator_shift WHERE ope_shift_date >=to_date( '01-MAR-10','dd-mon-yy') and ope_shift_date <= to_date('31-MAR-10','dd-mon-yy') GROUP BY OPE_ID which gives OPE_ID COUNT(OPE_ID) 1 14 2 7 3 6 4 6 5 2 6 5 7 2 8 1 9 2 10 4 10 rows selected. NOW how do i choose the employee with the highest no of shifts under the specified range date, please this is really important

  Read the article

• Linq to SQL: how get row security between write access??

  - by Francisco

  I would like to allow two threads to write in a table at the same time (I know the problem of updating the same row, but this would be a story apart). I need that in behalf of speed up the operations in my aplication (one thread could write in row X while another could do the same in row X+n instead of waiting the first to finalize). So, can I block rows instead of tables with Linq to SQL? Thanks.

  Read the article

• Callback for UITableView animations

  - by akaii

  Is there a delegate protocol that includes a callback for the end of animated changes to UITableView? Particularly reloadSection/Rows?

  Read the article

< Previous Page | 151 152 153 154 155 156 157 158 159 160 161 162  | Next Page >