Databases Forum

I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will …

This is problem that I have struggled with for some time, but im sure the answer is very simple... I have a sub report that performs calculations on 2 fields ( [Rate] [Hours Worked] ) from a table called [Hours]. The report is GROUPED by [Rate] and is as follows: …

Please help me out her, I am building a website using wordpress I have created a post with four different categories in the post page, categories named : Action. Terror, Documentary, and News, and these four named Categories are automatically inserted into one of the eleven tables automatically created by …

hey everyone, I'm trying to get my head around this Question but it is not making that much sense .. Each receipt is issued from a receipt book whose number is encoded in the first three digits of the ReceiptNo field in the PURCHASE table. For example, the receipt numbered …

Hey, [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" AFTER INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO = 122336) THEN :NEW.AMOUNT := AMOUNT * 0.1; END IF; END; / [/CODE] I have a query that selects my top client then want to pass the clientNo to the trigger. Is it …

Hi, i have 3 tables in oracle sql developer (packing, detail, header). I need to update the packing table's part no with header table's part no. But header doesn't contain the serial id hence i need to refer to detail table for cross reference. I did like below, but it …

Hey everyone, I'm just wondering if there is a way to get around this problem. I'm running SQLplus on UNIX server and SSHing into the server. Whenever I query Oracle DB, a list of results/bunch of tables comes up but I can not scroll up to the top of tables..... …

Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve …

HI Guys These days I am checking whether amount is correctly upload into one of our table its located in oracle database below query used to check this . Select * from Amount_Paiad where CusID IN ('34343','34343','090094') There is no issue in query.Problem is how many values I can enter …

Hello, I think I made a mistake while connecting my tables with foreign keys :S here's the DB- table 1: [U]Id[/U],[U] year[/U],..... (2 Primary keys) table 2: [U]tbl2Id[/U], ... now the table that connects tbl1 and 2 with m..m relation- table 3: [U]Id[/U],[U] year[/U],[U]tbl2Id[/U] I set the foregn keys for …

hello everyone... could anyone tell me how to store images in oracle database..or which datatype has to use for it..

OK, here is what I want to really do: I need to write a single SQL query to do the following: select count(1) from TableA where [condition1]/ select count(1) from TableA where [condition2] One way of doing it is: [CODE] select (t.numerator/t.denominator) as ratio from (select (select count(1) from TableA …

some times i connect to the localhost via Windows Authentication and i loggin normally, sometimes i get this error and after i restart the problem solve, now even if i restart always the same error :/

Hi guys, am having an issue with a mssql query an running in mssql 2005 server. I have two tables debttable (customer, subcat, drugs, form, total, paid, date, balance qty and amount as columns) and debtsum(customer, subcat, total, paid, date, balance). Now since both tables have some columns in common, …

Okay so me and a friend of mine are discussing the following: If you have 1. a table with 10 fields, each a varchar(255) or 2. a table with 10 fields, each a varchar(1billion) [B]Which would be better, performance wise?[/B] I say it won't matter, because MySQL reads the field …

Anyone know how to install Oracle Sql developer on Mac?

I'm trying to creat a search procedure that will search table game and return all rows where columns title, description, platform, and gameid are LIKE parameter searchtext. This parameter is coming from many different pages as a Session("searchtext"), and I'm using a UserControl to send the Session, all pages in …

Good day. I'm new here and I'm nt sure this post should belong in here or not. I had done my programming on the virtual machine while having mysql database set up in my PC. I was unable to get the data from my PC unless I installed another database …

I have hit a bit of a stumbling block with a project I am working on. Basically it tracks football (soccer) results and everything works fine as things are but I there is something else that I hope to do now that I cannot get my head around. Basically, there …

I have a database with a list of process owners. The users of this database wants the process owners emailed when a form is updated with a click of a button. I can email to one person using a macro but this requires additional codeing which I am not all …

Can anyone help me with the database structure of a personal finance application?

I have no idea how to do this so please forgive my not trying before i ask. I would like to create a system that will allow user to vote, count and tell who won. i can do all that is stated. now i would like to add the functionality …

Hi everyone, I've been trying different commands that check inputs that will be entered into the tables I've got. I want to check that Amount/Ename columns can not be NULL. What's <> do in SQL? [CODE] // first command ALTER TABLE Emp ADD CONSTRAINT CK_AMOUNT CHECK ( AMOUNT NOT NULL); …

I am having trouble figuring out what tables to create and how to setup the relationships properly to design a sturdy normalized database for personal finance. I am wanting to create a database that will be able to track income and expenses and compare it to budgeted amounts in each …

Hi there! So, I have this exercise to do in my classes and I've reached a part in my model that confuses me (due to the text). I've tried some approaches but I can't seem to find the solution. I've also tried to ask 3 teachers, but they all say …

Here i have four tables in my Database named "test_center" those are 1) "test_user" --> PK = u_id 2) "test_metadata" --> PK = test_id 3) "student_detail" --> PK = Student_id 4) "test_records" --> PK = test_record_id (Child table) table 4 is child table and 1,2,3 are masters..! i am trying …

