7,494 Archived Topics
Remove Filter  | |
| | Hai, I used a table for generating grade for students. for thati used the fields: UpperBound[int] LowerBound[int] Grade [varchar(50)] I have some datas such as : UpperBound LowerBound Grade 61 70 D 71 80 C 81 90 B I sent the value 80.09 to Stored procedure. Stored procedure something like … Databases mssql  |
| | Hello, Just having a liitle problem here. Basically, I have identfied three entities, Bookings, Guests and Rooms for a reservation system for a hotel. A guest can have many bookings. A booking can have many guests. A room can have many guests. A guest can book many rooms. A booking … Databases |
| | Hi all, I have a problem in creating a matrix table using a PL SQL select query. The table should look like: [CODE] |---------------------------------------------------------| |--|-1-|-2-|-3-|-4-|-5-|-6-...-----------------------|100 | |---------------------------------------------------------| |A |A1 | A2| A3| A4| A5| A6|.........................|A100| |B |B1 | B2| B3| B4| B5| B6|.........................|B100| |.........................................................| |Z |Z1 | Z2| Z3| Z4|.................................|Z100| …  |
 | i have an interesting question for you guys. [CODE] SELECT S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME],SP.PHOTO AS [PHOTO] FROM SCHOOLPHOTO SP INNER JOIN SCHOOL S ON SP.SCHOOLID = SP.SCHOOLID WHERE S.SCHOOLID IN (SELECT SCHOOLID FROM #SCHOOLS) [/CODE] the Photo Field is an Image Datatype Field, i now you can use them … |
| | I have a table for Account Transaction. For each transaction a user must select a transaction category. These are stored in a second table which has a categoryID, description and a text box with only two values {'Income', 'Expense'}. Now in the report, I am grouping by Income/Expense. However, I … Databases microsoft-access |
| | I am thinking to use MySQL with my new Java project, it contains some code that creates database locally and store data in it. It is all fine on my machine as I have all requisites installed like MySQL server but what will happen when I give this developed software … |
| | I have an error on opening my site, where is problem in my site [url]www.iphonehdwallpapers.org[/url] Error establishing a database connection Databases mysql |
| | Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that … Databases microsoft-access sql |
| | I'm trying to create a database for a public library and I'm running into a snag when trying to formulate my tables based on the requirements I've come up with. Authors • Write books • Have publishers Publishers • Publish books • Have addresses and phone numbers Books • Have … Databases |
| | Hi everyone, I'm having a bit of trouble figuring out what to do here. Basically I have 3 tables shown below User Table [CODE] ID Firstname Lastname etc.... 1 James Hay 2 Someone Else [/CODE] Permissions Table [CODE] PermissionID UserID 1 1 2 1 2 2 3 2 [/CODE] Permissions … Databases mssql |
| | Hello ..... I writing sql statment on access 2007, all what I need to do is to get the max value of a column depending on the max of another column.. an exmaple of the data is as below: Invoice No-------- Document no--------Document Date-----Value 1001115600188757 /// 5100002019//////13/12/2010////////-30469.50 1001115600188757 /// 5100002018//////13/12/2010////////30469.50 … Databases mssql |
| | Hi, I want to know , how to retrive the table name from multiple tables from a database which having the maximum number of rows.... As i am new to oracle can anybody help me as fast as possible... Thanks Ashish Databases oracle |
| | Hi there, I'm having a problem getting values inserting properly. What I'm doing is inserting values into a table with an auto incremented key, I then use select to return this key and then I want to insert that into a few more relation tables. But its inserting 0 instead … |
| | Hi everyone, I have a stored procedure which takes 2 integer parameters and returns either a 1 or a 0. It's quite long so I won't post it here unless you feel it's nessesary. Currently I have a table named 'Books', a table named 'Filters'. Each row in 'Books' has … Databases mssql |
| | I have a mySQL database of individuals who do several different activities at various start dates in the year. I need to sort all the data by start date. But because each record contains several activities and associated start dates, how can I best extract this data for sorting? For … Databases |
| | Is there anyway to do it? I find a msoft tool that does it for sql server 2005. There is an import feature in sql server 2008 but it doesn't do it correctly. Anyway to convert my database with all its relationships to sql server automatically?? |
| | Hello, I need help with a query. I need to find the Sum of Distance of T# 1 But there isn't Adelaide -> Melbourne So I'll have to take the value of Melbourne -> Adelaide which is 400 How can I handle this problem? I can do them in a … Databases oracle |
| | I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there. Aside from that I'm trying to build a query that provides me with counts of the games so I … Databases database-design mysql sql |
| | Can you help me with the following Mysql question? I get a table, say, three variables: ID, Date and Value, for example, ID Date Value 1 2001 2 2 2005 3 3 1986 7 4 1985 1 How can I add a variable, sum, to each line, with the condition … Databases mathematics mysql |
| | |
| | |
| | Hi, i am currently doing a system for the rental video. I am new to java coding.. Problem is how to add data to access database using java coding in method? Thank you. Databases java microsoft-access |
| | I am sure many have seen this problem before (yes, it is for a class ) I have started it and think its "close" But I am not sure about the relationships, any help would be greaty appreciated. Below is the problem disreagrd the attached word doc our regional Oracle … Databases engineering oracle storage unix |
| | I am following a course on lynda.com First I had XAMPP, but I had some problems with it, and when the guy who was explaining everything used WAMP, I thought it was easier to just uninstall XAMPP and install WAMP. So i did that, but the XAMPP installer said it … Databases mysql  |
| | Hey all, Can any when tell me how to loop and put if-conditions in sql query? as I am new in SQL i am a bit confused about this please help me i have very short time. Thanks in Advance Databases mysql |
| | Hi, I have a problem with my Normalisation. The case is that I need it to pass the module in college. I have a great difficulty with doing my 3NF of Normalisation, would you be so kind with helping me to achieve this criteria. This is the table upto 2NF: … Databases |
 | 1.Are these steps also known as Schemas? 2.provide me very short details on each step please. ex |conceptual design : 1.ER diagrams are used 2.based on User side <<<like that shortly. thanks Databases |
| | i am working on a java project, one of its web pages includes this query:- [code] select pname,age,gender,dscrptn from patient where curdate='05-17-2011' and docref='arshdeep' and meet='no' [/code] but it is not working, i executed this in MS SQL, BUT ITS SHOWING ONLY THE COLUMN NAMES THERE. i.e pname age gender … Databases mssql |
| | Hi, I have a MySQL DB and I am trying to set up a report page. To do so I need to be able to add the data in 6 or 7 fields into a single field for use in a summary report. How can I do that? SUM() seems … Databases mysql |
| | [CODE] $qrysc = "select * from `communities` where `name` like \"%$key%\" or `type` like \"%$key%\" or `about` like \"%$key%\" union all select * from `personal` where `fname` like \"%$key%\" or `lname` like \"%$key%\" or `country` like \"%$key%\" or `state` like \"%$key%\" or `city` like \"%$key%\""; $rqrysc=mysql_query($qrysc); $numqrysc=mysql_num_rows($rqrysc); [/CODE] Here communities … Databases mysql |
| | hi i have some question to ask everyone . 1.How make open form in full screen ? 2.Example: I created two completed forms,frmLogin and frmStudent and saved it name "Student".what i want is when i open saved file,i want it only show frmLogin auto(full screen) without choose a form from … Databases microsoft-access |
| | Hey, We got an assignment to host a website, our members must be kept in a mySQL database. I honestly have no idea where to start. If you could just help me with the basics steps. Ill research the details myself. Here's what I've done so far. 1.I downloaded and … Databases java-netbeans mysql web-browser |
| | Hi, I am writing a MySQL script. I used a parameter file to set a user variable [CODE]set @log_file = "C:/logs/table_creation.txt";[/CODE] I used the variable in another file in the tee command as follows [CODE] set @log = concat("tee ", @log_file); prepare stmt from @log; execute stmt; [/CODE] But it … |
| | Hello All, Need help in importing CSV files into Mysql. I have tried all the methods which I can think of but im not able to import it. attach is the CSV file which Im trying to import. Below is my MYSQL table structure: mysql> show columns from test; +---------------------+----------+------+-----+---------+----------------+ … Databases mysql |
| | Hi I have a PHP/MYSQL driven site. When a user creates a new account or updates their existing username or email address I do a quick check to make sure the requested entries are not already in use. I am concerned that in the few milliseconds between the SELECT and … |
| | What is the diffrence between Key and Superkey how can we understand ? help me please Databases |
| | |
| | |
 | Hey all... I have assigned a job to create back of the databases of our company, maintain it for 7 days and after 7 days delete the back... I have worked on this and make it up the following query but still confused on its authenticity. Please Check and tell … |
 | Hey everyone, As many of you know, we've been having serious database issues here on DaniWeb lately, causing the site to go down just about every single day for a few minutes. We finally got the situation resolved thanks to our database sysadmins over at Percona. While James and Cameron … Databases mysql |
| | Hi. I'm programming an e-commerce/online store using servlets and a MySQL database, and I'm having some problems with the db right now. Hope somebody here smarter than me can give me a hand. There are two kinds of users, both having their own table in the db: customers and admins. … Databases mysql |
| | Thanks so much guys! That solved my problem.. I have another question.. Find the names of all restaurants together with the names of diners who visit the restaurants on 24 April 2011. IF no diner visited a restaurant on the day, include a name of restaurant with no value in … Databases oracle |
| | I;m trying to move a database created with WAMP from one computer to another. I've exported it as a .sql file and imported it by creating a new database and then importing into it. The problem I'm facing with this approach is that none of the data in the tables … Databases data-structure mysql |
| | I managed to duplicate a single record. However I intended to display the duplicate record with different values. For example: A ABC 065 001 A10111 Sell 54.847500 0 0 T ABC 065 001 A10111 Sell 50.847500 0 1 [CODE] SELECT case i.ordStatus when 'Queued' then 'N' when 'Filled' then 'A' … Databases mssql |
| | I'm having trouble with a MySQL INSERT query. I've used this exact code in many places, and even in different pages on the same web server. I feel like I've tried every variation of INSERT query with no luck. Here are a couple that I've tried so far: [CODE] $name … Databases mysql web-server |
| | Hi, I'm having a little trouble figuring out how to show some of my relationships in an ER diagram and was hoping for some help: Authors([U]aID[/U], aname, abio) Books([U]bID[/U], title, summary, quanity) Format([U]fiD[/U], formatType) hasFormat([U]fID[/U],[U] ISBN[/U]) bookFormat([U]bID[/U], [U]fID[/U]) libraryBook([U]libRef[/U],[U] bID[/U]) Section([U]sectionId[/U], sectionName) Cardholders([U]cardNum[/U], cname) Address([U]addID[/U], streetName, City, PostalCode) cardholderAddress([U]cardNum[/U], [U]addID[/U]) … Databases |
| | Hi Guys, I'm not good in Oracle, I need a help in Oracle Developer Suit 10g, I got stuck at the beginning of this project & expecting a help from you all. I need to create a Wedding Event Planner & to design forms for that. Before designing that I've … Databases oracle |
| | What is a superkey?(better,with examples).what is the difference between composite key and a superkey? composite key= compound key? Databases |
| | Hi, I need to know more about oracle database. 1)Introduction. 2)Importance. 3)Advantages and disadvantages. 4)Effects. 5)Diagrams. 6)Features. Databases oracle |
| | I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false … Databases mysql |
The End.