Databases Forum

hi all, Im desperatly looking for a .db format rhyming dictionary and have managed to get hold of three database files which I think will be VERY useful to me but I cannot open them. Can anybody help me to get them open? I have attached the files in a …

HI Guys I have an issue, I would like to know if anyone can suggest how I can achieve what I want. I have two tables, a user table and a media table. The media table has a FK, User_id , referenced to User.User_id. Table structure User: user_id username password …

I have a query that looks good to me but MySQL does not agree. I am using the DATE_FORMAT function and I do not see what is incorrect so I am hoping some one can point it out. [code] SELECT title, DATE_FORMAT(event_date '%Y-%c-%e') AS event_date FROM event WHERE event_date LIKE …

Hi everyone, I have a problem in MS SQL. Due to academic nature, I am supposed to use a query to find out the present applicable tax rate (GST, Good & Sales Tax) without altering the table. The table has 3 tax rates, 1: WEF (With Effect From) 2004 Jan …

Dear everybody I have a question! I have a database with a invoice table for storing invoice data. In this table i use the InvoiceID as my invoice number. My problem is that if a user makes a mistake and the invoice is deleted in order to create a new …

Hi folks, I have a mysql database and I have written some PHP to view records, add records, delete records and update records. The problem I have is updating checkbox fields of a record. Everyhting was working fine and updating correctly. Then I tried to automatically populate the form fields …

Hello everyone I am quite new here and have a very tricky issue that bothers since days. I posted the question on the PHP forum together with a sample of my embarrassing code. If this is wrong that I raise the issue here in MySQL forum, too, please forgive me, …

Hi. This is the first Topic I've posted at (the cool) daniweb site so go easy on me. I want to put the cities of England with all their districts in a database. I can think of the following two ways to do this: 1) [B]cities[/B] ([U]cityID[/U], cityName) [B]districts [/B]([U]districtID[/U], …

I'm trying to do a delete on two tables at once. sucessfully does it with update, [code] UPDATE table1 INNER JOIN table2 ON table2.table1_id = table1.ID SET table1.whatever = Whatever, table2.whateveer = Whatever [/code] is there a way to do this with the DELETE function [code] DELETE table1 INNER JOIN …

I need some help with this small php search script, I have a small HTML form... [CODE] <form action="search.php" method="post"> <input type="text" name="search"><br> <input type="submit" value="Search"> </form>[/CODE] What they will do is enter a username and what I am trying to get is information based on that username displayed in …

I have a users table that has a table titled 'DOB', of format DateTime in MSSQL. Now, I would like to filter rows for all users who are over 30. till now i used this code: [CODE=SQL] SELECT * FROM [User] WHERE [User].DOB > = DATEADD(YEAR, @ageFrom, GetDate()) [/CODE] this …

i have 2 database & need some code to solve this problem. table 1 (food_place) : fp_id | fp_name 1 | McD 2 | Burger King 3 | Pizza Hut -------------------------------------------- table 2 (promo) : p_id | p_name | p_pid 1 | Disc.10% | 1 2 | Free f. fries …

I have two servers and one of them have mysql db and one doesnt so is it possible to use mysql db in my other server while hosting my website on another. also if there is how would you do it with php.

Dear members I have a challange. I want to update my CRM database (MSSQL) with turnover numbers from our ERP database. I can retreive the data in different file types from my ERP database so they can be importet as a flat file. But does anybody have a good idea …

this is not a web design question, i'm actually using it in vb.net but they don't have a database forum in the software development section. what i am doing: i have two tables. customer and customer_phones my visual basic program has a search for customer option, which returns the customers …

Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the …

What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date. This is what I started with [CODE] - Automatically generate …

Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do: [code] $sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'"; [/code] I know I can instead run …

Hello sir, I am creating student attendance tracking system in asp.net. With attendance i need to track students attendance every day and want to generate charts with those data. Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?

First off I apologize for being a newbie to MySQL but one must learn somewhere... I am attempting to create a stored procedure that take input (primary key) and finds a field for that record and output to a variable... my code so far: [CODE]CREATE PROCEDURE sp_dealer_name( IN dealerID CHAR, …

Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), …

I would like to update 2 fields values from one record to a set of records in the same table: I tryed this: [CODE]UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin …

Hi I have a problem where dot is used in a table's column name. Say that there is a column called 101.name in a table t1. How do i reference this column in the following: select ... from table t1, table t2 where t1.101.name='test' This doesn't work because of the …

