Databases Forum

Hello, I have two issues and I hope someone can help me with it. I have been on this problem for 3 days now, And I can't resolve it. #1 Issue I have a database in access 2003 that is the front-end and the backend on sql server 2005. I …

Hi, I'm trying to create a CSV file from Excel to upload into a MySQL db. It's for a web-based dealer locator called Lookup Runner. When I try to import my CSV it never works. The people at Lookup Runner (hitcode.com) did something to my CSVs and they worked like …

I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables. On one page, I use an SQL query to select data from 10 of the tables in the database. However, when I try to preview the page in a browser, a PHP warning stating …

I've also wanted to know which of the following is the better approach Does it actually have a difference??? where table1.userid = table2.userid using the proper join statments such as Inner join

hi friends i am a new bee to the world of sql server, started with it a few months back... i deleted a table from sql server by mistake, and trying to recover it. but i dont hav any backup concerned. is it possible to recover that table without backup, …

Hello everyone, I'm disapointed around problems of fct datetime:) I have a datetime column and I want to display the time period of the days in a datagrid: For exemple : H1 = Monday to Friday, from 06:00:00 to 21:59:59 H2 = Monday to Friday, from 22:00:00 to 05:59:59 H3 …

I have a web application for recording time, bonuses and commissions for employees. I am having a hard time joining three tables together. Here are the tables: employee - provides employee information including the primary key emp_id emp_timecard - provides recorded time from employees tc_bon_com - provides bonuses and commissions …

hiii all this is vipin from btech 3rd year...now i have to do a mini project as a semester project. It is my first project of my life..I have chosen project name "Online FIR System" basis on database. FIR by any person can be done by online and he/she can …

how to export mysql database table contents on to a PDF file. it has to be displayed in the website as "download/print data". when the customer click on that he/she has to get the PDF opened or an option to download the PDF with all the contents of the table. …

I am trying to design a Query in SQL that will enable the user to enter a customer code. However being new to SQL I do not know the language. I have selected the data from the tables, however I want to add criteria. In Access I used [] and …

hi friends We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy …

Ok, I guess wasn't as specific as I needed to be. Here is essentially what I need. I have two separate tables application_status and application_status log. Within the application status table there is the application_status_id and the application_status_description. The application_status_log table holds information on applications and the connecting factor between …

Can anyone help me out with this? SalesPerson Name Age PercentOfQuota Salary Abel 24 63 120,000 Baker 56 38 42,000 Jones 34 26 36,000 Murphy 64 42 50,000 Zenith 45 59 118,000 Kobad 43 27 36,000 Order Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction …

I would like to add a column to an existing table, where the new column would only have running numbers starting from 1. If I've understood correctly, the "create index" command is not the right way to do this, as that's attached to just certain columns to speed up querying. …

Hi, I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code. eg- MobileNo (this is the field name) ------------------------------------- 1. 6016-2880537 2. 6012-3137200 so there is about 400 records in the table …

Hi All Ok this is a bit of a doozy for me. Work related question, I have been tasked with sorting out this issue at work, but don't really have much background in this field, but theres no one else in my team that can do it. Bit of a …

I'd really appreciate anyone's view on how I can solve my problem. [B]What I've got[/B] I have three bricks and mortar shops, selling new and second hand goods, mainly small electrical goods. We also do small pawnbroking-type loans. [B]My problem[/B] I've inherited a Borland Paradox db that manages stock and …

hello, i would like to retrieve data on which the endDate < date.now....something like that.. thanks

Please help me, I am getting the following error; There was an error with SQL: 1064: 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 'AND visible=1' at line 1 Not sure what is …

Hi! I have to use sql connection to take queries from user by using textbox structure .How can I provide this .I don't find it anywhere . especially how can I connect sql and textbox structure together I do not know anything about this subject.

hi...I've tried to think about this for 2 days but I can't really find the solution. Hope anyone can help. What statement should I write for this:There is a table of Parcel. In the table there are ParcellId and the timestamp. I have to select parcels that have the time …

Hi, I need to compare MySQL, MS SQL 2008 and Oracle. Do you know of any link where this comparison takes place? I found a few comparign MySQL and MS SQL 2000 but not with MS SQL 2008 and Oracle too. Can you please help? Thanks Josh

Hi everyone, I have a database that looks something like this: [CODE] [B]Name Week1 Week2 Week3[/B] user1 10 15 7 user2 3 24 2 [/CODE] I need to write an sql select statement that returns 2 columns: the Name column and a Total column which totals that users points for …

HI I would appreciate some assistance if possible. I am embarking on setting up a database for sports data and results( at home project). Wanting to know which application would be most suitable. Data would consist of 60% text(venues dates etc) 40% data(times scores resuts etc). Most of the data …

Hey all, Here's my problem: php/mysql noob here. I have an admin section on the website, and I have successfully password protected all the php pages in that directory using sessions. I have included code like this on the top of each of my pages: [code=php]<?php include('login.php'); if (checkLogin() != …

Hi All, I'm a virgin to this site, so go gentle. :-) I'm using vb.net to write a web application and I was just wandering what was better and what the advantages/disadvantages to using the self-imported SQL file within VB.net or the SQL Server Management to create a database and …

Hi all, I want to store the hours of restaurants in a database (sounds simple, right?). I don't want a text field where hours are entered as a lump of data, but was thinking of making a column for each day of the week and filling in the hours this …

