7,494 Archived Topics
Remove Filter  | |
| | |
| | i need help. my teacher told me to create a program on java gui that can send everything you input to notepad. then when you input another info in java gui. another notepad file should be made.. Databases java microsoft-access sql |
| | I'm making money lending system. In my database there are two mysql tables which are custormer AND income. All custormer info stored in custormer table. When I give loans these loan details stored in loan table. After I received loan amount from custormers(daily payments) these records stored in income table. …  |
| | Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … Databases http-protocol mariadb php sql unix web-server |
 | Hi dear everyone, I have a website on WordPress that has been down at least for the past two months: http://terouma.net It is hosted with OVH and for the past weeks, I have been going back and forth with their customer support (which is not the most responsive on earth … Databases microsoft-access wordpress |
| | Hi, i am trying to open a form from selected data in an earlier from. I use cust_id = grd_customer(0, current_row).Value to hold the value so that cust_id will open up a from that has a customer's details. But i keep on getting Unhandled Exception of type 'System.IndexOutOfRangeException' that says, … Databases |
| | I have this in my my.cnf wait_timeout=1800 interactive_timeout=1800; net_read_timeout=1800; net_write_timeout=1800 but when i execute show processlist; I have processes that still running more than 4500sec even they are in 'Sleep' command. please help about this, thank you. Databases mysql |
 | hello guys i make a database software and i want to import sql file into mySQL database with query , so that when user click button this sql file is auto import , Is there any way to do this , thankx |
