Databases Forum

Basically my table Itinerary table where a record can have a parent record. so table cound have ID Parent ID which can be any ID from The same table. Other details Parent ID can be null if the record doesn't have child. and if i delete the parent record of …

Hi, Have been using the same database for years without any trouble. Suddenly we are getting the Data Type Mismatch in Criteria Expression when we attempt to run a VB function. I am not familiar with VB so much, but have found where the error is happening: [CODE] Private Sub …

mysql update query not working.

Hello, I would first like to explain my current setup. 1) Nginx Server (A) which is the front-end proxy 2) Apache/MySQL (B) Serves the normal traffic and holds the databse. 3) Apache servers (x) x-servers are used to help shed the load. (nginx will channel the apache load to both …

Below is the sample code working fine in 10g and not working now in 11g. CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS import java.sql.SQLData; import java.sql.SQLException; import java.sql.SQLInput; import java.sql.SQLOutput; import java.util.List; public class PSTest implements SQLData{ public String sql_type = "PS_TEST_TYPE"; private String id; public String …

Good day, I am having trouble with my dbase. i have 2 tables first is the maintenance table while the other is transactional table. on my maintenance table i have field(id, plan, material,type,percentage) while on the transaction table (id,material,description) here is my problem. on the maintenance table let say id …

Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items …

Hello All! I have a MySQL database with 4 items, id (numerical), group_name, employees, and surveys. I need to in my select calulate the percentage of 'employees' who my the number in 'surveys' have taken the survey. This is the statement I have now: SELECT group_name, employees, surveys, COUNT( surveys …

Hi, Can we get a SQL query, to display all the dates between two given dates eg. if date1=21-mar-2007 and date2=25-mar-2007 then the query should display all the dates between those two given dates i.e 22-mar-2007, 22-mar-2007, 23-mar-2007and 24-mar-2007. Query should not contain any plsql coding. Regards.

I'm working on a design for a calibration management system but, i'm stuck with designing a table or tables to accomodate this data as desscriped in the picture below.  all the numeric data in the picture should be entred by the user but, the correction is calsulated automatically …

I'm trying to get to grips with this create view thingy, but can't see it. This creats my view mysql_query("CREATE VIEW list AS SELECT AlbumId,Title FROM album, LEFT JOIN artist ON album.artistId = artist.ArtistId ORDER BY album.Title")or die ("no dice pal ".mysql_error()); that works, and creats it fine. But when …

Hi Experts, I need your valuable suggestions for research topic in mysql. Topic should have practical implemenatation part. Thanks

i am still learning,pls i need help,i want each and everytime i submit to database all the html tables with value should relect in database,i mean all the table should show in the database this my posting only display one table ............help thanks $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction …

I don't know how to add songs in the database along with their link, content_type, duration, size, etc. I don't know which query & what datatype will be required to add the songs inside a database table. Since music file is a .mp3 or .wav data I cannot possibly add …

Hi, Can you set auto increment in phpmyadmin to be 2? So that it goes 1, 3, 5, 7etc? Thanks...............

Hi all, I have a database with a set of relations created in SQL Server express. Is it possible to view or recreate the sql statements that created the database? Thanks for your time. Ryan

Hi All I am upgrading a SQL 7 database to SQL2008 R2 and just cannot undestand why 2008 has a problem with the code for this view (my experience with SQL 2008R2 is limited): SELECT dbo.tbl_orgbusinessunits.BusAreaCode, dbo.tbl_orgbusinessunits.Region, dbo.tbl_orgbusinessunits.CompanyCode, dbo.tbl_orgbusinessunits.BusAreaCode & ' ' & dbo.tbl_orgbusinessunits.BusinessAreaName AS Branch, dbo.tbl_orgcompanies.CompanyCode & ' ' …

I used following code to connect oracle database from C#. But i get this error "**invalid login credentials**" using (Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;") { cn.Open(); } While if i try following code to connect database from C# I succeed. using (System.Data.OracleClient.OracleConnection cn = new System.Data.OracleClient.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;")); …

I have a trigger on insert CREATE TRIGGER [dbo].[InsertNewCustomersAsGroupMembers] ON [CustomerBase].[dbo].[Cutomers] AFTER INSERT AS BEGIN SET NOCOUNT ON; -- Insert statements for trigger here DECLARE @inserterdCustomerID uniqueidentifier UPDATE [CustomerBase].[dbo].[GroupMembers] ?---? END GO I want to get the values of the inserted record at [CustomerBase].[dbo].[customers] into the trigger inorder to update …

Hi, I have a base that accepts data in and I can display all the data in a table :) How do I make the database echo out to read only text box on a form one string at a time ? do i have to do some .php before …

Hi I am doing a Tizag tutorial.I have created this table products with phpMyAdm in and started to populate the field.When it comes to price if I insert 13.99 the amount is rounded up to 14.I have tried everything changing to decimal, float, double but nothing seems to work,it keeps …

Hi to all, I try to insert a values in SQLSERVER 2005,It shows "Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table 'designation' when IDENTITY_INSERT is set to OFF." BEGIN TRAN INSERT INTO DESIGNATION (ID,DESIGNATION) VALUES(17,'TEST') COMMIT Kindly Suggest How to Solve …

I have an entity named Country with fields: CountryID, CountryName where CountryID is a primary key. And i like to create a general stored procedure that does INSERT, UPDATE and DELETE operations. How can i do that?

**I have download a setup.exe for GNU database library GDBM. It's going to be installed in C:\Program Files\GnuWin32 (lib, include, etc.). My mingw is in C: (C:\MinGW). Could you please tell me what is the right path for GDBM on windows. I used GDBM on Linux and compiled and linked …

Hi I am running phpMyAdmin 5.6. I have created a table as described in a tutorial. This table is supposed to have a null value in a text field, I cannot do it, I tried everything.The examples on the web refer to older versions and I keep getting error.I even …

hi, i have 2 tables: CUST and ORDERS CUST contains cust_num, cust_name, cust_phone ORDERS contains cust_num, order_date, order_amt i want to list all the cust_names and their last order date and amount how would i code this? thanks.

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in …

HI All, I have to upload most of the world wide active Educational Universities and Institutes in my Database. I have tried a lot to find out but none of the sites are giving proper list. either they have given 3 to 4 names under each Province which is famous …

HI, how can i change column name by query? Exm: UPDATE table_name SET column_name='course_title' WHERE coulumn_name='course_name'; is it?

hi, i was wondering is someone could give me an example of how i could do this in sql query. basically the application has a product table and when they are inserting they have the option to select monthly payments. put in the start date so say 30/3/2013 what i …

I have two fields in table, (i) section_from & (ii) section_to, both fields has Date datatype, these fields tells us that this law section is enforced From(section_from) this date To(section_to) this date. The problem is, the latest law sections (active law) which are issued by the government has no specific …

Hi All, I am uisng Mysql DB and i have a task for suggesting Categories based on User keyword input. I have written the query as below but i need to ignore white spaces while matching, how can we achieve it SELECT search.*, MATCH (name) AGAINST ('black' IN BOOLEAN MODE) …

SELECT Facility.[Facility Name] FROM Facility LEFT OUTER JOIN Reservation on Facility.FacilityID = [Reservation].FacilityID AND [Check-in time] = '" & Integer.Parse(cboHour.Text) & "' AND [Check-in date] = '" & lstDate.SelectedItem.ToString & "' WHERE Reservation].ReservationID Is NULL AND Facility.[Facility Type] = '" & cboFacilityType.Text & "' I have this sql statement which …

Hi all , Here comes the same general question. I want to store the text ( you can call 'paragraphs' ) . What is the best way to do that? Files? OR database is OK? Thanks in advance :)

