Why does this expression return true?
Possible Duplicate: Can somebody explain this Javascript method ? (x = [].reverse)() === window // true Any idea why? ...
duplicates
SQL Query Returning Duplicate Results
Hi, I've been working out this query now for a while and I thought I had it where I wanted it, but apparently not. There are two records in the database (orders). The query should return two different rows, but instead returns two rows that have exactly the same values. I think it may be something to do with the GROUP BY or derived tab...
MySQL - Duplicate elimination and Preserving Valuable Data?
Scenario : I have few duplicate contacts in a table. The duplicates are identified, I can just delete them but the problem is I don't want to lose the data the duplicate might have and the original don't. Any tips? Sample data : ID Name Email School Dupe_Flag Key 1 AAA a@a X 1 2 AAB JKL 1 3 BB...
Removing duplicates in xsl
I have the following XML and I want to process it so that I do not get duplicates in the result set. I have simplified the problem to make it easier to understand. Also how can I use the results of one template as part of the input for another? This: <LINES xmlns:set="http://exslt.org/sets"> <STDINSTRSEQ>0</STDINSTRSEQ> <STDINST...
MySQL Result - "Group By" removing incorrect duplicates
Will do my best to describe the problem Im having :) Each thread/topic in my forum represents one disc. Registered members of the forum use a series of checkboxes (one displayed next to each disc) to tick each disc that they have in their collection. When the form is $_POST'ed it stores the information in a table like so: | user_id - ...
Insert record and throw exception
I want to throw an exception if cardescription is in table in row with specific @idCar cardescription is not PK, and any change in design is not allowed insert into carsdescription (description) value (@description,@idCar) Examples: IDCar | Description --------------------- 1 | nice - this record was in table ...
Counting Duplicates Integers in Python
How do I find the total number of duplicates in a string? i.e., if it was j= [1,1,1,2,2,2] it would find 4 duplicates? I've only been able to find counting which shows how many times each individual number occurred. ...
Deleting duplicates from a large table
Hi, I have quite a large table with 19 000 000 records, and I have problem with duplicate rows. There's a lot of similar questions even here in SO, but none of them seems to give me a satisfactory answer. Some points to consider: Row uniqueness is determined by two columns, location_id and datetime. I'd like to keep the execution time...
Remove identical files in UNIX
Hi all, I'm dealing with a large amount (30,000) files of about 10MB in size. Some of them (I estimate 2%) are actually duplicated, and I need to keep only a copy for every duplicated pair (or triplet). Would you suggest me an efficient way to do that? I'm working on unix. Thank you :-) ...
How to Programmically Delete Duplicate Records in a Tcl/Tk Treeview Widget
Hello: I have a treeview widget in my Tcl/Tk application that will often show duplicate records. I tried writting "lsort -unique" and "lrmdups" into my code to automatcally delete the treeview duplicates, but with no luck. If possible, does anyone know how to do this? Thank you, DFM ...
Sending mail in blackberry
hi i want to create an application which can send a email in blackberry. can i have a sample code or tutorial thanks alot ...
Display Last 200 mysql entries no dupes
I'm just wondering how I could display my last 200 mysql entries in php without showing duplicate entries. ...
Remove duplicates in NSdictionary
Is there a way to remove duplicate (key-value) pairs from NSDictionary ? EDIT: My description was misleading, I have duplicate pairs e.g. key1-value1 key1-value1 key2-value2 key1-value1 etc.. ...
Duplicate a UITableViewCell - iPhone
Hi everyone, I would like to create an effect to a cell of a UITableView. The effect is: duplicate the cell and move the duplicated cell (the original stays at its place). My problem is to duplicate the cell... I've tried: Code: UITableViewCell *animatedCell = [[UITableViewCell alloc] init]; animatedCell = [[self cellForRowAtIndexPath...
gridview check duplicates not using sql
I have a code: foreach (GridViewRow dr in gvCategories.Rows)<br/> { <br/> if (dr.Cells[0].Text == txtEnterCategory.Text.Trim())<br/> <br/> isError=true; <br/> <br/> } Debugging: dr.Cells[0].Text is always "", even there are records. How to use a loop to check each row to find if a record exists in the gridview no...
Bash loop command until file contains n duplicate entries (lines)
Hello, I'm writing a script and I need to create a loop that will execute same commands until file does contain a specified number of duplicate entries. For example, with each loop I will echo random string to file results. And I want loop to stop when there are 10 lines of of the same string. I thought of something like while [ `so...
Mark duplicates in MySql with php (without deleting)
So, I'm having some problems with a MySQL query (see other question), and decided to try a different approach. I have a database table with some duplicate rows, which I actually might need for future reference, so I don't want to remove. What I'm looking for is a way to display the data without those duplicates, but without removing the...
Oracle : Identifying duplicates in a table without index
When I try to create a unique index on a large table, I get a unique contraint error. The unique index in this case is a composite key of 4 columns. Is there an efficient way to identify the duplicates other than : select col1, col2, col3, col4, count(*) from Table1 group by col1, col2, col3, col4 having count(*) > 1 The explain pla...
How can I ignore an http request without clearing the browser?
To prevent duplicate requests (i.e. pressing F5 right after clicking a command button), I've setup my page base class to ignore the request if it's detected as a duplicate. When I say 'ignore' I mean Response.End() Now I thought I've seen this work before, where there's an issue, I just Response.End() and the users page just does not...
Comparing lists of names in Excel, accounting for duplicate last names
I have two lists of names in Excel '07. Two columns in each file: first name and last name. I'd like to be able to tell which names in each list (name = first, last) appear in the other list. None of the methods I can think of account for more than one column at a time -- e.g., I can see how many "Smith"s there are, or how many "Albert"s...