1,079 Recommended Topics
Remove Filter  | |
| | Database systems and Administration Scenario: PEC offers several programs. Each program is supervised / chaired by a Head of the department (HoD) who is a lecturer. One HoD can lead only one program. There are several departments for each program. Many modules are offered by each department. Few departments are … Databases cybersecurity web-design  |
| | Hey I have 4 computers. 1st computer is my server machine. I want to install mysql on these computers. Can anyone help me to do that ? * I want to know how to install mysql on server pc ? * Also want to know clint machine ? Databases client-server mysql sql |
| | hi i have report in visaul basic 2015 in it the salary and i want to make a tetxbox and but the total in it i tried this Sum(Fields!salary.Value) but i get error Databases visual-basic  |
| | hello this code for add the auto number form the access table to the form vb but But it only works when the table contains data but when the table is empty does not work and the bill number appears a blank Sub New() InitializeComponent() Try Dim BillNo As New … Databases vb.net |
| | ...well i was wondering, what is the average size of an ordinary fb entry ? . Lets suppose there are 3-4 pictures and about 3 paragraphs of description. Databases client-server |
| | Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: `mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => Array ( [0] => 1 [1] => 186 ) [num_rows] => 1 [type] => 0 )` I then …  |
| | Hi all, I currently have two tables that look like this: COMMENTS +----+-------------------------+--------------+---------+---------------------+----------+ | ID | comment | profile_post | creator | created | approved | +----+-------------------------+--------------+---------+---------------------+----------+ | 1 | This is a test comment | 3 | 1 | 2016-02-26 12:26:36 | 1 | | 2 | 0 | …  |
| | Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. … Databases sql |
| | Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ? Databases sql  |
| | i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit Databases microsoft-access mysql sql |
| | Hi all, I am running a mySQL database on a webserver hosting multiple Wordpress installations. It seems that database is getting swamped with memory and going into a continual loop of shutting down and restarting. A reboot fixes the issue temporarily, but I have no idea what I can do … |
| | <?php if (isset($_POST['import'])) { $fname = $_FILES['patientcsv']['name']; echo 'upload file name: ' . $fname . ' '; $chk_ext = explode(".", $fname); if (strtolower(end($chk_ext)) == "csv") { $filename = $_FILES['patientcsv']['tmp_name']; $handle = fopen($filename, "r"); $i = 0; mysql_query("START TRANSACTION"); while (($data = fgetcsv($handle, filesize($fname), ",")) !== FALSE) { if ($i > …  |
| | I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need … Databases sql web-design  |
| | i am trying to generate daily,monthly,and annual report of contractor from stored data which include id,in time,out time,late in time,early out time, my project is in advance java i have used CRUD in each module,and phpmyadmin i ll be glad if i get answer of my question. Databases sql |
| | Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has … Databases |
| | Hello All. I'm trying to loop the following statement with PHPmyAdmin in order to add 1000 entries with the variable "i" incremented for each entry. (data and ip can be static) INSERT INTO 'TABLE'('id', 'data', 'ip') VALUES ([i], [06/03/2016],[192.168.0.1]) It's been 20 years since I've done any coding with loops. … Databases php |
 | How I can group concat of ids with limit 2 and order by id desc? Means, need all the ids except first two ids in desc order. select group_concat(id) as ids from private_tuition_teacher_pdf where client_id = 14 and teacher_id = 15 limit 2 order by id desc Databases mysql |
 | Hi, I have a scenario like XYZ company is creating a User management System , which allows to purchase for different company , so based on the package the system provides options to save last three or five user password to check and the max is ten . XYZ---| Total … Databases sql web-design |
| | Hi, CREATE PROCEDURE `FindDuplicateExpenses`(IN `strExpenseDate` DATE, IN `strProfile` VARCHAR(50)) NO SQL SQL SECURITY INVOKER SELECT PD.Code, PD.ExpenseAuthorizedRefAmount, PD.FullName, PD.ExpenseDate, PD.ExpenseNatureID, PD.Ignore_Expense, PD.Profile FROM tblExpenses AS PD, (SELECT Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID FROM tblExpenses GROUP BY Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID HAVING COUNT(*) > 1) AS SUB1 WHERE PD.ExpenseAuthorizedRefAmount = …  |
| | Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With … Databases microsoft-access microsoft-office |
| | I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
| | i am using php with xampp server and i am getting the following error while i am running the program. Unknown column 'firstname' in 'field list' (heres the program) CREATE DATABASE IF NOT EXISTS `customerdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `customerdb`; -- -------------------------------------------------------- -- -- Table structure for … Databases apache client-server mysql php |
| | I need to know about how to do a bulk delete in Hbase.. can anyone help me out.. with a example Databases |
| | hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance |
| | Suppose this is a Table Create Table Person( PersonID varchar(8), PersonLN varchar(16), PersonFN varchar(16), PersonADD varchar(64), PersonPH varchar(16)); so there are many enrty in that table.. So how to select the lastest row entry from that table? what will be the Mysql statement? take PersonID as a Primary key.......... Databases mysql |
| | I need some help in getting the table headers to sort the data populated to a table in MVC. I have implemented search functionality in which the user can filter whatever results by typing a name, but I need to also get the table headers to sort the information as … |
| | I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id … |
 | Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > … Databases sql |
| | When drawing DB relationship diagrams, do you usually show all the relationships? Because I seem to have lots of them and my diagram is geting very messy. Sample Pic attached, I didnt even fill in all of them in this diagram Databases |
| | I am learning mongoDB , version 3 and I wanted to create a collection with two fileds, a date field and a descrition field. When I try to insert a document with the below syntax, from the mongo shell, I get an error and do not know how to correct … Databases mongodb |
| | I'm working on shopping mobile application. The application is similar to ebay it have customer and seller. When user create account they can either create account as seller or customer. The payment will be by paypal each user need to provide their paypal account (Seller Paypal & customer PayPal) so … Databases mysql oracle web-design |
| | 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 need help in referencing the name of each individual database attached to a MongoDB instance. I just want to connect to a database with PHP and list the names of all the databases. In the code below I can connect to MongoDB instance and find all the databases. I … |
| | 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 … |
 | 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 |
| | 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 |
| | 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 |
| | 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 … Databases mysql |
 | 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 = … |
| | 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  |
 | 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 |
| | 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  |
The End.