I need help creating a specific query, The following is an example of my paycheck table, empId is a foreign key that refers to the primary key of my 'users' table which is 'userId' mysql> SELECT * FROM paycheck -> ; +------------+---------------+---------+-------------+-------------+-------------+-------+ | payCheckId | jobId | payRate | jobLocation …

I want to use this- insert into sales(year1) values('344'); query to insert the value '344' into the column where the month column values in January. However I cannot do so by using the WHERE CLAUSE like this: insert into sales(year1) values('344') where Month='January'; This is the existing Table data: 'January', …

I need to create a database for a simple website with films collection. I decided I need following columns in the table: [Click Here](http://www.flickr.com/photos/94148478@N06/8564036143/) I made some reading and after getting familiar wit normalization rulez I decided to divide this in four tables: 1st table "Basic info"with columns: movieID,titleID, directorID, …

Hi guys, I've hit a wall again with this code and I'm sureit's something simple I'm doing wrong, I just can't see it. <?php include('php/head.php'); // form action $asset=$_POST['asset']; $item=$_POST['item']; $link=sqlite_open('data/3002.sqlite ',0666,$sqliteerror); sqlite_query($link,"INSERT INTO holding(item) VALUES('$item')"); sqlite_query($link,"DELETE FROM '$asset' WHERE item= '$item'"); // open page display div echo"<div class='image_pane'>"; // …

Hi, I need to exclude any rows where the ASX_Prices.Date is a weekend. The date format is yyyy/mm/dd 2013/03/17. Ideally I would like to add another WHERE clause. WHERE ASX_Prices.Date !=weekend date????? $sql="SELECT Distinct ASX_Prices.ASX_Code, ASX_Prices.ASX_Price, ASX_Prices.Date, Company_Information.Company_Name FROM ASX_Prices, Company_Information WHERE ASX_Prices.ASX_Code = Company_Information.ASX_Code AND DateDiff(now(), ASX_Prices.Date)<=7 ORDER BY …

Group, I'm discovering that the SQL Server tables don't like identical (in this case) Part Numbers, even though one of the columns will have different information in it (in this instance, it is the "Location"). FYI.... I'm using SQL Server 2008 Express for my testing. With this said, I'm trying …

The following 3 things made me realize that its actually the MySQl server which is crashing. 1. I have a php script that updates a database table as soon as i fill up a form through localhost. I am able to access my localhost homepage and then fill up the …

USE [Emp1] GO CREATE FUNCTION [dbo].[Leave] ( @EmployeeID INT ) RETURNS INT AS BEGIN DECLARE @PayLeave INT, @NonPayLeave INT; SET @PayLeave = 0; SET @NonPayLeave = 0; RETURN ( SELECT IF((ImDescription == "Sick") AND (ImLeaveType == "Yearly")) { IF((ImMonthlyMaxLeave > 1) OR (ImYearlyMaxLeave > 10 )) { @NonPayLeave = @NonPayLeave …

Hi, I'm making a small web-based software and I need help for a search query that looks for results in 2 tables. I can run it very well like this for a single table : $query=mysql_query("SELECT * FROM `customers` WHERE `name` LIKE \"%$search%\" ORDER BY `name` ASC"); But, here is …

So I have this line of code: $results = mysql_query('SELECT * FROM members WHERE category1="Photographers" ORDER BY premium DESC, featured DESC, company ASC'); Everything works great, Premium members show up above featured. Featured above regular members, and they are all in alphabetical order. However I want to have featured members …

Hey guys im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times. how do i stop this …

Using SQL I have to SUM the total of each game but I can only select the games that have more than 10 scores in total . So `select GameNo,sum(goals) from tblGame, tblAthlete.` But I'm stuck on the 'where' bit.....`select GameNO where (sum(goals)>=10);` So not only do I have to …

Greetings, I want to know what is the best practices when setting new database options? which options I should switch them from False to True and vice versa

Good Day i have been hit by this error this night. I have a UDF defined like this CREATE FUNCTION [dbo].[funcFormatPercentages_Extended_numeric] ( -- Add the parameters for the function here @parPercentageToBeFormatted nvarchar(20) ) RETURNS nvarchar(20) AS BEGIN RETURN CAST(CAST(convert(float,@parPercentageToBeFormatted)* 100 AS decimal(4, 1)) AS nvarchar(5)) + N'%' END so i …

I have to create a system design for a cashier system. Most of the transactions would be payments for fees in a student account. Fees like Tuition, Books, Enrollment Fees. The problem with these fees are their special characteristics like Tuition fees being staggered in MONTHLY itemization (if that's a …

Hi All, I have 5 product tables(product_table_1,product_table_2 and so on), category table and sub category table I need to get number of products mapped for each category. i.e count of products accross categories. Below are the table structure and the query which i have written, I need to optimize the …