7,494 Archived Topics
Remove Filter  | |
| | [B][U]This is probably a easy an simple task to someone that can take only a matter of minutes, but im new to this[/U][/B] Please will someone help me with my coll work....i have been given a task to normalise this data in to 3NF an i am totally stuck help … Databases database-design finance user-interface visual-basic |
| | Hello all, I'm currently trying to setup a SQL View that's going to be used to pull info from a table and output it onto a label... Long story short the only piece I need help with is having the SQL view remove leading zeros from one column called "Reference". … |
| | attached is a screenshot of what my table already has for the URL micorosft.com. The column headings are the same as column names. Now, if I do the following statement: [CODE=MYSQL]select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';[/CODE] OR [CODE=MYSQL] select * from assign2 where keyword1 LIKE '%microsoft%'; [/CODE] I … Databases mysql |
| | Hi, I am attempting to write a query to return whether or not a particular items value entered is the lowest value and also unique. For example, if an item as 6 values against it e.g. user_id item_id value 1 101 3 2 101 3 2 101 4 3 101 … Databases mysql |
| | Well, I'm new here but you can halp me also. I have pretty big problem. I need to store large text (more than 8000 charaters) in variable inside of procedure and then execute that query with EXEC command. Problem is that varchar supports up to 8000 characters and text and … Databases mssql |
| | [/COLOR][/I]Hi all! I'm quite new with databases. Need some help on the case study below for my assignment: [COLOR="Green"]ABC is a successful business providing design and drafting services to the local construction industry. With rapid growth over recent years, owner Tony Daley can no longer track active projects in his … Databases database-design  |
| | I have a database named newbase and columns are 1. Itid 2. Itname 3. Itprice 4. Itquantity I get the sum of the price using itname and the query is [code=sql] select SUM(itprice)as total from trick where itname=’a’[/code] I got the result but now problem is that I want to … |
| | Hi all, In a table column, I have this address value: "Muehlgasse 1 86637 Wertingen GERMANY" I want to get only the GERMANY part on my SELECT code. I've tested this code: [code=sql]SELECT right('Muehlgasse 1 86637 Wertingen GERMANY',7)[/code] It works, but the '7' has to be calculated, because we have … Databases mssql |
| | i want to insert dummy data for testing my database.so i want to execute a single insert statement 1000 times. is there any function to do so or is there any script todo. if so plz help me Databases mysql |
 | Good Morning all, I need some help with loading a file into a sybase IQ table with the "LOAD INTO" statement. I have never used it before and I cant seem to get myhead around how I am supposed to implement it in my java app. I have a stateless … Databases oracle |
 | I can handle errors just fine on MySQL, but what about warnings? If I use the following code I still get to see the warning, while that is not what I want: [code=php] if(mysql_connect($host, $user, $pass)) { $conn_server = true; } else { $msg = "Fout bij verbinden naar de … Databases mysql |
| | Hello friends, I want to get the row position a table with respect to the primary key.How can I do that?.Please help me! |
| | Hi! I have this table: id table #people 1 ...1 .........3 2 ...1 .........5 3 ...4 .........2 4 ...3 .........5 5 ...1......... 2 i want to obtain the sum of people sitting per table. hope you can help me... Databases mssql |
| | I am using Wamp server, I reinstalled Wamp after uninstalling it to try Xaamp.I have completely removed all of the Xaamp files.Recently,I opened my phpmyadmin directory and discovered an error message which hinted to me that there were two MY SQL servers installed on my computer(please refer to [url]http://i89.servimg.com/u/f89/13/69/31/58/sql_mi10.jpg[/url] ). …  |
| | I am trying to write a SQL update query for a database column containing an incorrect value. In the JobHistory table (whose primary key = JobID), the ModifiedDt column contains an invalid value, specifically it contains a value from a pickup stop, but I need to use the value for … |
| | I saved a few stored procedures in SQL Server Management Studio. The default Save location, which I accepted, was C:\Documents and Settings\BobLewiston\My Documents\SQL Server Management Studio\Projects. (And yes, each stored procedure was in the form of an .sql file, and I assigned each file name root to be the same … Databases hard-drive mssql sql |
| | I'm looking forwards to attend such course: [url=http://unex.uci.edu/certificates/it/oracle_db/courses.asp]http://unex.uci.edu/certificates/it/oracle_db/courses.asp[/url].. look at the dates and time. Its quite intensive, my question: will i have a chance to write notes, because obviously i can remember all what i'm going to learn in one class, there must be my reference to review. Otherwise, it … Databases oracle |
| | Hi everyone, I am creating a student timetable. I have the table done in html and I now need to input the values in the database. I was trying to use something along the lines of [code]if(day = 'Monday' && time = '9') { echo(subject); }[/code] i keep getting an … |
| | Hi Everyone, I am facing one problem in inserting query when i am inserting value of textarea in database. Let me explain whole of this. i am working as a empoyee form in which form when we insert value of all information regarding leave of that employee . In this … Databases mysql |
| | HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any … Databases mysql |
| | how can we check whether the primary and foreign key are working in the database in mysql Databases mysql |
| | Hi guys, I've been programming for quite a while now and just jumped in to SQL and Stored Procedures due to a Uni project I have due in. I have a table called [B]tblWebsiteMember[/B] and tblWebsiteMember has 2 Columns - [B]ID[/B] and [B]Name[/B] [CODE]CREATE PROCEDURE CreateWebsiteMember @wbmName AS Insert into … Databases mssql  |
| | Hi, I need to retrieve the max and min values of the price field in my db. I have a item table and a category table. I am using $_GET['category'] to get the category name and then I need to retrieve the min and maxvalues only for the items in … Databases mysql |
| | I have a small database, at the present time, built for basic tracking and it has 5 rows ... trackid datetime uid emailaddress orgcodetrack It's populate with 10 records test data from 3 users (uid)... I need to return the total visits from each uid... Here's what I have so … Databases mysql |
| | I've written a few SQL stored procedures in a text editor. But how do I actually "store" them in (add them to?) a database using SQL Server 2008 Management Studio Express? I've tried to research this topic in Management Studio's onboard Help, but apparently Help assumes I know more about … Databases mssql |
| | hey, I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are: 1.userinfo: firstname, lastname, e-mail, username, password, coursecode, courseyear. 2.courseinfo: subject, time, day, semester, coursecode, courseyear. 3.sem1week1: username, coursecode, courseyear, day, time, … Databases mysql  |
| | hai i want a shell script to load data from a csv file into mysql table plz reply me soon urgent Databases mysql |
 | Question Details: Help Needed Hospital Associates own three private hospitals at different locations across the country. It has a centralize database for tracking patients admission and billing. The database schema contains the following tables: PATIENTS(PatientId, Name, Address,DateofBirth,AccBalance) ADMISSION(AdmissionId, PatientId(FK), RoomId(FK), AdmitDate, DischargeDate) ADMITDETAILS(AdmissionId, TreatmentId(FK), DoctorId(FK)) ROOM (RoomId, HospitalId(FK), RoomType, CostPerNight) … Databases database-design |
| | i had a table categories(cid int primekey,name varchar,description text,parent_id,created date,updated date) i want a script for insertion like this insert into categories(...) values(cid value,name value,..desc, parent_Id..); can i write the statement as insert into categories(....) values (1,'aaa','some text',[U]select parent_id from categories where parent_id=id[/U],date,date); just i wana know how can i … Databases mysql |
| | I have a query [code=language] SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime FROM radcheck LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName WHERE AcctStopTime LIKE '%2009-03-19%' GROUP BY radcheck.id[/code] I'm looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value … |
| | i have a database and it has a column thats id its auto incrementing and one called download_link i want to have that autofill with a url thats concatinated with my id so localhost/upload/downloadtest.php?id= adds the id and becomes localhost/upload/downloadtest.php?id=1 localhost/upload/downloadtest.php?id=2 localhost/upload/downloadtest.php?id=3 etc how could i do that be done Databases mysql |
| | i have a table holding files and each has a unique id eg. 1, 2, 3 etc. i have a column in the table i want to contan the link that should be <a href=\"localhost/upload/dltest.php?id=(number) eg. <a href=\"localhost/upload/dltest.php?id=2 i want that link to be auto created from the other information … Databases mysql |
| | These are just the tables.. STU(SSN [pk], Name, Addr) CLASS(Crs_id[pk,fk], Term[pk], Sect[pk], Fac_id[fk]) COURSE(Crs_id[pk], Description)CLASS_TAKEN (Stu_SSN[pk,fk], Crs_id[pk,fk], FAC(SSN [pk], Name, Dept) Term[pk,fk], Sect[pk,fk], Grade) CORE_CRS(Crs_id[pk,fk]) * term indicates year(4) & semester(1) (i.e, 20091 = Sp 2009) List the names of all faculty members who have taught every course in the … Databases |
| | Hi, I have managed to get a nested query to work partly, but i need to somehow add another nest, which i cannot get to work. To explain more, i wanted to firstly find records that did not exist in another table, to which i used the following [CODE] SELECT … Databases data-structure mssql |
| | I have a question about table design and normalization. The table in questions is: [code][U]WorkOrder[/U] WorkOrderID Submitted by dateSubmitted DesiredcompletionDate discription of task schoolID RoomNum DateStarted Datefinished cost of materials labor overhead completed by completion comments priorityid budgetid approved approveddate approved by approvedcomments[/code] Is that table nomalized? or should i … Databases |
| | Hello! :) I have a small issue with an AFTER UPDATE Triger I implemented on one table of my db. In my trigger, I do some validation and update others (not in inserted or deleted) rows of my table. Thoses rows are updated but are not triggering my trigger (similar … Databases mssql |
| | I would like to create a table in mysql, with one of the fields being images. Can any one tell me what type i should call the field, and also if i have to put in any special commands. thank you Databases mysql |
| | I have three tables in the mysql database. Let's say: Table: Human -> Fields: human_id (primary key), name Table: Attribute -> Fields: attribute_id (primary key), name Table: Human_Attribute -> Fields: human_id (foreign key to human table), attribute_id (foreign key to attribute table) Cardinality: Human Table to Human_Attribute Table (1 to … Databases mysql user-interface |
| | I have a registration page that needs one final thing and I'm a little stumped... In one table I have email, pass, gender, dob and the other I have company... In the registration page, I want to check that the company exists before I submit the form... Since I'm using … Databases mysql |
| | This set of code below shows all SQL Server Agent jobs that have failed for the date 200.03.29. The run_date column is an integer, but I want to run the code in such a way that the resultset is automatically generated for the day before the current date. The code … Databases mssql |
| | Hello, I am just starting to get into mysql and have a quick question: I have a table that has a datetime field, and i simply want to store that datetime into a variable and be able to print it, and also compare it to the current date to see … Databases mysql |
| | I am trying to use this syntax to no avail: [code=sql]SELECT C_Name, ORDERS.O_ID, SUM(ITEM_ORDERED.QUANTITY*PRODUCT.P_PRICE) AS TOTAL_PRICE FROM CUSTOMER, ORDERS, ITEM_ORDERED, PRODUCT WHERE CUSTOMER.C_ID=ORDERS.C_ID AND ORDERS.O_ID=ITEM_ORDERED.O_ID AND ITEM_ORDERED.P_ID=PRODUCT.P_ID GROUP BY ORDERS.O_ID;[/code] My 4 tables would look like this: [U]customer[/U] [U]order[/U] [U]item_ordered[/U] [U]Product[/U] PK C_ID PK O_ID PK,FK O_ID PK P_ID C_Name … Databases oracle |
| | Hey Everyone, First post to the forum so go easy on me... So here's the deal... I am writing the php/mysql for a page that updates my database with the values of a member who's membership details have been edited. I am having problems getting the values to update into … Databases mysql |
| | I just got started with ms sql server2000,and I need a big favor from the the house,which is:please what softwares do I really need to install to get started? Databases mssql |
| | Please how can I write a query to select list of building its building code and number of rooms in each building. Databases oracle  |
| | i had a table productcs with stucture as pid,name,description,applications,created_at as datetime,updated_at datetime. i will load the data from a csv file.now i want to insert the current timestamp while loading the data i.e the present time at which i am loading the data .is it possible to insert the current … Databases mysql |
| | Hello, The problem is I have made a second user account for my databases, every time I open the MySql monitor it doesn't prompt me for a username, it just assumes I want to log into the Root and asks for my Root password. It doesnt ask for a username … Databases mysql |
| | Hi, I'm not sure if this shpould be in PHP or here so apologies if I'm in the wrong place. I'm trying to encrypt a password and insert it into my database along with other data. Everything works when I remove the md5 password encryption. It doesn't work when I … Databases encryption mysql |
| | SQL QUERY [code]if ($_SERVER ['REQUEST_METHOD'] == 'POST') { if ($_POST['mylist1'] == 'm2') { $sql="SELECT Products, TABLE 1"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for any of our domains'; } elseif ($_POST['mylist'] == 'm3') { $sql="SELECT Products, Table2"; $rs=odbc_exec($conn,$sql); odbc_result_all($rs); echo 'With this package you can registar for … |
| | Hello, I am in a database design dilemma. In a web application I'm going to make, a table will be used to store colors. The stored colors will be in varying color systems (RGB, HSL, CMYK and LAB and/or HSV might be added later), so an enum field will be … Databases database-design web-design |
The End.