Databases Forum

dear, everyone... i need solutions. i have several tables in a database. this is tabel_jawab [CODE]kd_jwb nis kd_mk jwb1 jwb2 jwb3 jwb4 jwb5 321 654 2 A B A C B [/CODE] i input them via jsp to mysql table. i have these table too named tabel_kunci [CODE]kd_jwb kd_mk Kjwb1 …

Hi! i have problems one query. $day_result has a value of 1 and 4 $sql3 = "Select * from Venue where idVenue != $day_result"; echo $sql3; if i use for loop for the above it will give the result below Select * from Venue where idVenue != 1 Select * …

I'm not all that certain how to go about this, but here's what I am trying to do: Firstly, coding in PHP and using MySql DB. I have a table (called overall) that holds each individual Softball teams stats. fields are: 1. team (team name) 2. gp (games played) 3. …

Erm, well I'm having heaps of trouble telling the difference between what the bracket value bracket thingies do... [like tinyint(1), tinyint(2), tinyint(3)] I've read this, but I can't seem to understand it >.< [QUOTE]Another extension is supported by MySQL for optionally specifying the display width of integer data types in …

ok I had an insert query that worked fine when using Access as my datasource, but I wanted to start using MySQL, so now when I run the insert statement, I get an error that says Filed "bulbID" doesn't have a default value. This error didnt occur with Access, so …

Hi I am new of ERD design. I have drawn the diagram but for the supertype, subtype and entity associated part, I am not confirm the way I presented is correct or not. I hope to get some advises from you all. ERD 1. A distribute places an order 2. …

Hi newbie here I’m currently making a hotel booking system in mysql/php, but I’m having problems with overlapping dates/double bookings. For example if a user attempted to book room1 from the 1st august to the 5th august, but the room is already booked on the 3rd and unavailable on the …

Hi. I am new to this forum/community and need help to join multiple result sets in SQL. The last time I used SQL was in 2000. The goal is to provide one single data set result from multiple queries. I have included the code from two queries that I have …

I have some text with Cyrillic and Latin (š, đ, č, ć, ž). How can I store that data in MS SQL 2008. I tried to store word 'Palačinka' but instead of 'č' i get 'c'.

Hi everybody! I'm having some problems and hope to get help in this forum. My website name is SNIP. At this time it is setup as coins website. I'm trying to reinstall original categories to make it a full auction site. When I ran SQL dump file that was given …

Sometimes when I view my webpage, which has a search form on it and then search for records in my database, and I let it sit there for a few minutes and then refresh or hit the back button, it throws up an error saying: "500 Internal Server Error: There …

