Databases Forum

Hi everyone, I've never had to do this before sooo, I need help. I have a table which maps managers to regular employees. So you could say that Manager A is mapped to 20 peeople and Manager B is mapped to 5, and so on. So the table looks like …

Hi, I've got 2 columns of numbers and need to divide the SUM of COLUMN 1 by the SUM of COLUMN 2. I've tried [code] (SUM(col_1))/(SUM(col_2)) [/code] AS col_3 but this doesnt work. Please help. Kind Regards Asil

I m trying to execute the sdo_migrate.to_current method like this : [CODE]execute sdo_migrate.to_current('tablename');[/CODE] but i keep getting invalid sql error, and i dont understand why. Please help

When I fetch the records from the LIKE the query returns no results but when I fetch records from the equal to (=) then the query returns results. Following user name are stored in the database: (1) `~@#$%'\|/?.><^&%@()-_+-: (2) (){}[]|\/?"*&^%$#@sujeet` I am searching the records from the LIKE operator as …

Most web forums will state next to each board how many threads or posts have been been. Would you calculate that with a query for each board to count the number of "post" entries in the table for that board, or simply increment a number in the board table whenever …

hello can any 1 give me the idea if we use single web page for both admin and user then how to hide admin priviliges from user??

Hi, I have 3 sentences in table. These are the sentences. [code] Spatio-temporal tracking and phylodynamics prm. These are prM based values. All MR values are greater intensity than PRM vales. Values specified are equal to PRm values and PRM-lacZ. [/code] If user specifies the query like this: prm* i …

Ok help please , cant get my head around this .... i need to build a database that will hold the following : width x drop = price what i actually want to do is a quotation form for my website where the costumer will input the width and the …

Hi all, There is a (I assume) simple query i cannot figure out (in a best practice way). Let's say I have three tables: [LIST] Users[/LIST] [LIST] AOI (Areas of Interest) [/LIST] [List]Users_AOI (Simply containing userId and AOIId for all interests for each user)[/List] So far so good. Now I …

Why is installing MySQL on Windows Vista such a bear? For someone who is not a professional database administrator, it seems like I am jumping through hoops. This page [url]http://forums.mysql.com/read.php?11,200958,204223#REPLY[/url] pointed to this page [url]http://www.sqlservercentral.com/blogs/brian_kelley/archive/2008/04/04/installing-5-0-51a-mysql-community-edition-on-windows-vista.aspx[/url] which suggests this page [url]http://port25.technet.com/archive/2007/03/16/mysql-on-windows-configuration-install.aspx[/url] which points to this beautiful pdf file [url]http://port25.technet.com/videos/research/MySQL_Windows.pdf[/url] Ah, now …

I am trying to create Update trigger which should be invoked only if the ReturnedOn column is clicked. I have used the following code-snippet but it generates the error: CODING: [code] create TRIGGER trg_ForUpdateOnBookIssuedDetails on BOOKISSUEDDETAILS For update as begin declare @Rows1 int,@Rows2 int if(update(ReturnedOn) begin IF EXISTS(SELECT 1 FROM …

Hi all, I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id. The values for this column should start with PT and contain the serial numbers in ascending order. Eg. PT001 PT002 PT003 I want to …

Hello I would like to know how to display orders placed on a certain day. For e.g. I would like to display orders placed today. My MySQL database contains the following tables: 1). orders 2). orders_statuses Under [B]orders[/B], I have the following fields: 1). orders_id 2). orders_placed_date Under [B]orders_statuses[/B], I …

