Member Avatar

Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same values in more than one record. **Table (excerpt):** | id | userid | courseid | | 1 | 23 | 3 | | 2 | 23 | 3 | | 3 | 28 | 5 | | 4 | 28 | 5 | | 5 | 23 | 5 | …

Member Avatar
0
24
Member Avatar

how can i display selected records from my database(phpmyadmin) in listview using a search button? any reply will be a great help for me.. thank you.

Member Avatar
0
21
Member Avatar

Hi everyone, I am quite new to vb.net. Recently, I've been learning about Oledb commands and it's ability to save records in a form to a database. So, I started a project and now I am stuck. Here's the scenario: The form comprises of several comboboxes, a listview box and a command button. The combobox will get values from an access database. The users will be able to select from the comboboxes and on command button click, the entries will be added to the list view in a single row. All the above steps work perfecty except the part where …

Member Avatar
0
19
Member Avatar

hy i got a combo box and datagridview in my form and few other controls (to insert new record into my database),after the insertion is succcesful i want the inserted item to be displayed in my combo box and gridview by then only (i.e without restarting the project) could u please help me out..

Member Avatar
0
12
Member Avatar

I'm trying to display some records which meet some certain criteria. That works fine, but I also want to retrieve the total amount of orders. These are all located in the field 'Amount' from the Orders table. So if record 1 has got '22' in it's amount field, and record 5 has got '55' in it's amount field.. the total should be 77. My sql coding looks like this: SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate, sum(Orders.Amount) as total FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID where customers.country='Germany' order by Orders.Orderdate But it only retrieves 1 record (due to the summage), when I …

Member Avatar
0
47
Member Avatar

Friends, I have a Database in Access, Table Name- Master . Structure is given below Mno=Membership no in digits Name=Member's Name Fno=Family number in digits Fname=name of the family Faddress=Address of family Fphone=Telephone of Family The database contains several records where some members come under the same family.In other words,Suppose there are 10 members.2 members come under Fno 1,3 members come under Fno 2, 5 members come under Fno 3. My problem is this If I modify the family details of one member,that modification must be simultanously updated in the family details of all other members of that family I …

Member Avatar
0
41
Member Avatar

table slabpay ------------------------------------------------------- agent_id|agent_name|cust_id|cust_name|installment_amt| ------------------------------------------------------- 1 |mike |1 |john |350 | ------------------------------------------------------- 1 |mike |1 |john |400 | ------------------------------------------------------ 1 |mike |2 |abraham |350 | ------------------------------------------------------- 1 |mike |1 |john |450 | ------------------------------------------------------- 1 |mike |2 |abraham |400 | ------------------------------------------------------- mysql query ------------------------------------------------------ `$select = mysql_query("SELECT cust_id, cust_name,installment_amt FROM slabpay WHERE agent_id=1");` result should be ------------------------------------------------------ cust_id | installment_amt ------------------------------------------------------- 1,john ,350,400,450 2,abraham ,350,400 ------------------------------------------------------ i am new to php mysql please help me to solve this problem

Member Avatar
0
23
Member Avatar

Hello, Self taught guy here. Thanks for reading my post. I've made a app to track the sales of floating rubber ducks for a duck race. I have a database which contains data similar to this: id soldby package ------------------------ 1 John 6 2 John 25 3 John 1 4 John 6 5 John 25 6 John 1 7 Tammy 6 8 Tammy 25 9 Tammy 1 10 Tammy 1 11 Tammy 6 12 Tammy 25 13 Tammy 25 The number in the package field refers to the number of ducks purchased. Each package 1,6 and 25 has a dollar …

Member Avatar
0
67
Member Avatar

