7,494 Archived Topics
Remove Filter  | |
| | Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has … |
| | Hi, I am working on a Inventory & Billing Management System. I am having some problem with the design of some tables. The problems are as follows 1. I have a product table. Where I am storing the product details, but the problem is that each product have an unique … Databases database-design  |
| | Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open … |
| | Dear Friends, I am new to sql, I have 2 tables named as payroll and employees. My payroll table has many columns as per my requirement. But I am giving here only few columns of my table.Few columns of payroll table has data in following format: empid, month, year, basicpay, … Databases mssql |
| | I would like to develop a database system using ms sql server 2005 express or 2008 express edition where the data may store in other than english language into tables. so i did it using mysql database but not working in 2005 express edition. Is there any solution? |
| | Is there a way to create a program to rewrite a query in an optimal form. If so, how? What can I do to implement this. Rewrite SELECT EMPOYEE.EMPNO, POSITION FROM EMPLOYEE E, JOBHISTORY J WHERE E.EMPNO = J.EMPNO AND STARTDATE <= ENDDATE AND SALARY <= 3000 into SELECT EMPLOYEE.EMPNO, … Databases mysql |
| | ProductID | id | TaxDescription| 2009001 | 1 | Excise 2009001 | 2 | Edu Cess on Exc 2009001 | 3 | S.HS.EduCess-Ex 2009002 | 1 | Excise 2009002 | 2 | Edu Cess on Exc 2009003 | 1 | Excise 2009003 | 2 | Edu Cess on Exc 2009003 … |
| | Hi All, I hope someone can help. I confused with one part of my coursework. "For each booking there are a number of payments. There are three types of payment: the deposit (usually made when the holiday is booked), the balance (the rest of the cost, which is usually paid … Databases |
| | I get error while connecting to server .i have sql server 2008 r2. [B]can not connect to local A network related or instance-specific error occured while establishing a connection to sql server. the server was not found or was not assible. verify that the instance name is correct and that … Databases mssql |
| | I have details stored in a database of a web site firstweb.com I have created another web site secondweb.com I want to use data from database of firstweb.com Is this possible ... Assume : I have all user id and password for both these databases If YES, how to do … Databases mysql |
| | I am using SQL2008. I want to generate log file of each and every transaction carried out on my table. How can i do this? Databases mssql |
| | I'm new in using MySQL and I have to do a project where I should implement 6 queries within the database that I have created. The queries that should be implemented are union query, aggregation query, nested query, and three join query. Here is the script for the database. [CODE]create … Databases mysql |
| | HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in … Databases microsoft-access sql visual-basic |
| | My Alter Table Editor Window Not Coming Up in Mysql Workbench? PLEASE CAN SUM1 HELP ME! ^_^ My Alter Table Editor Window will Not open up.. Is there a way to make it open???? Im using Mysql Workbench Thanks! Databases mysql |
| | hi one simple question please. I have three tables. [CODE]GROUP id area 1 Multimedia 4 Education Employment id foreign key(GROUP) job 1 1 designer 2 4 professor 3 1 copy and now suppose that i have this SpecificProperties id foreign key (Employment) properties 1 1 type of contract 2 1 … Databases database-design multimedia  |
| | I would like to know how to a use a text box in winform to name the table . can anybody help me please I am using the following statement to create table SQL = "CREATE TABLE tbCatalogue ([Id] COUNTER, [Stock Code] TEXT(10), [Account Number] TEXT(6))" Databases mysql |
| | I have these two queries which i want to run together and not one by one. How can i do that? Or can it be modified to be one query. [CODE] UPDATE runquery.table1, runquery.table2 SET runquery.table1.`Column1` = (runquery.table2.`Col1`/runquery.table2.`Col2`*100) Where runquery.table2.`itemid` = 3 and runquery.table1.`Userids` = runquery.table2.`userid`; UPDATE runquery.table1, runquery.table2 SET … Databases mysql |
| | I'm using mysql and phpmyadmin to create a video rental database and I've been having problems with the auto_increment feature and the numeric data type. I have auto_increment on multiple tables for their table id's. The problem is when i enter data into the tables the counter doesnt reset. So … Databases mysql |
| | Hi, Need some guidance here parts of my DB need to be updated by data from another system's DB, what I'm gonna get are CSV files with data that isn't exactly the same as my DB, meaning, the tables aren't the same structure, the fields don't have the same name/format..some … Databases data-structure mysql |
| | Hi All; I have a MySql database set up called users. The only things required to register to my website are a username and password. When this is completed, the database populates with the users info as requested. How does MySql make this new users permissions to have it where … Databases mysql  |
| | I'm not sure if this is the place for this post but I didn't really know what it fell under so I apologize in advance if this belongs in another forum. I'm looking at creating a new online app for myself and others to store certain types of data. I'd … Databases app-store |
 | Hello, What I am making is a block of code where it "balances" the load for support tickets on a website. I know that my setup may (most likely will) not be the best. I'm looking for working, not a lecture on how to do everything and have it all … Databases mysql |
