Databases Forum

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> …

PLEASE I NEED TO CREATE A TABLE. BUT ITS STRUCTURE IS COMPLEX.E.G I WANT TO CREATE A TABLE THAT KEEPS RECORD OF DIFFERENT COMPUTER SYSTEM EACH HAVING TYPE(DESKTOP,LAPTOP), MAKE(IBM,HP,COMPAQETC) AND MODEL(NX9030, Z5040 ETC) ALL THIS ATTRIBUTES ARE LINKED TO EACH OTHER. HOW CAN I STRUCTUR THE TABLE? THANK YOU.

I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + …

Hello Everyone i need help connecting my site to a database.. Either MySQL or PHP Which Is better.

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 …

I have limited oracle experience I want to dump a copy of one db and import it into a local oracle server which I'm using for dev. My problem is that I can't sort out the connect information (user@host:port/SID) type stuff. I've tried just connecting to the remote db using …

Hi folks, I'm building a database to store student exam results so that transcripts can automatically generated. This is a final year project for university so the database will never be used. I am a complete amateur when it comes to designing databases. [ATTACH]5254[/ATTACH] I have attached the relational schema …

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 emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > …

I want to build a web application with MySQL database. When more users will visit my site, more database queries will be initiated and the response time will increase. - Is there a limitation for the number of users who can query MySQL? - What are the ways to handle …

Hi, I'm a newbie in MSSQL. But i already tried using mysql. How can I create a database in mssql. I mean what would be the first step. I had installed Microsoft SQL Server 2005 along with Microsoft Visual C# Express Edition. The following are the tools found in Start>Program …

Hi, Does anyone know how to make ms access online & shared by different users? Thx...

hi there guys ,, im have just a idiot asking ,, i have sql server 2005 express but im confusing for data work , where can i install that , into server or client , or both>>.??? i know how to basic program in SQL but configuring its merely little …

[code=mysql] $query = "INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('$fn', '$ln', '$e', SHA('$p'), NOW() )"; [/code] What is the NOW() used for. Is it compulsory?

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

Say you have 3 tables A (Key, a) B (Key, b) C (Key, c) How would you select say 10 from A ordered by a, from 50 from B ordered by b, from 100 from C ordered by c? All the keys represents the same thing. Thanks!

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 …

I am trying to insert a row into a table into a MySQL DB 5.0 table. One of the VALUES that I am inserting just so happens to be HTML code. When I execute the INSERT in MySQL Query Browser it tells me "You have an error in your SQL …

Well n not a mysql expert so i need help with this sql file here r d contents of it. Quote:[code] CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; "insert into admin set username='$admin_login',password='$admin_pass',web master_email='$admin_email'"; CREATE TABLE …

[B]Hi! I make nws CMS for self. I added search function too. But I have problem. I save data with html at DB Sample: [ICODE]<font color=red>Some text</font>[/ICODE] When I search for string "some" I get this row. But when I search for string "font" , I also get this row …

[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 all I have a table in which I save a record each time when a user checks in and checks out the office through a time in/ time out device(this device takes thumb impression of user, thus inserts record) table definition is as follows: checkInOutID (PK,int,not null) employeeID (FK, …

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

Is there a way to query Oracle on the number of connections open (Not as the administrator). I am trying to setup connection pooling and I want something (on the client end) to check how many connections are being maintained etc.

Hi there I am fairly new to the development side of web design as i specialise more in the graphics side of things. However i am trying to improve my development side and just needed some general advice about something or even a point int he right direction. I have …

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 am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem …

I have below query inside sp. select groupno,a from table1 where groupno <> 'Test' It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help thank you

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 …

Hi there, I am finished writing a filemaker pro database ready to be used on the field. Everything is fine in the .fp7 file. Everything works great. However, after compiling to a runtime app, it refuses to export PDF files. When I create a database and want to export some …

I've mentioned SQL Injection attacks a few times in this forum and the Database Design forum. From the responses I got, many folks here don't know what an SQL Injection attack is. If you do any SQL interaction via a web-based interface, do yourself and the Internet community a favour …

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 …

I have seen a lot of website that have reviews on products and other things like movies, tv shows, books. I want to know how to do that. Can anybody help me with that?

I Started Installing it and i am getting this error Step 2) Connect to the database Attempting to attach to database Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/www/tropical4.freefronthost.com/Vb/Vb/includes/db_mysql.php on line 140 The database has failed to connect because you do not have permission to connect …

I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports . I wrote a sp like this:[code] ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails] ( @paramdate datetime ='02/01/2007' ) as -- select EmpID,EmpName,month(DateOfBirth) bmon,day(DateOFBirth) bday …

Hi I have 3 tables in my database. 1) [B]photo[/B] 2) [B]category[/B] 3) [B]subcategory[/B] in my photo table i save my subcategoryid which is tied to the category table. What i need to do is get the all the subcategoryname from subcategory table where photo.subcategoryid='1' and photoid='2'. I can actually …

Ok, I am fairly new to database design so bear with me. I am working on a database on Transportation. My main concern is with the relationships, more specifically with Employees. I have a main table Employees and it contains basic information about the employee. I also have a field …

Hi to all, I am new to Daniweb and I'm already impressed with the wealth of information available. With that in mind I did a search through the forum but did not see a solution to my problem. I have a couple of machines on the same network. ONe of …

I have a problem with a query and an insert. I have a database that maybe isn't the best design - it includes a field "Former Names" which is varchar 255. It contains a list of names separated by commas. e.g.: "Svea Jarl, Apollo III " I would like to …

Hi there I'm setting up twp table that are linked with a foreign key. members customer_id (primary) fobnumber ZERO FILLED firstname lastname emailaddress access_id (foreign) userAccess access_id (primary) username password (engine: InnoDB) I have created recreated these tables, when both tables seem to linked. Data will go in to one …

Hi, My name is Srinivas. im working as a software engineer in one MNC. now i want to do the oracle apps. but im in confusion to what to do in apps. 1. DBA 2. Technical Please suggest me which on is best. Regards, Srinivas Reddy. Pune.

Hi friends, I'm creating a website for my college project. on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database. I don't know how to do it. Can you please help me? I'm …

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 …

i have been getting this problem n this is getting into my nerves.. it works fine on the web.. but i need to present it on the intranet tomorrow "sunday" it gives this damn error. of mysql_fetch_array.. can u plz help me CODE: <div id="right_nav"> <div id="cga_events"> <div id="navtop" align="center"> …

Hi! I have a problem with this line: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, LOCK TABLE ON test.* TO user1@localhost IDENTIFIED BY "abcdef"; Here is what I do: [CODE=SQL] >mysql -h localhost -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your …

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..