Databases Forum

mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48 Warning: mysql_error(): supplied argument is not …

Hello all. This is my first post. I'm a software engineer with a general knowledge of SQL, but am no where close to an expert, let alone an intermediate. My current issue is I'm working on a query which combines 2 tables: TableA UniqueID Auto Increment ProjectName String <Extra Data> …

Hello, I have a problem with a varchar(15) field. We export this record with a bcp command and I get an new line in the export file from the specific field. When I look at this field then I just see 12 numbers in it. When I do a len …

Hi all, I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x. Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem …

Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank …

I am trying to work on a database with 3 tables. To make it easier I have created a couple of temp tables to work out the syntax. CREATE TABLE #owner ( [NameId] tinyint IDENTITY(1,1) NOT NULL, [Name] varchar(50) NOT NULL ) INSERT INTO #owner VALUES ('Thanatoid'); INSERT INTO #owner …

Hi i am making a table where i have different currency fields showing the salary of different staff and then a total field where i can calculate each staff's salary on rent, transport etc... now how do i make the total field show the total i.e. addition of rent+transport+education

I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to …

[code=sql] CREATE TABLE users ( user_id int(10) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=MyISAM; [/code] [COLOR="Red"][U]Questions:[/U][/COLOR] 1. What is the purpose of MyISAM? 2. What happen if I created the above table without MyISAM.

HI I am software tester and want some small project which made in MS-sql server 2000 for the testing even if you have some corrupted file (not virus infected)please provide me . THANK YOU

Can someone through this forum help me out to design Financial Accounts System including Ledger posting, or provide me a copy of the database design or allow me to download such a database design I will realy appreciate the cooperation. Thanks my e-mail is [EMAIL="amjad_munir@hotmail.com"]amjad_munir@hotmail.com[/EMAIL] if some one wish to …

I need to calculate the approximate current age in years of patients at a clinic. We don't have the birthday of all the patients, but we know how old they were when then first registered and we know the date they registered. I am doing a calculation which returns some …

Hello I need help in microsoft access. I am creating an electronic database so i need 2 events, 2 resources and 2 agents for example event (order) resources (product). and i also want to know how do we link the table with each other i am talking about relationship Thankyou …

we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005. But we have some permission issues for …

Hello experts could someone tell me how can i combine multiple records into one value. Sample in MS Access: (Lastname & "" & "," & " " & Firstname) AS Name How can i do this in MySQL?..tnx in advance

Ok, I've had enough of looking at the same piece of code now. Someone please enlighten me as to what simple bloody thing it is I'm missing: [code=php] $pp2 = $_REQUEST["pp"]; $io2 = $_REQUEST["io"]; $sn2 = $_REQUEST["sn"]; $re2 = $_REQUEST["re"]; $sd2 = $_REQUEST["sd"]; $ed2 = $_REQUEST["ed"]; $dp2 = $_REQUEST["dp"]; $rn2 …

Hi, What needs to be done to connect TOAD with oracle database ?....i have installed oracle client 9i..

what is the required t-sql for getting all the child categories in a parent category? my table is like this : id | name | parentid

Hi i want to select the values from my table where a column must contains some value. So i wrote this Select * from RG_TAB where CMCode = 4 and CMCode = 5 This query not giving me any result but Select * from RG_TAB where CMCode = 4 Or …

hi, after i create a table using toad.im tryin to insert values thru sql but it says the given table does not exist.i cant find any commit button..what could be wrong???

i just wanna ask if it if possible to make columns n ms access and how... because i am making a personal data sheet thanks in advance more powers and God Bless You all

sorry if this a very newbie question but what wrong with my code : [CODE=MSSQL]select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier where TBIn.SupCode=Supplier.SupCode and TBIn.IdBrg=Barang.IdBrg and TBIn.IdBrg = B002[/CODE] Please Help, Best regards...

Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr fax_nr ---------------------------------------------------------------- 1 5 info@test.com 2 …

Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.

I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with …

Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …

How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, …

I've got a Perl script that lets a client of mine dump and restore his inventory database. It has worked fine for years, only I recently noticed strange file results. Instead of dumping the data to the file, I found this (I've munged the db name): -- MySQL dump 10.10 …

I am using SQL Server 2005 to run a stored procedure to update, delete, or insert depending on some conditions. The problem is that it gives the following error: Msg 4104, Level 16, State 1, Line 49 The multi-part identifier "PART.ID" could not be bound. I have it inserting some …

Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select …

Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when …

I'm working with SQL Server 2005 on a stored procedure, but it appears to be going through both parts of the following statement, and not skipping the second half if it is supposed to. Basically it should update the row if there is data there, and remove the row if …

LOL - I figured it out - but thanks for looking :)

I have a standard SELECT query as follows: [code=MySQL]SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3[/code] ...and a SELECT SUBTRING query as follows: [code=MySQL]SELECT SUBSTRING(content, 1, 200) FROM diary[/code] I'd like to combine the two so that it selects the latest 3 entries in the …

Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database.

Hi guys and gals Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project. ;)

Hi there What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to …

I've created my own forum and would like to display username - from users table title - form topics table and a count of comments - from replies table I 've got the first bit sorted ok SELECT username, title FROM users, topics WHERE users.userid = topics.userid ORDER BY RAND() …

i have three table 1st viewleave 2nd applyleave 3rd personal based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email address........please tell how to do tat.. CREATE TABLE `viewleave` ( `leaveid` varchar(25) NOT NULL, `message` …

Hi, I'm having a having a hard time trying to insert some data into a mysql DB, so I'd like to know if there is some kind of error log that could help me. I've already looked into the binary log but it didn't help me. I also started mysql …

Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total …

I have a query to find dates based on Between And criteria but I can't pull up anything in 2008. all 2007 dates work properly. What am I missing? Thanks

Has anyone installed it? I've downloaded both express and full developer edition but I can't get past the user account stage. Can someone give me valid userID's and passowords for it? I don't have a password on my user account though..

Hi, What is the datatype for storing dates? DATE datatype is not working.... I wanted to insert the joining date of an employee into the table...

I've two tables where their composite keys are foreign keys that references each other. table1 (projId, userId, name, add) table2 (projId, userId, status, responseDate, reason) I need to retrieve table1(name,add) and table2( status, responseDate, reason) with projId only.. my query is [CODE]Select ap.name, ap.add, p.status, p.responseDate, p.reason from table1 ap, …

This is an annoying error...tried re-writing the code a few times...deleting and recreating the table...etc...still the same result: " ... You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use near 'desc) VALUES ( '', '1', '1', …

Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10? If so could you post the code please. Struggling and stressed...with qwerty imprinted on my forehead

Greetings, I'm having a heck of a time trying to get this pl/sql program to work. I'm to invoke it using shopper id and then again by shopper last name. I've banged my head on this for a while now and it seems that every change I make creates more …

Greetings, I've posted this question in other news groups (msdn and a few others) without any response.:sad: I hope I don't get into any trouble for posting this question here, but I reach out for your help.:confused: I have an excel file stored in a data base table as an …

Hoping someone can shed some light on this one, using MSSQL 2000, I have a query like this; Select T.TransactionRecordClass, T.ClassDetail from [remoteserver].otherdb.dbo.Data T where T.TransactionRecordClass like '10000002%' which will return around 10000 records in under 1 second. My issue is that I need to make this part of a …