| | Hi Guys I am new at oracle(SQLPlus ,as well) I am trying to run a sql file which contains more than 500 alter statement which is suppose to alter all of my tables.After running the @alterTab.sql in sqlplus the result display at cmd command but I can's navigate to previous … Databases oracle |
| | hi all, l created php submission script and l wanted to how l can create another script which allows me to view all the submissions made in an orderly manner? Databases mysql |
| | Hi all, was wondering if I could get some help with my code. I want to be able to insert a person and details into a database, however i keep getting a syntax error, and not very experienced so was hoping some one here could help. thanks dbConfig.php [code=php]<?php // … Databases mysql |
| | Hi, I am trying to come up wit a database design for a small school. it works this way: in AC-Year, there are 3 terms with each term having 2 semesters. New students get registered at the start of each term. A student may take entrance exam. if he fails, … Databases database-design microsoft-access |
| | Can anyone help me figure out why the table movie_actor cannot be created and how to fix it? I know it's the only table without a primary key, but I don't see a need for one. [CODE=MySQL] create table actor ( actor_id int not null auto_increment, first_name varchar(20), last_name varchar(20), … Databases mysql  |
| | I have recently started a web company in China using MySQL and PHP as the development environment. Apparently the common practice here is to not create relationships between tables. They would draw out the relationship in the logical ERD, but when it came to the actual DDL, they would only … Databases |
| | Hi everyone, I'm new to this oracle database, and i have a question. first I'm sorry if my question is misplaced. My company recently implemented a new ERP system, but unfortunately the ERP system doesn't have a financial module on it. so we planned to buy an oracle financial. and … Databases oracle |
| | |
| | I'm trying to load a CSV file into a database table, but having some issues. [CODE] LOAD DATA LOCAL INFILE 'Report_1.csv' INTO TABLE report_1 Fields terminated by ',' ENCLOSED BY '\"' LINES terminated by '\n\r'( company,key_code,dlr_code,rep_code,dlr_name,first_name,last_name) [/CODE] This gives me the following error: [ICODE] File 'Report_1.csv' not found (Errcode: 2) … Databases mysql |
| | Need to create a function Hands‐On Assignment 6‐4 with modifications: Identifying the day of the week for the order date The day of the week that baskets are created is quite often analyzed to determine consumer shopping patterns. Create a function named DAY_ORD_SF that accepts an order date and returns … Databases oracle |
| | This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result … |
| | got this table that I need to put into a db so that when 2 values are selected it gives you the result i.e colum 120 and row 1.5 would give you 2, im pretty new to this so any help would be great[ATTACH]20644[/ATTACH] do i need 2 tables im … Databases |
| | Hello, I've got a problem with simultaneous placement of an order in a webshop. I will start off with a general description of the problem, and provide details after that. **The problem** Orders are stored in the table 'orders'. Each order has a BillNumber, which is obtained via a mysql … Databases multithreading mysql |
| | Can anyone tell me what is the difference between case and decode. and which one is more beneficial Databases oracle |
 | we have a mysql server running from mac os x. i dont like mac but the server has been here forever. a client machine received the 'too m any connections to server' error. my colleague restarted the mysql server - and now the mysql server service will not start. does … Databases client-server mysql os-x |
| | hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks Databases microsoft-access perl |
| | hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to … Databases microsoft-access |
| | Hi Guys I recently installed the SQL Server 2008 R2 - Developer on the top of Windows Server R2 (Standard) on VM machine hosting by windows 7 64 bit.I Installed a default SQL Instance and I didn't get any error message during installation and everything goes fine but now when … Databases mssql sql windows-server |
 | Hello I have been using SQL for a number of years, but I am struggling with an intermediate query. I want a record to be displayed as below [ICODE] 1 Ademola Adebayo 4 Women @ West Street Member 2 Christine Adebayo 4 Women @ West Street Leader [/ICODE] when I …  |
| | I want to make a query that would return data about students who failed in a specific course, the report is looking like this- studId, studName, last grade, year last course was taken, num of fails in this course. so I'm having problems writing the correct SQL query to get … |
| | Hello, I have not used Sql server. I have microsoft sql server 2008 installed. but when i click management studio, it says evaluation period expired. I can download sql server 2008 r2 developer from my university site. Should i go ahead and download sql server 2008 r2 developer and uninstall …  |
| | Greetings everyone, I'm a noob here. I could use some help designing part of a MySQL database I'm working on. This is an event database, so think of say a conference. I have sessions and every session has a session_type. A session_type might be a Keynote speech or a Workshop. … Databases database-design mysql session web-design |
| | hey! i need to create a customised table "Employee" in which i have to insert employeeid,employeename and salary...on inserting the salary,the table should automatically calculate Hra(10% of basic salary),DA(9% of basic salary) and hence calculate net salary...so...plz guide me...how to do this? |
| | Hi, i am still stuck in SQL query about how to retrieve data from two tables. I have two database tables- Forecast [CODE=text]------------------------------------------------------------------- TimeStamp | Temperature | Rainfall | Wind | City_Code ---------------------|-------------|---------|-------|------------- 2011-03-13 10:00:00 |22.2 (degC) | 0 | 7 | 1 2011-03-13 11:00:00 |23.1 (degC) | 0 | … Databases mysql |
| | Is this a correctly made JOIN: [CODE] // Build SUBJECT navigation and gather SUBJECT data here-------------------------------- $sqlCommand = "SELECT id, linklabel, pos FROM subjects INNER JOIN pages on id = pages.subjectid ORDER BY pos ASC"; $query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()); [/CODE] ? Klemme Databases mysql |
| | Hi I have a project whichs hould be achieved in a very short time I need others to work with me in DFD and DRD , my initial dfd is posted as al ink at the end of this topic. ONLINE POST – OFFICE MANAGEMENT SYSTEM Introduction : – TARS … Databases |
| | [CODE]I am having two tables in MS SQL SERVER 2005 in master database. 1st table is Country & 2nd is City. [COLOR="Red"][B][U]I want to know the command for Copying a Column(with values) for eg say Name from City Table to Country Table. Column is not empty, its having values(data entries). … Databases mssql |
| | Hi guys, I am working on a web application project where I use MySQL database. Now I need to export my database/table as a CSV file and I'm using SSH client to access my MySQL. I have no clue how to export it. I would really appreciate if someone could … Databases mysql |
The End.