1,079 Recommended Topics
Remove Filter  | |
 | 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 … Databases daniweb-feedback microsoft-access web-design  |
 | 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" … Databases oracle sql visual-studio |
 | 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 … |
 | 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. Databases vb.net |
| | 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: … |
 | 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 …  |
| | 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 … Databases mysql  |
 | 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 … Databases sql |
| | 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 … Databases email |
| | 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 = …  |
 | 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 … |
| | 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 … Databases sql  |
| | 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' … Databases sql |
| | 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, … |
 | 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. … Databases microsoft-access sql vb.net |
| | 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 … |
| | How can i simply review Q/A on forum databases??? Of course, a couple of years ago, I simply called up daniweb.com, selected a forum, e.g. internet, databases, mysql and then I had seen Q/A on mysql database. Now I am back (because of your mails "we miss you 1StDAN) and … Databases  |
| | 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) { … Databases |
| | Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, … Databases sql |
| | Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to … |
| | sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover? Databases oracle |
| | Hi Dw. I'm trying to install MySQL and its my first time to install MySQL. I've downloaded the latest version which is version 5.7.12 and when I try to install its says "Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing … Databases client-server mysql |
| | Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use … Databases mssql sql web-design |
| | I have a database in mysql which contains of four tables (Student, Units, Offering and Enrols_in) and i want to create an enrolment page where students can enrol in units which will be offered in each semester. Student names will be entered in the database and they will use their … |
| | I'm in a Java class we are using netbeans to create a program. I have the code in and it builds but it will not run. Can anyone assist Databases java  |
| | Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p Databases microsoft-access sql |
| | I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the … Databases sql |
| | Can anyone explain me what are the main difference between a null value and blank value in database. It important please help me out. thank you. Databases mysql |
| | Apparently I don’t know how to insert a row into a MySQL data base using PDP and I would like to know what I am missing This PHP PDO script does not insert data into a database. I would like to know why. It does not error out but the … Databases mysql |
| | so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with … Databases microsoft-access |
| | Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID … |
 | # MySQL Stored Routines: Another Useful Scenario # [In a past guide](http://blog.bobbyhensley.com/sql-procedures-functions-authentication-example/) I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you … |
| | Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data from a vb.net datgridview. I have looked for a tool or examples but cant find any information that can point me to … |
| | Hello All, Is there any provision to ignore the trigger when i update a row in a table. Thanks, Loges Databases sql |
| | Hello, I have the below case. CREATE TABLE "PRBT"."TM_TABLE_1" ( "NID" NUMBER, "STRNAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, "NORDERCODE" NUMBER NOT NULL ENABLE, "NSTATEID" NUMBER DEFAULT 1 NOT NULL ENABLE, "STRDETAILS" VARCHAR2(256 BYTE) DEFAULT NULL, "STRAUTHOR" VARCHAR2(128 BYTE) NOT NULL ENABLE, "NPICTUREID" NUMBER DEFAULT NULL, "STRLATINNAME" VARCHAR2(512 BYTE), "STRLATINAUTHOR" VARCHAR2(512 … |
| | I'm trying to delete a database in phpMyAdmin which is in localhost of Windows 7 Professional 64bit system. Since I am not an IT or database professional, I'd appreaciate any help with non-techy steps. :-) When I attempt to delete the database I receive the error: DROP DATABASE 'enfold-2016' #1010 … |
| | Hi all, I will be building a web application that does a personnel data lookup, unfortunately using SSN. So I’ve been searching for how encrypt this data so that I do not use plaintext SSN in the application to accomplish this. I found this article: http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx . Does this mean … Databases mssql sql web-design |
| | getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) … Databases microsoft-access visual-studio |
| | Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. <?php $ic=$_SESSION['ic']; $query=" SELECT * FROM form WHERE ic='$ic'"; $result=mysql_query($query); $record=mysql_fetch_array($result); $query1=" SELECT * FROM login WHERE userIC='$ic'"; …  |
| | Hi guys! Pls help me make a water billing using c#.. I dont know how to start.. :( Databases  |
 | I have been trying two save data into mysql database using hibernate but it have been giving me an error. Could someone give a solution to this. Following is the servlet code and hibernate configuration servlet package ac.ke.schoolsystem.controllers; import java.io.IOException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; … Databases |
| | Hi all, I would like to export data from an Access DB, can this be achieved through a command? I plan to automate this export. Databases microsoft-access |
| | I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows; My pain … Databases mysql |
 | I have two tables tbl_lang and tbl_unicode as described below: tbl_lang lang_id lang_name lang_code 1 Français fr 2 العربية ar 3 Deutsche ge tbl_unicode ent_id ent_name fr ar ge 1 lbl_username Nom d'utilisateur اسم المستخدم Benutzername 2 lbl_password mot de passe كلمه السر Passwort While displaying in the Datagridview, i … Databases mysql  |
| | Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number Databases sql |
| | Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? Dim stDocName As String Dim db As Database Dim rs As Recordset Dim rs2 As Recordset Dim … Databases microsoft microsoft-access visual-basic |
 | Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables … |
 | Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. … |
| | Good time of day all. Today I saw this error "The database has been placed in an unexpected state; Microsoft Access can't open it." I was working with it I mean with this particular file not long ago, then my PC was shut down due to power surge. And now … Databases microsoft-access  |
| | 1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into … Databases mssql web-design |
The End.