7,494 Archived Topics
Remove Filter  | |
| | **Bold Text Here**Hi there I'm just wondering what the best or a good table layout would be for a little project I'm trying to do at work. I work at a temp to perm agency where companies use us for the probationary peroid of employement and then hire the workers … Databases database-design python-django sql  |
| | Dear All May you kindly help me. I have a windows login form in VB.net. I have a users table in MySQL. How can i use the users table in to login changes made to any table in MySql database. I only have 1 mysql databse user that i use … Databases mysql vb.net web-design  |
 | hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the … |
| | I dont fully understand this issue at all, it makes no sense to me for several reasons but ill liust the main ones i have code elsewhere that works just fine and is identical in function and setup i dont think the issue is a registry key issue, this i … Databases microsoft-access web-design |
| | FROM: ORACLE 9i Give the SQL statements that determine the following: 1. Which customers lives in New Jersey? SELECT * customer FROM customers WHERE state = 'NJ' 2.Which orders were shipped after April 1, 2003 SELECT * FROM orders WHERE shipdate to_date('01/04/2003', DD/MM/YYYY') 3. Which books are not in Fitness … |
| | HI I am a part of database testing team. I have imported a tables.csv file which contains two fields 1. table name- all the tables of a database 2. Primary column- primary column name of the respective tables. I am trying to write a sql query for getting the table … Databases |
| | -Hi, I'm having trouble with B.I. Media Solutions Auction (phpprobid) , I'm getting the error message: Fatal error: Cannot redeclare password_hash() in /home/betti397/public_html/includes/functions_login.php on line 147 I've been at it for hours. I couldn't see any obvious errors in functions_login.php but then I'm not much good at PHP code. Here … |
| | My current connection and echo code is as follwed: <?php $myServer = "Server_Name"; $myUser = "User"; $myPass = "Pass"; $myDB = "DB_Name"; //connection to the database $dbhandle = sqlsrv_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or …  |
| | I need some help with creating a simple search engine for website. Basic idea is that user will enter a string in search bar, which will compare in database key_word and get the reuslts. Lets say I have the following table on sql server database. |----|----------|----------------------| | ID | URL … Databases client-server mysql oracle sql |
| | Hello, I am in my 3rd year and would be required to submit about 5 project proposals next month. I am really interested in doing a project involving database but as many topics as i have seen look like i would get hooked mid way. So please if you have … Databases |
 | Hi, I am trying to open some dbf files and two of the three I am trying to open does so just fine, but the third one gives this error: "The Microsoft jet database engine could not find the object 'NewStructures'. Make sure the object exists and that you spell … Databases  |
 | some how mysql database in wamp server 2 got replaced by older database and i am unable to restore the database to the location (before being replaced by old data) from the latest backup i have . is there any way i can restore the data to my required position. …  |
| | **Bold Text Here**hi,Everyone ,please guide me that how i can install MySQL with window 8,problem is that my RAM is of 20 GB and Window8 consume 17GB on RAM .When i install MySQL my pc becomes heavier and slow ,please tell me how i can solve this problem .Thanks Databases mysql  |
| | Hello, I have my old Mail file on one computer and no longer have access to the same notes db. I need to move my files to another computer and access them. Also read me, that file doesn't work correct Databases laptop |
 | I'm working on a small web project (MariaDB LAMP stack) on my desktop but I'd like to be able to continue working on the project when I am away from home computer. I think I can sync my /var/www/html/ directory without a problem but does how can I export my …  |
 | We have a WCF web service hosted on Windows 2008 SP2/IIS 7 accessing an Oracle database. Usually data access works fine but during load testing, it often times out and logs an exception saying: Error occurred when processing XXXXXXXX Web Service Oracle.DataAccess.Client.OracleException Connection request timed out at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection … Databases asp.net open-source oracle |
 | Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for … Databases client-server mssql sql |
 | I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) `SELECT COUNT(Software) AS ActualQty FROM tblswlogs WHERE Software='MS EXCEL'` and (**Total** will appear in textbox) `SELECT MAX(used + initialqty) As Total FROM tblswlist WHERE Software = … Databases mathematics mssql vb.net |
 | Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 … Databases mssql sql windows-server  |
| | Hi there, I created a new table and forgot to set the primary key with an auto_increment. I went back and use: `ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);` However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' … Databases mysql |
 | I need to update my records normal password into Md5 passwords.my query was like that UPDATE testing SET password = MD5('Manojano234') This query was working fine but i need to add plain text also  |
| | I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a … Databases mariadb php web-design |
| | I'm struggling with my hosting company and have had to move to a new one fairly quickly. I've transferred the pages and the databases over quite easily, but have run into an unexpected problem in the form of the error message below. > Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to … Databases mysql web-server |
| | Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table Amount CreateDate 151.00 5 July 2015 567.50 19 July 2015 558.00 … Databases mssql |
| | Hi Guys I am trying to select and display on the RadGrid. i am using sqlDataSource. i have 2 Tables (Users and DealerShip). User table i have attributes (UserID(pk),UserName,Email,Phoneand DealerShipID(fk)) on DealerShip table i have attributes (DealerShipID(pk),DealerShipName) and now here is what i want to do. on my grid i … |
| | For loop error problem Method: for($i =0;$i<count('$std_id);$i++) { for($j=0;$jcount('$sub_id;$j++) { mysql_query("INSERT INTO mmst_tbl(std_id,sub_id,mark)VALUES('$std_id[$i]','$sub_id[$j]','$mark[$j]')"); } } How to solve this? instead of 138 rows it goes 2000+ lines Databases mysql |
| | Hi, I am trying to get same field name from different tables. And i am using like the below query to get the field name. I am expecting some other queries to get distinct 'function_name' column from 'N' of tables. SELECT function_name FROM base_table UNION SELECT function_name FROM firstcall_table UNION … Databases mysql |
| | Here I have this error java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) if I execute this thing GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION; then I have this error. ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO) Databases java microsoft-access mysql |
| | i want to clear all data in databse automatically for everymonth.iam using xampp. |
| | Hi, thanks in advance foy your time. I have in the past made a inventory site where a user selects from a dropdown what he or she has and saves it but this is a little different... What I'm attempting to do is this... User creates an account (have the … |
| | I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns … |
 | Hello, It would be great if someone tell me what is the exact difference between DDL and DML? Thank you Databases  |
 | this is my first time of creating trigger..I tried to create trigger using mysql to count how many 2007 data in the table when inserting new record but it not working....... My table have more than 50 data... CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright; … |
| | I am trying to update several rows in the database using mysql statement. My code is as follows. <?php $query = mysql_connect("localhost","root","toor"); mysql_select_db("busticket",$query); $result=mysql_query("Select * from ticket_reservation WHERE validate_status='No'") or die(mysql_error()); while($row=mysql_fetch_array($result)) { echo "<tr><td><input type='checkbox' id='name' name='name[]' value=".$row['id']."</td><td>".$row['userid']."</td><td>".$row['busid']."</td><td>".$row['numberofseats']."</td></tr>"; } echo"<tr><td><input type='submit' name='submit' Value='Validate Tickets'></td></tr>"; if(isset($_POST['submit'])) { if(is_array($_POST['name'])) { $qry … Databases mysql |
 | |
| | Please help me.... I want to upload up to 5 photos and save in database. I want by selecting photo it will upload automatically and then the selected photo will appear in the page. It will occure with one by one photo, up to 5 photos and the photos can … Databases file-system  |
 | Hi everyone, I have about 20 simple queries running seperately on loading a php page with mysql querying. On my localhost the page takes about 3 seconds to load but on the live server this is over 30 seconds. I'm trying to shave some time off but I'm having trouble … |
| | When I try to create a database with a non root user of MySQL I get this error. -> MariaDB [(none)]> create database cl_db; -> ERROR 1044 (42000): Access denied for user 'garrett'@'localhost' to database 'cl_db' How do I allow my recular username to create databases? Thanks. |
| | How can i design a simple php site with a database like facebook Databases database-design social-media |
| | Hi! I am facing problems with sql server 2008. I installed sql server 2008 and it was installed successfully. But when i went to start menu then only following features were displaying 1- sql server configuration manager 2- send errors and reports 3- sql server installation center. But other features … Databases client-server mysql sql |
| | The following SQL query would return 1 record with a min(unit_cm): select id, name, category, min(unit_cm), unit_Cost, unit_price, unit_costPerc from ( SELECT a.id, b.name, e.name as 'category', (d.unit_price - d.unit_cost) as 'unit_cm', d.unit_cost, d.unit_price, ((d.unit_cost/d.unit_price)*100) as 'unit_costPerc' FROM menu_items a, item b, menu c, price d, categories e where a.item_id_fk … Databases mysql |
| | I dont know how to connect C# to MySQL can someone help me? |
| | Imports MySql.Data.MySqlClient Public Class EmployeeInfo Dim con As MySqlConnection = _ New MySqlConnection("server=127.0.0.1;user id=root;database=bsit3d") Dim cmd As New MySqlCommand Dim da As New MySqlDataAdapter Dim dt As New DataTable Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Private Sub display_Click _ (ByVal sender As … Databases mysql |
 | hi guys, I have a question regarding databases which made me stuck in my recent interview. How we can identify unique records in any table without using any primary key or unique key ? Plz share your ideas... thanks Databases |
| | SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id='1' AND section_id='61' AND assignment_date='2015-06-30' GROUP BY subject; For above query , I am facing this error , what is the mistake, Error:#1305 - FUNCTION ssv.GROUP_CONTACT does not exist. |
 | Hello, Please as at this morning everything was fine, but all of a sudden all data record wiped off from 3tables in my database, now my client can't find records. Am using MYSQL, Visual Basic. Thanks. Databases mysql visual-basic |
| | Hello Everyone, So I've begun a new project, in an attempt to show off my progress with Javascript. I'm making a little text-based RPG. However, I would like for it to permanently save your character and their progress. Thus, I need a MySQL database. I won't lie, I've only used … |
| | hello daniwebers... I am really stuck with this design of tables for calendar. Here is the thing...there are employees in a specific company. Each employee accepts customers of the company per day. The number of customers is limited by the doctor on a day by day basis. So for e.g. … Databases mysql php software-architecture web-design  |
| | Hi all! I have developed my application in VB.NET that uses a mysql database. From my application, I can make mysql backups and restore them. When i take a backup, the result is a .sql file which is saved somewhere. But as usual, one can open that sql file with … Databases data-structure file-system mysql sql |
| | Restaurant | restaurant_id | names | Date | date_id | date | Time_slots | time_slots_id | start_time | end_time | restaurant_id | date_id | Reservations | reservation_id | No.of.people | time_slots_id| Relations between tables: Relation between time slots and restaurants = Many to Many Relation between time slots and date … Databases |
The End.