HI this is my code.it uses access database.But givs me this error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. import java.sql.*; public class DetOrderNum{ public static void main(String[] args){ Connection con=null; ResultSet rs=null; Statement stmt=null; int pkey=0; String mn="jin"; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:MY-PIZZA","",""); String q="select order_num from Order …

I have table something like [ID, ITEM_ID, URI, IMAGE_FILE_NAME, UPDATED_AT etc.]. I need to compare URI that can be something like /system/images/777/medium/Debrecen_-_University.jpg?1279547675 with IMAGE_FILE_NAME that is as Debrecen_-_Protestant_Great_Church.jpg Is there a way so I can provide IMAGE_FILE_NAME as sort of substring of URI and check if that substring is part …

I have alot of tables in database in one of this contains owner_id and another one have relation many to many with that,and that table have dissent_type how i can select dissent_type where owner_id = ""

Ok now that I have the basics of table import done, I now am having trouble figuring out how to transfer the database from my local server to my remote server. I thought when you right click on the database and then select data transfer this would work. I must …

Hi All, I have been pulling my hair out over this one. What we are trying to do is pull sum values for the same item out of three different tables in the same DB (MSSQL '05) – Should be quite straight forward however... The result should look a bit …

Hi.. im new to web development and we have to do a web development project as part of curriculum.. we are doing Airline ticket Reservation System.. one of the requirement in the project is user should be able to select a seat of choice,if available. I was wondering how to …

Hi Everyone. Could someone assist me in the query. The table has type_of_vehicle field. In this field I have A, B and M. I would like to create a query where I can specify to select A and B, or A and M or A,B,M. Hope someone could assist me …

Hi, Is there any way to do this? I tried using a 'select scope_identity()', but that returns null, apparently because my identity column is not a numeric of any sort. An answer to this would help me a lot! I would love to not have to use an integer or …

hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it

I was wondering if someone could help me with a mysql indexing problem. The index of 'username' for this code works fine: [CODE=mysql]EXPLAIN SELECT count( * ) AS num_messages FROM messages, users WHERE messages.username = 'johndoe' AND users.username = 'johndoe' AND messages.sent_date >= users.last_activity[/CODE] Here is the explain: [code] id …

I have work in a high school and I am working on designing a database for a tardy calculator. It will be Internet based. I am not real sure how I am going to set up the database though. So I though I would throw it out there and get …

I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to …

Hi, Does anyone know if there is a way in MySQL to have it return the column names qualified with the table name? For example, suppose I have the query, SELECT * FROM Items, Sales; and the tables Items and Sales both only contain columns named ID and Count. By …

Hello Everyone, I need to upload excel sheet in to the database. Which i am doing with the query [CODE] SELECT * INTO temp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls', 'SELECT * FROM [qry_BA_Controlling (Report)$]')[/CODE] Here C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls is the path from where the excel file needs to be …

Please how can I write a query to display only the top three earners in a table in desc order e.g Emp Sal John 100 Jam 120 Abi 90 Jo 170 the query should display Emp Sal John 200 Jam 170 thanks

Hai Everyone.. I am new to this forum & MySQL.. I hava a table like this [code=php] iss_date item_code aa bb cc 2010-06-05 abc 10 15 15 2010-06-10 cca 20 20 20 2010-06-12 abc 12 12 12 2010-06-13 abc 13 13 17 2010-06-15 cca 18 17 24 [/code] I need …

Hello everyone, I am creating a webapp of employees. Now each employees has fields such as loginId, firstName, lastName, email, last review date, last reviewer, last review type and I can go on and on. My question is each employee has ONLY last review. So what is the best way …

Hello So, recently I obtained a horrid assignment from lé boss, and I have yet to figure out how to do this. The idea is to select the ID(db_medlem) of all customers that have purchased for over 1000, in the year 2010. (I know its a funny syntax, but its …

I am not a developer, but I am trying to learn SQL to write reports for auditing our data. I want to extract empoloyee contact information, because I feel we are missing some CREATE_MIRROR_FLAG. I found the contact information on the per_contact_relationships table, but now I need to find the …

I have a database with two tables: [B]books[/B], the fields are [B]title_id, title, pages, publisher[/B] [B]author[/B] the fields are [B]author_id, title_id, author[/B] I can INSERT ok into either table as a speparate entry but what I would like to do is enter the data into both fields from a form …

Below are my stored procedure to change password and the VB.net code to call it. The Sored Procedure executes properly and returns correct values when executed from SQL Server directly, but it does not check its conditions and returns -1 when called from VB.net code. please help me in this …

I know I am missing alot, but I am new to mysql and I have to make a table for a used car dealer which includes make,model,price and mpg and I am confused. I have to configure commands with sample data to enter at least one record in each field. …

consider columns name,sname,id. i want id to be first in mysql

Hi, I am Installing XAMPP in Windows XP but when I start my computer it gives the dialog box with "mysqld.exe not found" and when i start the localhost/phpmyadmin the following errpr is occured "#2003 - The server is not responding " pls some one give me some solution of …

Hi, i want to retrive data from a table which has a composite primary key. This is the query im using; "select price from Item_size where primarykey='"+pk+"'" But it does not work. Im using MS Access. can anyone help me!

Hi all. I am working on a small credit/debt management tool. I have a table that contains the main record for the debt: id, amount, client info, interest, paid back, etc Then I also have a "history" table where all operations on a debt are stored: when it was first …

I have a rather embarrassing problem. While debugging a web app, I suddenly found I was not retrieving items from the database. I went to the command line to log into MySQL and got back "Error 1040: Too many connections." This was when I realized I'd forgotten to include a …

hi, I need to update my data in two tables simultaneously,for example if i update product id in one aspx page it should be updated in my sql tables where i use product id in all my pages we can join tables to view data but how to update.. hope …

I run a small database for a very small business. I am normalizing our database which keeps track of our orders for repairs. I have one of the tables in 2NF but I am not sure how to normalize it further. Here is an example of how it looks: [code] …

Hi, I am new to php and have to do a project that consists of a joke page, a jokelist page and the front page or index page. My problem is this: I have used the text below in my .htaccess page and the only thing I get when I …

Okay, so I've got THREE MSSQL Tables. First table is: Eponyms : ID, NAME, DESCRIPTION, CATEGORIES Second table: Categories : ID, CATEGORY Third is the intersecting table: EponymCategory : ID, EponymID<FK>, CategoryID<FK> The "Eponyms" table has the list of Eponyms, and the CATEGORIES column is inserted with data like "PSYCH …

Hello, I have a database where content (song lyrics) is stored in multiple languages. But now that i'm testing it some characters do not appear correctly. For example, when i'm retrieving information (searching anything), the letter ë appears as � (a special character square - in case it doesn't appear). …

Hi, I'm a recent IT graduate, I want to upgrade my skills from what I learnt at college to the SQL Server 2008 platform. I want to also get certified with Microsoft, it seems a lot of companies are asking for this now. If you have gone through the certification …

Of the DB operations I came to is the [B]Division[/B] operation. I really tried to understand this operation from different sources but didn't get the idea of this operation. Can someone thankfully describe it or at least direct me to a source that explains this operation clearly? Thanks.

This is my two tables: [CODE] CREATE TABLE `subject` ( `id` int(11) NOT NULL auto_increment, `subjectName` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `subject` -- INSERT INTO `subject` (`id`, `subjectName`) VALUES (1, 'Maths'), (2, 'Science'), (3, 'English'), (4, 'Chemistry'); …

i have two entities. I want the data between them one to many and many to one. But not many to many.How can i implement this using ER diagram and then into relational tables.

Hello, I am getting a syntax error in the following code, any suggestions what I need to modify? Thanks "Script line: 7 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line …

consider form . id,username,age,etc if i enter id all other field should get filled automatically. can anyone tell php code . as i dont know asp.net. suggest some sites please

Hi, I have A DB look like this : events(type,event_from,event_to,description,owner,perm,repetition) and repetition(repetitionid,description) repetitionid = repetition and repetition look like that : 0;"None" 1;"Every day" 2;"Every week" 3;"Every month" 4;"Every Year" my question is by giving owner how can i found all hes events ?