Member Avatar
Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …
by kgizo in Databases ()
Member Avatar
Hello, I am stuck with this problem.... I have few folders that contains a filename as **registration.txt** --- note the folder names are different since as and when a new user will register a folder gets created with its name and then the text file with the details of the …
by poojavb 29 in Software Development ()
Member Avatar
I want to check for duplicates when inserting a new contact in my database, then showing a msg that the contact is already in the db. this is what i've done: function isDuplicate(names,phone,email,adresa){ var isduplicate=false; for(var i=0;i<addresslist.length; i++){ if(addresslist[i].names.toLowerCase()==names.toLowerCase() && addresslist[i].phone.toLowerCase()==phone.toLowerCase()&& addresslist[i].email.toLowerCase()==email.toLowerCase()&& addresslist[i].adresa.toLowerCase()==adresa.toLowerCase() ){ isduplicate=true; } } return isduplicate; } …
by pucivogel in Web Development ()
Member Avatar
Although there are many similar questions and answers here and i've tried my best to make it work but no luck. This is my code: $content = "Blah...blah...[image=1], blah...blah...blah...[image=2], blah...blah...blah...[image=1], no more..."; function get_image($content) { $stripper = $content; preg_match_all("/\[image=(.+?)\]/smi",$stripper, $search); $total = count($search[0]); for($i=0; $i < $total; $i++) { $image_id …
by richprich in Web Development ()
Member Avatar
Hello Everyone! I am a beginner user of Python without IT background (I am interested in IT developing my knowledge step by step). So far I did simple scripts in Python and I encountered a problem. I was looking on Google, however I didn't find the satisfactory answers which would …
by mgunia in Software Development ()
Member Avatar
> Write an EFFICIENT program that reads in the name of a file containing positive integers that are less than 1,000,000. The program prints out the integers in the file, in the order that they appear, eliminating duplicates. So if the file contained 8 3 1 9 2 8 15 …
by marnun in Software Development ()
Member Avatar
Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table. for Example i have two different tables from two different databases. App1_Invoice (from Web App 1 database) e.g. transno name amount App2_Invoice …
by cigoL..:) -1 in Databases ()
Member Avatar
I'm trying to have my program find duplicates in an array of strings, and if it finds one, it swaps the duplicate to itemamount - 1, adds +1 to the WordAmt for that word, and moves the loop one spot down. I just am not sure how to properly do …
by Secone in Software Development ()
Member Avatar
hi need to show the duplicates on a column table when they have two other values in common on other column. form_name + field_value name1 | value_x name2 | value_y how can i create the query to search when values x, y, etc have form_name name1 and name2 ? thanks
by msyst3m.com in Databases ()
Member Avatar
Simple code to see if array of primitives has duplicates. The aim is to only check if there are any duplicates, but not to check what element is repeated, or its position etc. PS: Do you know some handy snippet? Don't way, post it!
by peter_budo 2,516 in Software Development ()
Member Avatar
Hi I am running the following SQL (extract shown below) INSERT INTO users (user_id, username, username_clean) SELECT member_id, username, lower(REPLACE(username, '.', '_')) FROM members The problem arises when lower(REPLACE(username, '.', '_')) produces a duplicate that already exists in username_clean as the users table does not permit duplicates. Is there a …
by magicmarkuk in Databases ()
Member Avatar
Say I have a basic list. [CODE]x = [2,3,1,3,5,4,5] [/CODE] And I want to find the sum result applied against the list without duplicates. So with duplicates the code could be. [CODE][elem * 2 for elem in x if elem >= 1 ] > [2, 4, 6, 6, 8, 10] …
by flebber 12 in Software Development ()
Member Avatar
Hi all, I'm writing a webcrawler as part of a search engine project at university, and have been using jsoup to my advantage. This connects to a page and neatly takes all the href's from anchor tags for me. However, when I add these to the arraylist of URLs waited …
by kris0r in Software Development ()
Member Avatar
Hello! I am having some trouble with reading data for a list. If at the end of the file there is a new line character, this function reads the last set of data again, and then exits the loop. The addElem function works fine, I tested it separately. As there …
by ERadu in Software Development ()
Member Avatar
hi to everyone, im having trouble with python programming... i have these 3 problems.... 1. remove a duplicates in a sorted integer 2. a python program that will detect if a number is divisible by 3 if you have solutions for my problems, can you help me pls...
by acejhon in Software Development ()
Member Avatar
I am having a problem with the SQL INSERT command in VB. I am trying in move data from one table to another. The problem is I am going from a table with duplicates to one with no duplicates. Since there are duplicates the SQL statement bombs. Here is the …
by DrPhil in Software Development ()
Member Avatar
Hey all! I'm trying to figure out how to check if an element already exists in a vector. EXAMPLE: Elements in the vector are: "Dog", "Cat", "Fish", "Bird" If a user tries to add (case ignored) "Dog", "dog" or any other variation, I want it to spit out and error …
by SacredFootball in Software Development ()
Member Avatar
My code is a php search function which is supposed to search from two tables in my database and displays matching results from the two tables in a line after line format. It is supposed to match the two tables with a common key field. However, the primary table has …
by mstrlouis in Web Development ()
Member Avatar
Hi, I need to create a stack with a key and for each key one or more instances of a data structure associated. A multi map seems to be best suited for this. However, I don't know how I could extract an element with the maximum key value whithout knowing …
by ferrant in Software Development ()