duplicates

Assign a block to more than 1 region

How do I assign a block (the very same block) twice or thrice to different regions? The idea is not to have the same block on the same page more than once, but in different locations on different pages, so four 'displays' would be available: Block X in the $top_left region Block X in the $top_right region Block X in the $above_content ...

JPA persist same entity twice

Hey guys, I just noticed that a part of code I worked on saves the same entity twice. I tried several tricks, like flush() and Transaction REQUIRES_NEW but nothing does it. But I can see while debugging that after calling persist(entity), I get an ID (IDENTITY) for that entity... but just a bit later in the code if I look at the variable...

SQLAlchemy duplicate table, rename table?

All, This is a snippet from internet repersent the database table will be used: >>> from sqlalchemy import Table,Column,Integer,String,MetaData,ForeignKey >>> metadata=MetaData() >>> users_table=Table('users',metadata, Column('id',Integer,primary_key=True), Column('name',String), Column('fullname',String),...

count and remove duplicate access vba

Here is some code I have to remove duplicate occurances of catid & recid in tblcat1_rec table, leaving only 1 entry: mysql = "DELETE FROM tblcat1_rec " mysql = mysql & " WHERE ID <> (SELECT Min(ID) AS MinOfID FROM tblcat1_rec AS Dupe " mysql = mysql & " WHERE (Dupe.catid = tblcat1_rec.catid) " mysql = mysql & " AND (Dupe.recid = tblcat1...

SQL Server get unique rows or row with largest field value

Hi, I have a table in SQL Server 2005, as follows, say, fields A, B, C, D If I have the following data: A B C D 1 B1 C1 D1 - 2 B1 C1 D1 - 3 B2 C2 D2 - 4 B2 C2 D2 - 5 B2 C2 D2 - 6 B3 C3 D3 - I want to be able to pick out the rows which are either unique (on B, C...

Comparing two lists and removing duplicates from one

I have an object called FormObject that contains two ArrayLists - oldBooks and newBooks - both of which contain Book objects. oldBooks is allowed to contain duplicate Book objects newBooks is not allowed to contain duplicate Book objects within itself and cannot include any duplicates of Book objects in the oldBooks list. The definitio...

Django "Duplicate" ModelForm

Hi I'm wondering if there is a simple way of creating a "duplicate" ModelForm in Django - i.e. a form that is prefilled with the content of an existing model instance (excepting certain fields, such as those that are unique), but creates a new instance when saved. I was thinking along the lines of supplying an instance to a ModelForm s...

When to consolidate code duplicates

We're using a code static analysis tool (Sonar) to detect duplicate code on our project. It appears that there are a great many instances of duplicates in the code but most of them are less than 10 lines and occur only once. In the 'opinion' of the Stackoverflow community, Where should you draw the line at consolidating code duplications...

how do I set a field with a duplicate name of another field in mechanize?

I am trying to submit a form with 2 fields with the same name but different type. I can identify the correct field I want by the field type or the number. Whats the best way of setting the correct field without iterating through all the fields? ...

Generating duplicate responses within a MySQL SELECT query

I am using the report writing functionality within an application to generate barcode product labels. The report writing system allows me to use a MySQL SELECT statement to get the information I need from our database and present it to a Jasper Reports JRXML file that formats the report. This works fine if I want to produce one barcode...

Python - Way to distinguish between item index in a list and item's contents in a FOR loop?

For instance, if I wanted to cycle through a list and perform some operation on all but the final list entry, I could do this: z = [1,2,3,4,2] for item in z: if item != z[-1]: print z.index(item) But instead of getting the output "...0 1 2 3," I'd get "...0 2 3." Is there a way to perform an operation on all but t...

hide duplicate div in jquery

I have some layers that are dynamically put in as follows <div><p class="locid">2<p></div> <div><p class="locid">1<p></div> <div><p class="locid">2<p></div> <div><p class="locid">3<p></div> <div><p class="locid">4<p></div> What I need to do is hide the second occurrence of this layer so it appears as follows <div><p class="locid">2<p...

Detect duplicated registries in Oracle

Hi, I have a table in Oracle and I want to select all the duplicated values, I mean: I can detect that a register is duplicated because some column contains the same value: ColumnA ColumnB 1 A 2 A 3 A 4 B I want to get something like: 1 A 1 A 1 A Thanks a lot. ...

How can I remove duplicates and sorting at the same time in Perl?

Hi Everyone, I have an array of this kind @uniqarr = qw(error 0 goodrecordno:6123, error 0 goodrecordno:6143, error 1 goodrecordno:10245, error 1 goodrecordno:10678, error 1 goodrecordno:10698, error 2 goodrecordno:16245, error 2 goodrecordno:16123); I want the o/p as error 0 goodrecordno:6123 error 1 goodrecordno:10245 error 2 go...

Remove Duplicate Rows Leaving Oldest Row Only?

I have a table of data and there are many duplicate entries from user submissions. I want to delete all duplicates rows based on the field subscriberEmail, leaving only the original submission. In other words, I want to search for all duplicate emails, and delete those rows, leaving only the original. How can I do this without swappin...

[Awk/Sed] How do i print word after regex but not a similar word?

I want an awk or sed command to print the word after regexp. I want to find the WORD after a WORD but not the WORD that looks similar. The file looks like this: somethingsomething X-Windows-Icon=xournal somethingsomething Icon=xournal somethingsomething somethingsomething I want "xournal" from the one that say "Icon=xournal"....

sql query to find sum of all rows and count of duplicates

If data is in the following format: SID TID Tdatetime QID QTotal ---------------------------------------- 100 1 01/12/97 9:00AM 66 110 100 1 01/12/97 9:00AM 66 110 100 1 01/12/97 10:00AM 67 110 100 2 01/19/97 9:00AM 66 . 100 2 01/19/97 9:00AM 66 110 100 2 01/19/97 10:00A...

SQL query for non duplicate records

I'm attempting to build a query that will return all non duplicate (unique) records in a table. The query will need to use multiple fields to determine if the records are duplicate. For example, if a table has the following fields; PKID, ClientID, Name, AcctNo, OrderDate, Charge, I'd like to use the AcctNo, OrderDate and Charge field...

In R, how can I take a subset of columns of a data frame and then eliminate duplicate rows?

Imagine I have a data frame with data like this: A | B | C ---+---+--- 1 | 2 | a 1 | 2 | b 5 | 5 | a 5 | 5 | b I want to take only columns A and B, and I want to remove any rows that have become duplicates as a result of eliminating all other columns (that is, column C). So my desied result for the table above would be: A | B -...

Need to remove duplicates from a list of dictionaries and alter data for the remaining duplicate (python)

Consider this short python list of dictionaries (first dictionary item is a string, second item is a Widget object): raw_results = [{'src': 'tag', 'widget': <Widget: to complete a form today>}, # dupe 1a {'src': 'tag', 'widget': <Widget: a newspaper>}, # dupe 2a {'src': 'zip', 'widget': <Widget: to co...