i'm using jsp to connect to oracle database. I've installed oracle 10g .when i try to set a dsn name in control panel-administrative tools-Data sources(odbc)-system dsn-add-only sql native client and sql server are availabe. OS: vista home premium Please help me.

hello exprts!! i am new 2 database!!! i have oracleXE and jdk 1.6.0_14 installed on windows XP!! i want 2 connect them via my java program.but i am gettting errors after executing the program. my code is: [code=java]import java.sql.*; //import oracle.jdbc.*; //import oracle.jdbc.OracleDriver; public class OracleConnect { public static void …

Im not sure if this is the proper place to be posting this but... I have a dedicated server that i would like to automatically run a script every 10 minutes/ half hour / any set period of time. I do not want to have to leave my personal computer …

Hi there! I made a backup of my database (MandoTECA) using the following code: [code]CREATE PROCEDURE [dbo].[CreateBackup] @uri nvarchar(MAX) AS BACKUP DATABASE MandoTECA --TO DISK = 'C:\Users\Pedro\Desktop\MandoTECA.Bak' TO DISK = @uri WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Backup Completo da MandoTECA'; [/code] And used it a restore procedure to …

Hello, While working on setting up user accounts, I wanted to see if the values already existed in a database to alert the user before submitting the data. While doing this, I came to an issue. The issue is when I went the MS SQL SMS and tried writing a …

hey frnds, I m creating the database at page load,I m able to do dat.I just want to do check that if the table is already existing,then do not create the table.below code create table- [code] using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; …

i have oracle 9i. my friend created some tables and inserted few records in each. I want these tables with the records inserted. which files should he send me and where should I place those files? will that affect my existing tables?

Hi, I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager... EM- username: sys password: ***** option as sysdba.. but with the same username and password i am not able to logon in sqlplus.. can anybody tell me the …

hello, I am not getting which SQL statement should be used to insert multiple data at a same time without writing [ICODE]insert into...[/ICODE] again and again. suppose whenever i want to insert data into 'customer' table then i may write statement as [ICODE]insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main')[/ICODE] But it will create …

Hi there! I have the following SELECT Statment: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + ' ; ' AS "text()" FROM dbo.Autor A JOIN dbo.LivroAutor LA ON A.IDAutor = LA.IDAutor WHERE LA.IDLivro …

Hello friends, i am facing a bit of difficulty in designing a SQL query for calculating the total score of all the quizes taken by users in my quiz application to create a sort of leaderboard or ranking system. My table have following tables: UserQuizID (int) - PK QuizID (int) …

Hello Folks, I'm a not an expert in Oracle/SQL Server query and need some guidence and help from the professionals. Basis for my challange is that I have two tables that i need to collect data from. The main table is ACTIVITIES...secondary table is CODESET... Fields (column) To collect/ are... …

How i can know the DFD through a database which build by using Mysql? Anyone can help me solve this problem? Pls let me know asap, is very urgent for me.... :rolleyes:

Here is what I got and maybe this will help. In example 1 you are on the company page which shows that company and some information that is needed for this company. The bar that runs about in the middle accross that will have links for CONTACTS - JOBS - …

Hi all, anyone know how to extract data from a web database. For example, how can I extract movie information from [url]http://www.imdb.com/[/url] into a relational database? Is there any existing tools to do this? Or need I write some codes? Thanks a lot!

I have a problem selecting unique rows from a table where if two specific columns are the same value as another row. Easier if I lay it out: Table Notifications (other columns, but not useful to example) id, profile_id, recipient_id, created, type, type_id, notify I only want to return * …

Hi there! In my Library project i want to replace some text with images. I have this: [img]http://img33.imageshack.us/img33/8425/antesx.jpg[/img] Wich is generated by the following code: [code]SELECT IDLivro,Titulo ,LEFT(Nome, LEN(Nome) - 2) AS Nome ,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria ,Posicao ,Classificacao ,Comentario FROM ( SELECT L.Titulo ,( SELECT A.Nome + …

Dear Programmers, How can I dispaly and insert other language (Arabic/hindi/bangla/chinees etc) through form level field at run time window directly by keyboard???.

[code=sql]SELECT DISTINCT COUNT(*) AS occurences, post_name, post_content FROM wp_posts WHERE ((post_name LIKE '%ihop%' OR post_content LIKE '%ihop%') OR(post_name LIKE '%pancak%' OR post_content LIKE '%pancak%')) ORDER BY occurences DESC[/code] I use wordpress and am writing a script. Here is the table: post_name ihop post_content pancake house Thanks, Ian

Hey, again I grace you guys with another question. I've run into another speed bump - REPORTING! I didn't create the database - just simply adapting it to the needs. It was created externally. Since Access allows only a certain number of fields per report, I divided the reports into …

Hi i need use this sql on mysql. [code=sql]WITH destinations (departure, arrival, connections, cost) AS (SELECT a.departure, a.arrival, 0, price FROM flights a WHERE a.departure = 'Chicago' OR a.departure = 'New York' UNION ALL SELECT r.departure, b.arrival, r.connections + 1, r.cost + b.price FROM destinations r, flights b WHERE r.arrival …

Hello, plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.

Hi Friends I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database. I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and …