hi, i am new to mysql and also to php, i am trying to add a feature to a webpage, for showing some latest records from a mysql databse. i managed to show records from mysql database, but the problem is i only trying to show the first four records but it shows all the records i have in my databse. here is my script that shows the data from the database, so how do i managed to do that!! <?php $db = mysql_connect($mysql_server, $mysql_username, $mysql_password); if (!$db) { die('Failed to connect to database server!<br>'.mysql_error()); } mysql_select_db($mysql_database, $db) or die('Failed …

Member Avatar
0
25
Member Avatar

This special edition of the Guinness World Records book will appeal to geeks and nerds the world over. Not just because it is packed full of the kind of trivia that we all thrive on in social situations, but also because that trivia is firmly based in the realm of video gaming. Previous editions have been described as being a veritable gaming almanac, and this sixth installment of the series does nothing to degrade that opinion. It's packed with facts, figures, lists, stats and high quality imagery. ![dweb-guinness01](/attachments/small/0/dweb-guinness01.jpg "align-right")It's also more than just a collection of lists though, the 2013 …

Member Avatar
1
40
Member Avatar

For reason I won't bore you with, I need to update an archive database periodically with typically blocks of 100-300 records. Each record has 6 visible fields in the database. Frequently 4 of the 6 fields have the same information in them for the whole block of data. For a good reason I do this by creating the required number of empty records in the database for the required block of data then manually editing each record. My intension was to complete the first record of the block, and then create a program that would read that record and then …

Member Avatar
0
10
Member Avatar

Hello, I'm very new to using VB.Net so I found it quite difficult to understand other answers that I searched for. Basically, I have an project to develop where a user can create an account, and log in with it. So far I have : Created a database in ms access with the relevant fields (2003 edition) Created a VB form with the correct text boxes etc. and linked the text boxes to the database. What I need : I would like to be able to code it so that when the form is opened, a new blank record in …

Member Avatar
0
85
Member Avatar

Hello, I want to submit multiple records into a mysql database, and I have hit a snag. I am developing a web application that displays student records, and upon displaying student records per class, I want to be able to add marks for beginning of term, mid term and end of term. The problem is that, since I am not sure of how many rows of records the sql statement will return, I can't declare different variables for each student mark. I tried using the foreach loop but it kept showing me an error in declaration of variables. The loop …

Member Avatar
0
25
Member Avatar

anyone know how genetic programming works on finding duplicate records in database?

Member Avatar
0
5
Member Avatar

i have 2 forms.. the first one is for displaying students record while the other one is for searching student record (in datagrid) i want to display the searched record of a student from form2 to textboxes in form1..how is this possible? If DataGrid1.Col = 0 Then If Text1.Text = "" Then MsgBox "Enter Student ID" Text1.SetFocus Else refer = DataGrid1.Col refer = Text1.Text bol = True formal.Show End If Else MsgBox "Click StudentID" End If tudentID" End If

Member Avatar
0
14
Member Avatar

iam using vb 2010 and i want to search for any record when i enter a text in the search text box. i mean, if my records are as follows: dan,daniel,edn,steven,mary. and i just inpunt 'd' in the search box, the datagrid lists: dan,daniel,edn because they have a 'd' in them. my code is as follows. Sub search() Dim objConn As New MySqlConnection Dim objCmd As New MySqlCommand Dim strConnString,strSQL As String strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false" strSQL = "SELECT * FROM donationtype WHERE firstName like '%" & strKeyWord &"'" objConn.ConnectionString = strConnString With objCmd .Connection = objConn …

Member Avatar
0
15
Member Avatar

hi, what is the query to fetch duplicate (related) records in oracle.

Member Avatar
0
3
Member Avatar

Hi there, I am trying to combline results form a query into one variable/string without drastically changing the sites current code. Bacically I have been trying to add **rs2("name")** for each record into one string. For example, say the customer has "item1", "item2", and "item3" in their basket, well I want to combine each of these together into one single variable called **"stuffall."** (like "item1 item2 item3") The code I am using can be found below, and I have highlighted the problem areas using <<<>>>. I assumed, as in php, this would be possible by adding **rs2("name")** into a var …

0
1
Member Avatar

Hi all, i have a table for instance, systemid | phonenumber 1 62222222 1 92222222 1 64444444 2 91111111 3 63333333 3 63333333 i want my select query output to be systemid | phonenumber | phonenumber2 | phonenumber3 1 62222222 92222222 64444444 2 91111111 3 63333333 63333333 I tried to find, pivot , case?? anyone could help me Thanks in advance

Member Avatar
0
4
Member Avatar

Hi, I am having a code which fetches say 200 records,after 6 records i got an exception..So after my exception is caught in catch block i have 2 call a method which can help continuing the exception starting from the 7th object. Can anyone help with some piece of code that can help me do this??? Hoping for a favorable response Regards Arathy Nair

Member Avatar
0
4
Member Avatar

Sorry I'm new to these stuff but I am having a hard time about this. So I'll trying to create a php and mysql program which can view records from database server. In my form I have 2 dropdown list and 2 submit button, the first one the the list of "section" and submit button, and the second one is a list of "year level" and submit button again. If I select the section "A" and click submit button, it will display only the student's information that belongs only on section "A" and same as on "year level". I can't …

Member Avatar
0
14
Member Avatar

Hello. I stored dateFrom & dateTo as String '11/11/2011' and '11/25/2011' [mm/dd/yyyy] format. now when i fired query as below [code] select (case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 'Dec/2012' else 0 end ) as Months, sum(case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 1 else 0 end ) as TotalCases ,sum( case when (pp_send_date_to_district between '11/01/2012' and '11/25/2012') and PP_DATE_OF_FINALREPORT_SENT_TO_RPO !='NA' then 1 else 0 end) as DisposedCases,( sum(case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 1 else 0 end ) -sum( case when (pp_send_date_to_district between '11/01/2012' and '11/25/2012') and PP_DATE_OF_FINALREPORT_SENT_TO_RPO !='NA' then 1 else 0 end)) As …

Member Avatar
0
2
Member Avatar

Hi guys, Is there a difference between these two: struct->variable struct.variable ?

Member Avatar
0
6
Member Avatar

hi all and thanks for reading. Personally i thought i wouldnt be in the frame of putting up one of my assignments, as i can see where an opinion might be formed, over me trying to pull as fast one and get someone to code this for me etcetc etc..... But can someone tell me if im right in thinking it means...either: 1. create an array 2. create a struct 3. create *ptr array and one of the above All to include user input and then to ba able to be saved appened and written to (using "r+a" syntax, at …

Member Avatar
0
3
Member Avatar

I'm trying to write some code that will write certain variables to a text file and create a simple record system. So when a button is clicked the variables are calculated and written to a text file. How can I set it up so that when the button is clicked again and the variables change due to the new values, the new set of variables are written on a different line in the text file and don't simple overwrite the old ones. So there would be one record per line. This is the code I have for the writer component …

Member Avatar
0
5
Member Avatar

hello everyone, got issue regarding reading duplicate records in a text file... i need to read the file and look for any duplicates data/keys in the text file and write them to another file (all the duplicates records)... how can i do that, in looping...:-/ any help...:) thanks!

Member Avatar
0
21
Member Avatar

Can you help us for our project in creating a daily record transaction? Do you have any codes out there or samples, and help us in connecting it to the database thru Microsoft Access. Your feedbacks are highly appreciated ASAP.

Member Avatar
0
3
Member Avatar

Sometimes a person can get too close to their work that they cannot see what is going on wrong. I hope that is the case here. I have been working on my favorite project, a large wood knowledge base at: [url]www.prowebcanada.com/taxa[/url]. There is enough data to look up already and much, much more to follow, enough that the site really does need a versatile internal search engine to navigate to what users will want. A few months ago, I was able to install one that searched on just one field of the species table that worked fine. The algorithm and …

Member Avatar
0
3
Member Avatar

Hey, I could have posted this in my other thread, but i though this was strange enough to make a thread of it. So im still working on the program mentioned in my other thread, it runs with a main menu procedure. When the user selects a menu option, program goes to procedure, carries it out, etc, etc, and then comes back to the menu again. When this occurs, my program believes it is storing an additional 1, 2, or even 3 records in its text data file, when it actually isn't! I open my data file, the other questions …

Member Avatar
0
2
Member Avatar

Hello to all, I am always mad about this problem. If I type a name with two words in a textbox like "google corporation" it will be registered in the database ms access as "Google Corporation" now that is okay. What I want is, there should be no duplicate of names, but the problem is, when I enter "google corporation" it will be registered again in the database instead of displaying "No duplicate". This is my code: [CODE]Private Sub Command1_Click() Dim rst As New ADODB.Recordset Dim i As Integer Dim R_Count As Currency With rst .ActiveConnection = con .CursorLocation = …

Member Avatar
0
6

The End.