My query below has been working okay for 1 year now and suddenly it is giving an exception: [CODE] (SELECT distinct(R.imei),R.mobile,S.msg,S.reply,M.model, left(S.receiveTime,10) as receiveDate, right(S.receiveTime,8) as receiveTime,'' as 'Reason' from dbSAMSUNGmain.tREGDATA R,dbSAMSUNGmain.tMODELS M,dbSAMSUNGmain.tSMS_TRANSACTIONS S where S.mobile=R.mobile and replace(replace(S.msg,'/',''),' ','') LIKE concat('%',R.imei,'%') and (S.reply like '%Registration successful%' || S.reply like '%Reg …

I'm trying to write an SQL (MySQL) Statement here using an if statement but all am getting are countless errors. I've narrowed down to simple instructions but still no breakthrough. [CODE]DELIMITER // CREATE TRIGGER confirmation_triggers AFTER INSERT ON `old_deliquencies` FOR EACH ROW IF new.status='True' THEN INSERT INTO `notifications` VALUES(NULL, new.loan_id, …

Hi, I don't usually develop for PHP or MySQL, but I am just doing the odd job for a friend. I am having issues with a MySQL query though. A few days ago I must have done something to the code somewhere, and it is throwing up errors now. I …

Good morning, Firstly, let me say that I have zero experience with database, servers, etc. Now that I have prefaced this long question with that tidbit let me ask the most basic questions. What is the difference between MySQL and MS SQL? I think they do the same thing but …

I am trying to set up a form for potential students to give their information for a language academay. When I tested the form with <input type="text" name"Nombre"> type of fields everything went fine. As soon as I tried to introduced drop down menus or typ radio elements the data …

Dear All, I have a query as below SELECT DISTINCT (productID),totalAmountAfter,transactionDate FROM tbltransaction WHERE transactionDate BETWEEN '2010-01-01' AND '2010-12-31' ORDER BY productID,transactionDate DESC . My problem now I want is that for each product only pick one line that is the last line since I have ordered by the date. …

hi guys, i am trying to write a query that would basically display me pas 4 week, however if lets say today is Wednesday the pas for week would have to start from last Friday, none the less if i have to run the query on monday i would want …

my table design is [CODE] date income expenses 2011-08-5 1000 500 2011-09-6 7000 400 2011-10-7 2000 300 [/CODE] I have daily expenses and Income in the above table.I need to retrieve monthly(sum of daily) income and expenses for particular year. How should i write query for that . Pls help …

Hi All, we are currently analyzing our client data warehouse and we found few of the dimension tables are having only two columns (such as ID and DECSRIPTION)...while we are trying to remodel it ..is it a good idea to have the columns in the FACT table itself... there are …

I want to create menu structure from a database. For example, the database is the following: id name parent 1 x null 2 y 1 3 z null 4 a 3 5 b 2 The result should be: -x --y ---b -z --a Now, the algorithm I have on mind …

I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks

Hi I have a MS SQL db script, I have the same temp table declared more than once. I keep getting this error: There is already an object named ????(question marks are representative of table name) in the database. the following resembles what my script looks like. [CODE] IF OBJECT_ID('tempdb..#table123') …

Hi, I have a table storing score and level information of a user. Both are integers. Level value depends on score and mapping is not expressable as a mathematical function. There are min, max values of points for every level. Please help me to design the dabase table. My problem …

Please could you tell me where I am going wrong I want to open 1 of 2 forms depending if a certain text is present in a field of a table. If text "Expired" is present in the 'Name' field of Table 'MAIN' then open form 'Expired' and if is …

Hi friends I have a question about savepoint The SQL statements executed in a user session are as follows: SQL> CREATE TABLE product(pcode NUMBER(2), pname VARCHAR2(10)); SQL> INSERT INTO product VALUES (1, 'pen'); SQL> INSERT INTO product VALUES (2,'pencil'); SQL> SAVEPOINT a; SQL> UPDATE product SET pcode = 10 WHERE …

Hi There, MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other. Example Tables : users, logins, communication, sightings etc. When …

Dear All, I have a table tblEventAlert as below. So what happens when the data gets insert into this table the problem is that the eventAlertID is autoincrement. Then below it I have another table. My problem is that I want the eventAlertID to be stored into the tblSCvData. I …

Dear team, Please explain, which one will be faster in Mysql for the following query? SELECT * FROM `userstatus` where BINARY Name = 'Raja' [OR] SELECT * FROM `userstatus` where Name = 'raja' Db entry for Name field is 'Raja' there is no key for the field. I have 1000000 …

I want a ready made database of the countries all over the world, the major cities of those countries and their time difference (in hours) from GMT. Please tell me where to get it. I need it soon.

can any one tell me to find out the list of databases that have “.ldf” size greater than “.mdf”.

[CODE]UPDATE table2 SET table2col1 = table1.col1, table2col2 = table1.col2, ... FROM table1, table2 WHERE table1.memberid = table2.memberid[/CODE] will the above query help me to update fields from one table to fields in another table base on a common id between the two tables?

Hi I have a issue that my application in currenlty doing number validation with an issue. I have a query that checks number is stored procedures but need more checks. [-d0-9] and checking that the lenth is 10 characters, all that is working as it should. The issue I'm having …

Dearest VB GuRus, thanks for all your contributions. this time, I have a problem and I need your magnanimous assistance and contributions. I have developed a a VB Cash-expense application and I am designing a Database using MS-Access to be used as back-end. I am confused on which fields should …

Hi all. I am trying to create a search that displays 3 columns. Analysis, Amount, Amount of Positiv results I have nailed down Analysis, Amount, but have problems displaying Pos. result. [CODE] SELECT DISTINCT SP.ANALYSIS AS Analysis,COUNT(SP.ANALYSIS) AS Amount FROM SAMPLE S INNER JOIN SAMPLE_PARTS SP ON SP.SAMPLEID = S.SAMPLEID …