Databases Forum

Hey guys, quick question. I have a movie table which records information about certain movies. See below for the table structure. id Title Length ------------------------------------------- 1 American Pie 160 2 Van Wilder 115 3 Not Another Teen Movie 115 4, Road Trip 130 5 Shawshank Redemption 130 6 Scarey Movie …

help me how to select the record between two date...........................................

Can anybody explains me why following sql statements do not work with mssql? create table place (id int primary key, name varchar(64), parent_id int references place (id) on delete cascade); create table transport (id int primary key, name varchar(64)); create table trip (id int primary key, from_id int references transport …

I'm trying to wrap my head around a database that will maintain 'box scores' for sporting events and be searchable on a various amount of fields including how a player performs home and away and in wins losses. I can't figure out how to design the tables properly for the …

Hi everyone! Unexpected situation. Is there a setting in MySQL that permits a record to be output to the requesting page even though one of the two value pairs is incorrect? And if so, can it be changed? Here's the problem: I have attached a querystring to a URL. It …

Hai, ive created a SQL database, but now i want to place and use this on another PC. Is it possible to write the database files to a CD or DVD and then copy it to another PC? If yes then please explain how. Thank you

I've got this site that I've been working on that functions very similar to Digg/Reddit. Users submit headlines and the rest of the community either upvotes or downvotes them. Right now I'm just setting a cookie every time a user votes on a story, but this only lasts for awhile, …

As I have previously mentioned in another thread mysql and php are new concepts to me and currently I am having many problems. My question is a recommended setup. Can you please tell me about your current setup for working with mysql and php. I have read several things that …

i'm trying to display the data from one particular table. everything seem to run fine. but not the data from the table. Please advise, anyone. Codes is as below: [code=php] <?php include ("login.php"); $query = "select * from news"; $result = mysql_query($query); if(!$result) { die("could not query the database: <br>" …

I am currently working on this table. It will contain the transactions made. But the transaction varies, it may be a purchase order, transfer from inventory, rental, etc. I have different IDs for each type of transaction (e.g POID, TFID, RENTALID). My question is, should I place all of this …

I have a really weird thing happening in my database. It used to work fine but all of a sudden now when I preview the report, it shows up too large. Please see the pictures to understand what I mean. I have tried undoing every change that I had made, …

Hi The menu form that starts up when I open access has a bug in it...I wanted to close the form when a certain condition exists but I used the quit command (instead of close) so it quits access completely! I cannot get in to fix my bug. Is there …

The situation is the following I used phpmyadmin 2.11.5 on localhost when creating databases, but I have phpmyadmin 2.11.6 installed on my hosting account. I am planning to upload databases to hosting really soon and I have some questions about uploading databases to hosting. Can phpmyadmin version difference cause any …

would anybody please point out what is wrong with the "order table" .. i spent hours and can't figure it out why this simple table won't work. i appreciate it. [code] CREATE TABLE customer( cid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, fn VARCHAR(10), ln VARCHAR(10), phone VARCHAR(15)); CREATE TABLE address( …

Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word Freq 1 Book 9 1 Study 3 2 Work 4 2 Run 5 2 User 2 3 …

Hello, I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this: [CODE]user question answer Mike 1 2 Mike 2 1 Mike 3 5 John 1 5 …

hi..I'm just a newbie when it comes to oracle and I would like to ask for some help. I just would like to ask if how do i put in my menus in my forms? I cant seem to solve this problem. what property in the property pallet should I …

Hello, I've just migrated a website built with asp and MsSQL to a new server. The old server used MsSQL 2000 nd the new one uses MsSQL 2005. I know the database became slightly corrupted when it was uploaded. I was just wondering if anyone could tell whether the varchar …

i was trying out how to configure manually postgreSQL and mySQL database servers into Apache with php as a module. luckily i was successful in configuring those things. however, to have better management on mySQL databases in tried to install and configure phpMyAdmin. but i always encounter error (attached image …

Hi, I am trying to break each record into 2 records but failed Is it possible? What is the correct way to do it? Thanks in advance!!! For Example: I have a table that contains 100 records . Each record has the following 10 columns: Col1, Col2, Col3, Col4, Col5, …

Hi, first post, and am a real novice, looking at the problems and solutions posted here. I have a database (Access 2003) where I want to change the name of a field within a query (to be used in forms and reports), depending on a decision the user makes. Can't …

Hello Friends, I am a student. I have to complete a project and would like to learn few things from all you experts on ms access. I have to make a personal contact directory with id, date, name, address, phone, email and photo. To feed data, I have to make …

Hi everyone, I'm trying to write a stored procedure select statement which is a little beyond my experience level. I have a table in the DB called addresses which contains the following fields: [LIST] [*]address, VARCHAR [*]count, INT [*](a few more fields) [/LIST] My stored procedure will take in a …

Hello -- I am taking some excel spreadsheets that are being used to generate some reports and trying to document them as ERD's. It's been about a year since I took a database course and so am rusty on some concepts. I have attached some screenshots of my DFD's and …

Someone please enlighten me. I am just beginning to experiment with mysql and php on websites. I just took over a new site that had an exsisting sql file. I need to add a new table to the database and can not figure out how. If I just open the …

Please help me on designing an ER for the following scenarios.. * Guest do a hotel reservation * Handling the billing part for the activities that the guest does during his\her stay @the hotel Your help will be greatly appreciated, if anyone can help me...

I will pay 50$ over PayPal if you solve this problem for me. Post here if you are interested or email me at <EMAIL SNIPPED> I will provide the .sql file with the database Guidelines: -UPPER CASE for all SQL reserved words, and Mixed or Lower Cases for names you …

Hi Everyone, Is it possible for a table in MySQL to be updated on a regular basis from an Oracle database?

I need to create a er diagram which is a entity relationship diagram about a hospital. My professor gave us a case study and the data requirements are wards, staff, patients, patient's next-of-kin, local doctors, patient appointment, out-patients, in-patients, patient medication, surgical and non surgical supplies, pharmaceutical supplies, ward requisitions, …

Plz Help! We have installed Oracle 10g successfully but the problem is that after launching Oracle from Start--->All Programs------->Oracle-------->Database Control-DB Name a login Screen comes up. This login screen is coming up.However inserting user name and password and clicking on Login button ,the next screen does not appear. I have …

i am making the hotel reservation system database.cosidering the following customer(name,phone,address,city,creditcard no,etc) reservation(check in date, check out date, price, customer name, no of rooms) room (room no,room type, price)' but i am not satisfied with it.i have to keep record of hall and table reservation as well . i want …

I can open most of the FileMaker files on our network. But all of a sudden I've been getting errors when I attempt to open a couple of the files that were working fine all these years. When I try to open these problematic FileMaker Pro 5.5v1 files, I get …

Hey Guys, Thanks for taking the time to read this, I have the following, rather complicated queries that I am trying to join, and I've spent the past two days attempting to do so, but had no luck so far so any help would be very much appreciated. I have …

Hello, I've been given the task of transferring a website from one server to another. Unfortunately the website was written in asp and is linked to a MS SQL database and I haven't had much experience with either. It was using a MS SQL 2000 database but the new host …

Hi I have a database running on MSSQL server 2005. Now I want to move all my data in MySQL server 5. I am familiar with MySQL and PhpMyAdmin. Please help me what is the best way to do this. Thanks

i'm trying to write a query that list each team, team member, and their captain. Can someone please help me

hi how to convert timestamps to date in oracle, and please give me example sql statements help me thanks bala

I need to write a stored procedure to analyse appointments for the last 12 months. I need to get each salesperson (by ID) and for each person carry out a count of the number of appointments and count them by outcome (sale, second meeting , failure etc.) and then display …

OK this is driving me mad and it needs to be done for a deadline. It is just a simple query to update a few database fields. Here's the PHP for it. [code=php] $sql5 = "UPDATE videos SET title='$new_video_title' WHERE artist_id='$i' "; $query5 = mysql_query($sql5) or die( mysql_error() ); $sql6 …

hi all, I have been trying to convert my phpnuke setup over to mysqli.I am running it as mysql at the moment on apache 2.2.9, php 5.2.6 and mysql 5.0.51b.I have attached the unmodified file as i have been playing for a week and have got no closer. is it …

I have a form in jsp and if someone enters special character (like single quote ') in text field (ex L'orel) and submit, it gives a error. I know this is a special character conflict, but how can I override special characters by submitting a form through JAVA. Is there …

hai when the no of columns is 10 rows to be more than 2000 ....which type of insert is best?? INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ); or INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ),('jimmy','16' ),(' johnn', '19' );

Hi all, I hope someone can help me with this. I have been racking my poor stupid brain for days over this. I need a way to be able to create a view of the data in a single table. Let's call it tblStatus. Here is a list of fields …

Hello Friends... Tell me how to store my product information in xml file using php ... Is this is a replacement of my database... Please tell me any information on this... Thanks in Advance.. Shanti

I have a huge database with around 250 tables. But all the tables are the same ie. they all have all the same columns. These are survery forms from different stores and thats why they all have the same schema. When i converted all these files from excel sheets into …

Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section. I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried [ICODE] total = "SELECT COUNT(*) FROM Product" [/ICODE] …

Hi, My server machine is running on Windows XP and running MSSQL. I have another client machine which also installed on Windows 2000 and since i cannot install the whole MSSQL, I installed the Client Tools only. After installing,through my query analyser in client machine i can query the tables …

Hi there, Just joined the community! Been having trouble all day with the following select statement and MS Access database: [SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC] The [((date_of_referral >= #9/21/2008#)] section of works, so all dates …

We are working on an application that caters to a group of institutes. With the current database architecture each institute has its own database, with the same structure but data is different. But there has to be a common database that has some data which need not be repeated in …

Hi, Im not really sure if this is in the right forum but it is about MS Access so i thought here was as good as anywhere. Basically i am trying to make a front end for an ms database - and to be totally honest i dont know where …