| | Hi all. Can anybody help me? Yesterday I work with my access file with necessary data for my work and today I can’t open it. The version of Microsoft Office is 2003. Windows 7. Thank you! Databases microsoft-access microsoft-office |
| | I used mysql query broweser to create database and tables. but when I run this code it doesn't show results. But there is no error SELECT * FROM expenses WHERE datee BETWEEN 01/01/2016 and 01/09/2016; can anyone help me ? Databases mysql |
| | It could be a dumb question, and tried to search for it and found nothing. I been using mysql for years(not that to long) but i never had tried mysql transactions. Now my question is, what would happen if i issue an insert or delete statement from multiple clients using … Databases mysql |
| | Hi thanks for the help I am new to this so sorry if I’m slow. I am trying to make an Access Database I have a quarry that pulls data into a combo box and then auto fills the below text boxes. I want the user will then fill out … Databases microsoft-access open-source |
| | contiunally getting ORA-00907: missing right parenthesis error when trying to insert data in my star scheme using the code: INSERT INTO account_dim (account_id, account_name) SELECT (acc_seq.nextval, lds_account.acc_name) FROM lds_account; INSERT INTO account_dim (account_id, acount_name) SELECT (acc_seq.nextval, mch_account.acc_name) FROM mch_account; Can anyone make any suggestions? Databases  |
| | My website show below error. Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET/@@@@@@.net/ Reason: Error reading from remote server Apache/2.2.15 (CentOS) Server at hostgator.com Port 443 Response from Hostgator: The site is currently expericing MySQL timeout …  |
 | PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given on line 31 $insert = mysqli_query ($conn," insert into user set user_name = '".$_POST['uname']."' , age = '".$age."' , page = '".$page."' , user_password = '".$password."' , user_birthdate = '".$user_birthdate."' , puser_birthdate = '".$puser_birthdate."' , user_gender = '".$_POST['gender']."' , user_country = …  |
 | I try to make a query and it works well, but when i put it in a stored procedure.I can't figure out whats wrong with my code. It says **Procedure or function has too many arguments specified** Stored procedure code ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- … Databases sql |
| | Hi all, I have two tables. - Cart (cartId, prodId, etc) - Codes (Id, cartId, Code) Each line in the **Cart table** has a code from the **Codes table**. Because of an error, we now have 20 cart rows (But another time around it could be 1000 rows, so manually … Databases mysql |
 | Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried … Databases operating-system sql  |
| | Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in … Databases mysql |
 | Can anyone give a clear,short and simple explanation about database indexes? Databases |
| | my insert statement seems to be ignoring my unique index and adding duplicates what'd i mess up? thanks in advance Table CREATE TABLE `address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `address_street1` varchar(100) NOT NULL, `address_street2` varchar(100) DEFAULT NULL, `address_street3` varchar(100) DEFAULT NULL, `address_city` varchar(45) NOT NULL, `address_state` char(2) DEFAULT NULL, … Databases mysql |
| | * <?php mysql_connect("localhost","root","") or die ("could not connect"); mysql_select_db("search_test") or die ("could not find db!"); //collect if(isset($_POST['search'])){ $searchq = $_POST['search']; $searchq = preg_replace("#[^0-9a-z]#i","",$searchq); $query = mysql_query("SELECT * FROM members WHERE firstname LIKE '%$searchq%' OR lastname LIKE '%$searchq%'") or die ("could not search!"); $count = mysql_num_rows($query); if ($count == 0 ) … Databases client-server mysql php  |
| | Greetings, I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are: 1- BCNF - Boyce-Codd Normal Form 2- 4NF 3- 5NF 4- ONF - … Databases sql |
| | Hi all, Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints. The most logical solution would be to do … Databases sql web-design |
 | I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: * drawings * layers * style * entities * points * flags * floats * text The …  |
 | I added "DISTINCT" in my code. but seems the output is still the same, it have duplicate records. Thank u :D (note: I changed the field names and tables here) SELECT DISTINCT b.field1, b.field2, b.field3, b.field4, c.field1, c.field2, c.field3 from tbl1 b inner join tbl2 c on b.logid = c.logid … |
| | i need to get record based on maximum created date any body help me date in mysql database structure is varchar. date is 150921141206 any body help me Databases mssql |
 | I'm not looking for others to do my homework, I just want help with getting an idea one what to do. My class was given an assignment and one of the questions is: Create a query that will show the order id, item id, price, sales tax and subtotal for … |
| | Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe |
| | Hi all. I am having some trouble implementing my add-data.php as explained in this [tutorial](http://www.codingcage.com/2015/06/multiple-insert-update-delete-crud.html) My situation is that I should be able to do CRUD of data but from/to multiple tables. Following the tutorial, so far I have done the display/index.php, generate.php and the form part of add-data.php. Now, … Databases php |
| | Hi, Can you guys reccomend me some good oracle sql journals? Thanks |
| | Hello, What are the different areas of databases I can focus on for my project? Thanks, Databases client-server mssql oracle sql |
| | Hi all, If I have two table of cod-desc, T1 and T2, and I need to create all possible combination, other than using cartesian product, is there another way more optimal to do that? Suppose every table has 1M rows. RDBMS= Oracle 11G. Thanks sandro |
| | I m new to the MS Access, I m prone to the SQL Server Only. Can u plz explain the difference b/w[B][COLOR="Red"] Datasheet View & Design View[/COLOR][/B]. I have some idea,pls check it whether me right pr wrong. In design view,we have to specify by own datatypes & column names. … Databases microsoft-access |
| | WAMP 2.5 server on my windows 10 machine was working completely fine, until I accidentally installed a software which silently installed Win MySQLAdmin on the same machine. That day since, Wamp server icon remains in orange color (never turns green). **Issues:** 1. localhot/ phpmyadmin displays 'access denied' error. following is … Databases microsoft-access mysql php sql windows-10 |
| | I have a quick question, I am hoping it is an easy answer but if I wanted a query like the following: SELECT * FROM items ORDER BY date ASC Is there anyway to replace the order by information with prepared statement attributes? would either of the following work? SELECT … |
| | I need some help writing a sql query. I have below 2 queries and I want to combine them together. Now I already tried union but it doesn't work. I first want to print all result of query1 than I want to print all results for query2. Ex: --Query#1 results: … Databases sql  |
| | When I was editing the databse, the power went off and now arror comes as "Unrecognized file format ...............". I tried to compact and repair but no success. how to recover data? Databases microsoft-access |
| | Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. That is the question. I've written the following … Databases |
| | Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 … |
| | Hii..this is mysql query $querry="SELECT CONCAT(`insert_id`, `type`) AS 'order_id' FROM orders WHERE email='$email'"; $order_id=mysql_query($querry); echo $order_id; i need to convert this into ** mysqli**. Any Help?? |
 | I am to attempting to recover data from a schema that had both MyISAM and InnoDB tables. I can recover the MyISAM tables without any problem, however I am running into difficulty trying to get the InnoDB tables back. Steps taken: I have backup of the schema folder in the … Databases mysql  |
| | Howdy All, I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic. Some background info so that the problem is understood: I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can … Databases data-structure database-design sql |
| | I'm working on a personal movie database project to help keep track of my movie collection, but I'm having issues and I was wondering if it was even possible and if so how to go about doing this in the first place. I want a way to get an overall … Databases mysql sql streaming-service |
| | iam facing this problem while transfering my site from localhost to live server using duplicator plugin.please see this below attachment Any suggetion?? Databases client-server wordpress |
 | Hi to all! I have to install sql server first time. But I have a confusion that what is difference between sql server and sql server management studio? secondly is sql server management studio embeded in sql server or will it installed separately? If it will installed separartely then which … Databases client-server sql |
| | hello all. i have the following code... SELECT * FROM data WHERE no_2 = no_1 + 1 AND no_3 = no_2 + 1 AND no_4 = no_3 + 1 AND no_5 > no_4 + 1 UNION SELECT * FROM data WHERE no_2 > no_1 + 1 AND no_3 = no_2 …  |
| | Hiiii,Good Evening I have a code that search for data in the database but I can search for only 1 keyword in a time,which is working fine for single keyword. if I type 2 keywords separated by a space or comma's which return blank page. I would like to modify … |
| | My c++ program using visual studio 2012 has one error that i cant figure out what. The error says " 1 IntelliSense: expected a ';' " I do believe that the eror from my program is after this part: cout<<"\n @@@@@@@@@@@@@@@@@@@@@@"; cout<<"\n @@@@ @@@@"; cout<<"\n @@@@ @@"; cout<<"\n @@@@"; cout<<"\n … Databases c++ mssql visual-basic visual-studio |
| | Hello All, I need a bit of advice regarding my final year project. I dont want any help with code but just on what path I should take. My project based on using triggers to solve business problems. I am not sure, on how I should approach this really. if … Databases sql |
The End.