Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 3 3 3 3 3
Member Avatar
I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part …
by savedlema 17 in Databases ()
Member Avatar
Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help
by phphp in Databases ()
Member Avatar
I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …
by Oxley_1 in Databases ()
Member Avatar
Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, …
by ikel in Databases ()
Member Avatar
I need to develop aa database to store stock taking information and sales. I was going to use MS Access to strructure and make all the logistics for my database since im quite friendly with access and i find it easy to use. MY problem is, i want this database …
by Joseph_24 in Databases ()
Member Avatar
Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` …
by James_43 15 in Databases ()
Member Avatar
Hi everyone! I am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first. I am writing a report to display on our asp.net site using the ReportViewer component and …
by zachattack05 56 in Databases ()
Member Avatar
Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …
by doncwilson_1 16 in Databases ()
Member Avatar
Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …
by doncwilson_1 16 in Databases ()
Member Avatar
sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir …
by _1_36 in Databases ()
Member Avatar
Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved …
by D137Pi in Databases ()
Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,078 in Databases ()
Member Avatar
Hi Guys, I'm new to vb.net programming. I'm finding it really hard printing selected columns in a datagridview. there are 12 columns and i would like to print just a few in a landscape view. Please, can someone help me.
by Daniel_57 in Databases ()
Member Avatar
i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …
by xuexue 15 in Databases ()
Member Avatar
Hi all, Say I have a table called "posts" with thousands of records. For each user, I want to display the top 10 most recent posts. I would normally use: `select * from posts order by created_date desc limit 10` However, doesn't this select ALL records and then removes all …
by James_43 15 in Databases ()
Member Avatar
Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …
by Ritesh_4 44 in Databases ()
Member Avatar
I am inserting dates like 2016-03-01T00:00:00, which is in the varchar format. I want to convert into as mysql date and add between condition to get records. I am using STR_TO_DATE function, but I am getting as NULL value.
by Abhi_6 in Databases ()
Member Avatar
I have a SQL Server bank account table which contains ... ID (Identity) Trdate (Date), Description (Varchar), Debit (Money), Credit (Money), Balance (Money) Details (Varchar) I want to list a subset of the transactions between two dates (the period of an Australian Financial year) and the query below works correctly …
by Glyn_2 in Databases ()
Member Avatar
HI: I had a archived copy of my email on the local system. Due to some problem my C: drive of the system got corrupted and i had already taken one copy of my archive folder. After reinstalling the OS and Lotus Notes now i have kept the archive copy …
by LudvikTabor in Databases ()
Member Avatar
I used below select query to select information from two tables. But it show one record. How to change this code to view all records ? select loan.loan_id, loan.customer_name, loan.total_amount, ifnull(sum(settlement.amount), 0) as 'Total Received', ((loan.total_amount) - ifnull(sum(settlement.amount), 0)) as 'Total Due' from loan left join settlement on settlement.loan_id = …
by සශික in Databases ()
Member Avatar
What type or version of mysql do you need to run to have referential inegrety, withhout having to reley on using triggers?
by _1_1 in Databases ()
Member Avatar
Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot …
by Saboor Siddique -3 in Databases ()
Member Avatar
Hi Guys, I need your help to create query dynamically, how to populate data value from formula in other table. Sample Below Table A ID Amount 1 50 2 40 3 50 Table B ID FormulaID VALUE X 1+2+3 Y 1-2+3 Result Expectation ID FormulaID VALUE X 1+2+3 140 Y …
by ilvanhellovan in Databases ()
Member Avatar
hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query. It's not generate 0 value records. can anyone hep me ? select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' …
by සශික in Databases ()
Member Avatar
SELECT [SNAP!] FROM topics INNER JOIN members ON topics.author = members.id WHERE topics.parent = [variable from PHP] ORDER BY topics.id DESC LIMIT [variable from PHP], 10 Is what I have in pocket. I'd like to slam `SELECT * FROM forums WHERE id = topics.parent`. While keeping the functionality it already …
by Aeonix 39 in Databases ()
Member Avatar
Hi I have a procuder which return a recordset using cursor in output what am trying to do is i use cursor to get the data and same have to return it to output cursor .I can do like below PROCEDURE test(value_one IN someTabel.somecolumn%TYPE, valu_two IN someTabel.somecolumn%TYPE, Outputcursor OUT SYS_REFCURSOR) …
by kamilacbe in Databases ()
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
I have a member table from which I'm trying to create a query using these fields mem_id / username / create_date / mem_status / ref_id / qualify_id A new member is mem_status 'F' with ref_id equal to the mem_id of their referrer and qualify_id of zero When the member upgrades, …
by showman13 49 in Databases ()
Member Avatar
import java.io.*; class projj { BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); int c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18; int c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41; String name,n; public void game()throws IOException { System.out.println("YOU ENTERED 1.PS4 THE CHOICES ARE"); System.out.println("1.SPORTS"); System.out.println("2.RACING"); System.out.println("PLEASE ENTER YOUR CHOICE"); int ch=Integer.parseInt(br.readLine()); switch(ch) { case 1: System.out.println("\f"); System.out.println("1.CRICKET"); System.out.println("2.FOOTBALL"); System.out.println("PLEASE ENTER YOUR CHOICE "); int ch1=Integer.parseInt(br.readLine()); switch(ch1) { …
by keshav1234 in Databases ()
Member Avatar
Hi Dw. What is the correct way to write an sql query like this? `"select * from MyTable where username ='username' And password ='Password'"` in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. …
by Mr.M 32 in Databases ()
Latest Posts