(And before anyone points it out; I know they're not calling it DTS any more!) My problem is as follows: Whenever I go to import a flat file using the DTS import it's setting the default column sizes to be ludicrously small (50 characters) and it doesn't subsequently matter HOW …

Hey All, I am using MSSQL -2005 with VB6. I have created a master table tblCompany and detail Table tblDetail having foreign key relationship. When i try to insert a value within a TRANSACTION I am getting Error No. -2147217873 at Line No. 0 (The INSERT statement conflicted with the …

Is it possible that select records for example 20 records from the table randomly, but in addition 1 certain record for example 3rd record. Let me explain: SELECT * from table limit 1, 20 rand(); In this way I will get 20 randomly records but I want that one certain …

Hi all I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this? Much appreciated Venom Rush

Hello, I am making some progress on this database I am building for practice...I am new to programming...and was wondering if there is any way to add navigation functionality using buttons or links under the fields being displayed to go to the next or previous record. I Also am trying …

Hi, I'm not entirely sure which forum to post this question because I cannot determine whether it's a MySQL, Joomla, or PHP issue. But I will post it here, as some of you may know about this. I am using a custom built "user" table in my MySQL database, and …

Error message ”[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.” comes when you insert/update a larger value than the column is specified for. But is there a way to detect what column, or what value that is to large? I’m thinking about splitting up the INSERT string, …

I hear alot from my fellow developer about these schema stuffs. Im new to database and I wonder what Schema is. I can play with tables and databases,

Hello All, I'm wondering if anyone can help me by either directing me towards a source that would help me understand Access syntax better or help me figure out if it's possible to convert this SQL syntax to Access. I've tried but can't seem to get it to work. my …

Hy, you guys! I'm trying to implement in a trigger write by-me error handling with TRY...CATCH, but I'm loosing a lot of time without success. :'( Here there's a simple code write for test: [CODE]ALTER TRIGGER [dbo].[INS_AlarmsEvents] ON [dbo].[TEST] AFTER INSERT, UPDATE AS BEGIN TRY RAISERROR (N'This is message %s …

I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by any given percenatge. The products all have a code starting with 3 letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and …

Hi, Is it possible to have a subquery within a case statement and perform greater than / less than comparisons on the value returned in the subquery? i.e. [code] select case (select price from product) when < 100 then 'cheap' when < 150 AND > 101 then 'fairly expensive' else …

HI, I have in my database 50+ tables and getting slowly lost because it's looks like a bit messy up because of the long list in the Object Explorer (SQL Server Management Studio). Does anybody know a way how to organize this tables in subfolders like how the "system tables" …

Hi all, I am creating a trigger which should be triggered on insert to BOOKISSUEDETAILS table. I want to alter the table LIBRARYBOOKDETAILS table only if the Inventory column value is greater than 1. Initially I have created the trigger in the following way. But now I want to alter …

Hi evrybody, My sql SP takes around two to three minutes which is quite long time to execute the SP select data from three tables publicity(29000 row) publicitysubject(29000 row) & lookuptable(50 rows) all three tables have clustered index How can i reduce the time [code] USE [ReadWorthyPublication] GO /****** Object: …

Hi All, I created a table with blob datatype in oracle and store the .doc and pdf file in that column But when i try to access the data from that table i am faceing an error data is corrupted. i am using php 5.2 and adodb driver and oracle …

I have written a complex stored procedure which have a log table which keeps the track of success/failure of each and every query in the stored procedure. If there is any error in any of the query entire transaction is rollback . while rollingback, data in log table is also …

Hi All, I have data like the following: Stuff Sizes ID pen s1 100001 pen s2 100002 pen s3 100003 pencil s1 100001 pencil s3 100004 pencil s5 100007 pencil s2 100006 ruler s7 100005 ruler s8 100008 .. .. where each size is coordinate with a unique ID number; …

Hey Guys, I'm building a database that will be used to track the professional training and development courses employees take at my work. I'm relatively new to db's, and I find the relationships a little confusing to grasp in this case. I have attached what i've done so far. I …

I recently came across an example where binary data was stored in a column which related to the sum of all foreign key id integers. This was the scenario: id [int] from [int] message_title [varchar,100] message [text] to [int] I assumed the 'to' field was a foreign key on the …

Ok; I have a table with a list of products, for example ProductID Name Price 1 Red 2 2 Blue 1 3 Green 3 4 Orange 3 5 White 4 6 Blue 5 I want to give people the option of "featuring" products, and also to be able to control …

Hi all, I am trying to update Table[land] with the following data (simplified): [u]Scenarios:[/u] Num_1 like [A-Z], Num_1_Index like [1-9] Num_2 like [A-Z], Num_2_Index like [1-9] ..... Num_26 = [A-Z], Num_26_Index = [1-9] --------------------------------------------- Update land set Num_1_Index = case when Num_1 like 'A' then '1' when Num_1 like 'B' …

Hi, [B]This was Mysql Backup Batch Script [/B] Script named as [B]mysqlbackup.bat[/B] REM [at] echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time …

What entities would you have for A car hire firm and their attributes.

i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together. One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by …

Hi. I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause in both queries results are equal. I am using the same table so I do …

Hi everyone, I am working on a project where i have encounter such problems: Data samples: LA-1-2, LA-1-2-33, LA-1-22-333-4444, LA-2-3, LA-12-34, LA-123-45-67 .. with upto 8 dashes Objective: I need to find the values behind each dashes into multiple columns in orders. [e.g LA-1-2-33 will have columnA = 1,columnB = …

EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :) Hi all I have two tables. The first one has the details of each fruit, its code, markup percentage, it's cost price and the amount …

what is mean by replication..can anyone explain me with example ..couldnot get clear idea in google?plz

Good Day, I am using an Ms Access Database to design a StockTracker applicaton. The application is used to check the stocks of users. Firstly I need to sign on as an administrator and then be able to add users and their stocks to the database. I have created the …

Background: I have many tables for ex: [B] Nominations: --------------- Type (there are 3 types) WorkOrders: ---------------- Type (there are 7 types)[/B] I have many typical tables like these. In designing database, I need to know which approach is wiser ie to make a control table for each, or to …

Hi, PO-1-09/09 is a data stored in varchar column. When i do [inlinecode]select * from table myid='PO-1-09/09'[/inlinecode], it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related data. Why PO-1-09/09 doesn't work? Thanks

Hello... I need to get data from one table while omitting data that exist in the other table. This is the query I am running but I keep on getting duplicates since there are more the one row in the second table. Table1 - 'countries' with fields 'Country_Code' and 'Country_Name' …

Hello everyone i have been looking on ebay and i went to mysql home page to trying follow their directions but for some reason I cant create a new user. I do not know how to get started, i choose the mysql file in the temp folder and that opens …

First of all. Sorry if I don't have a good English... My operating system is Windows XP SP2 I'd created script files below for creating Oracle database manually: dbcamin.bat [code]mkdir C:\oracle\product\10.2.0\admin\dbcamin\adump mkdir C:\oracle\product\10.2.0\admin\dbcamin\bdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\cdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\udump mkdir C:\oracle\product\10.2.0\admin\dbcamin\dpdump mkdir C:\oracle\product\10.2.0\flash_recovery_area\dbcam in mkdir C:\oracle\product\10.2.0\admin\dbcamin\pfile mkdir C:\oracle\product\10.2.0\cfgtoollogs\emca\dbcamin mkdir C:\oracle\product\10.2.0\flash_recovery_area mkdir C:\oracle\product\10.2.0\oradata\dbcamin …

Hi, If I have a stored procedure that creates a table of 4 rows (recommended products for a given product). What's the best way to create a cached table of these 4 recommended products for EVERY product in a products table. (Cached table being 4 times bigger than product table) …

I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in …