Before I begin i'm sorry if this is a noobish question. Basically I'm trying to import a 'forum.sql' file into mysql so that I can access and manipulate it through a Java servlet. The path to the sql dump file is /home/floyd/Desktop/forum/forum.sql so i open a terminal window, cd into …

Is it possible to get the columns name from a select statement involving more than two table. eg [CODE]SELECT a.field1, a.field2,b.field3,c.field4 FROM a,b,c WHERE a.field1 = b.field1 and a.field1 = c.field1 [/CODE] is there a mysql statement that returns a record set containing field1, field2, field3, field4 that can be …

Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be …

In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique …

Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER …

Hi Trying to pull this off in one query but my and right & left joining is giving me unusual results... i have a 'product_style' table, an 'product_item' table, an 'addto' table and a 'removefrom' table - im monitoring when products are added/removed to/from the cart... and want to pull …

last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems] thanks

Hi I have this data [code] CustBid idProduct bidAmount bidDate 1 272 165.00 2009-11-20 09:05:31.640 1 272 155.00 2009-11-20 09:05:25.480 4 272 95.00 2009-11-19 12:40:44.973 4 272 85.00 2009-11-19 12:40:40.377 1 272 85.00 2009-11-12 11:20:52.400 1 272 85.00 2009-11-12 11:20:52.400 4 272 75.00 2009-11-12 11:11:02.080 1 272 65.00 2009-11-12 11:20:20.170 …

I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I …

Ive been looking around and havent been able to find anything like this yet.. I am new to mySQL. Im looking for a function like the "where" function of a query string.. but insted of it being exact i would like to select "where" datafield "contains" text.. example.. item is …

Hi I have a column named 'ExtRefNo' which of varchar datatype. The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3) My requirement is if the user search for ExtRefNo between 100 & 105, it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105. Need not include …

Can I store a photograph in a mysql table. ? What type it takes...how it is done. Do i have to store only the path??? please explain me.

what is the differances with SQL tables and relation modelling?

Hi all, I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000. Can anyone suggest an sql line that would allow me to acomplish this? Thanks in advance …

I currently run an installer app that will install a DB on a VM server. However this fails because the when oracle is called to begin the oracle services start up but the newly installed DB will not. It works on a physical machine but not on the virtual server. …

Hi everyone, I am tasked to alter the front-end of the database and have been given the whole wad of PHP files and also an .SQL file. My question is, Why i cant see any changes to the database front-end when i change the .sql file. (I tried creating a …

Hello all, Is there an easy way to edit the order of my colums in a table? Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state I would like to list the "location" column after "state". Can anyone offer a simple suggestion. Thanks in advance. C-

create a query that will display total no of employee and no of employee that hired in 1995,96,97 from employee table.. my employee table have field like emp_id name hire_date.

I have a query that works, I wanted to add another sum from another table, but when I do, the all the SUM values are wrong this works [CODE]SELECT Clients.ClientID, Clients.WholeName, SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE 0.00 END) AS 'Admin Fees', SUM(CASE WHEN (Payments.Creditorid = 3) THEN …

Hi all, I have a single table with both parent and child nodes, and each has an order number in it. I am trying to write a single query to output them in order, its for a navigation list with categories and sub-categories. I could manage it in code rather …

A company has several employees and projects. Each employee may be working on several projects. Design a database to hold information about projects and employees, choosing some sensible sample fields and data. Write an SQL query to display the number of women and the number of men working on each …

Hi all... So, I am needing to sum all billable hours within a table... the problem is that it is returning rouded decimals instead... like .5 always comes back as 1 ... Here is my procedure: [CODE] Public Shared Function GetBillableTimeForTicket(ByVal SupportTicketID As Integer) As Decimal Dim conn As New …

Hi, this is giving me a major headache and my boss wants the project wrapped up asap : / I have two views pulling data from several tables. The end result is this: CustomerTotals CustomerID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered numeric(5,0) SupplierTotals SupplierID numeric(18,0), ProductID numeric(18,0), Delivered numeric(5,0), Ordered …

I need to make ten selections. One of all the datetimes in the last 24 hours, the next one from 24 hours to 48 hours, and on back in 24 hour blocks for the last ten days. I've tried various approaches to this, but this is what I currently have: …

Good Day all i have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = …

I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the file is in currently. [CODE] USE [XYZABQ] GO …

I got a query to calculate the percentage as , [CODE] Select votes, rating, votes/sum(votes) as percentage [/CODE] But I want to take the values from two different tables. I tried [CODE] Select elec.sum(votes) from elec, stat.sum(rating) from stat where year=2009, elec.sum(votes)/tat.sum(rating) as percentage; [/CODE] This doesn't work. plz help.