Databases Forum

Hi, I'm a newb of ASP Server side development area. I've just installed SQL server 2000 to my computer. I think it is for database design. Can anybody clarify how is it work, how is it possible to design? I'm well aware with HTML, CSS, ASP, Java applets etc. Hope …

Hello, I am a novice Access 2002 user and I'd like to delete all rows where the "category" fields says "buyer" as I do not need this information in my Real Estate database. For example, I tried setting a query in SQL view with these parameters: [code] DELETE FROM [dbRealEstate] …

maximum no of column in a table

Hi. I'd like to ask you another question. I read a lot of articles about the topic but I'm still not very sure how to deal with the following problem. I want to design a database that contains the properties that a real estate agency offers. The problem is - …

Hello, I tried searching but didn't see anything. How involved is it to copy a database to another server? Currently the database is on a cpanel server and I need to copy it to my new server. I copied the rest of the site and everything seems to be working …

Hello, I was looking around for some tutorials about how to backup my database in my hard disk using [B]SQL Server 2000 Enterprise Manager[/B]. Can someone explain me in a friendly and step-by-step method? (screenshots preferred) Thanx so much in advance

Hi everyone, I am still fairly new to Oracle and SQL. I have two tables with the same information in them. Table1 has the same columns as table2. The differnce between them is the date column. Table1 has 2005 records while table2 has 2006 orders. I am trying to write …

Hi. I have tables like these: [B]table1 [/B]([U]table1_id[/U], table1_attribute1, table1_attribute2) [B]table2 [/B]([U]table2_id[/U], table1_id*, table2_attribute1, table2_attribute2) The primary key of the first table is table1_id. It is auto incrementing and it is also a foreign key for the other table - [B]table2[/B]. Let's say I want to add a new record …

HI, I'm still rookie guy with mysql database, I have a mysql script file called "MYBox" in notepad and I want to export to the one of folder directory but I don't know to do that from Does. I need someone help me what command do I need to type …

I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx

Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder

I am running a website of crossword puzzle and Sudoku games. The website is designed to be: [LIST=1] [*]There are 20-30 games onlines each day. [*]Every registered user could play and submit the game to win scores. [*]For each game, every registered user could get the score for ONLY one …

Hi Everybody How can I use 2 update stmts in a single SP? I want to update two tables, with different data, but with the same, where clause Is there any way to do that? thanks

Hello. I am a software engineer and I am trying to design a database for an inventory module. I have a problem about the application of the costing methods (e.g. Standard/FIFO/LIFO/Average/etc.). Here's what I have come up with after numerous design modifications and issues. Basically, I have a record of …

Can somebody please help me to little customize the view of the phpMyAdmin? Curently this is what I [URL="http://www.peterbudo.f2s.com/extra/myAdminC.jpg"]see [/URL] but I would like to have as [URL="http://www.peterbudo.f2s.com/extra/myAdminW.jpg"]this[/URL]. Simple, I don't like options to be displayed as list of links but as tabs. What shall I change in config?

[B]Intro[/B] I'm not the best at this, but I thought we were lacking a SQL tutorial... [B]Test table[/B] My Little Test Table called "test" for this great exercise contains the following [B]FirstName[/B] [B]LastName[/B] [B]EyeColor[/B] Paul Esson Brown John Smith Blue John Howard Green Kim Beazley Gray [B]SELECT[/B] This selects data …

Hello everyone, I am fairly new to oracle and SQL and I am having a little trouble figuring out how to accomplish a task. I have three columns from a table, we will call them 'a', 'b', and 'id'. I first want to order by 'id' and then query the …

hi Excuse me for sounding amateurish, but I need help..Im doing a three tiered architecture proj, is it feasible to use JSP codes to store details about calendars and set reminders with Oracle? Im willing to take up challenges, but Im a novice.. Please advice..

Anyone know of a database app which stores records in html format on the web server and nt in a sql server. I have a spacific need for this. Or does anyone have code that will take records from a Mysql database and copy each record to a seperate html …

what is the best way to develop a database for a survey? How should I name the columns in the database? I have an survey to develop and some of the questions have up to 80 answer options + quantity for the options. For example, I have a list of …

table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 veli kollu 5 Q ; how can i get result has been showed below; ali elli 15 veli kollu 12 …

Hello, I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …

Hello, I'm a novice at [URL="http://www.daniweb.com/techtalkforums/thread67883.html#"]microsoft[/URL] access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …

Hi, I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm not sure if that was the correct way doing it coz i seem to have problem …

I have a set of information about customer environments (as a contractor providing services), and I need to create something to keep track of each customer's environment configuration. The data being gathered is very heirarchical in nature. For example: customer: bob's tv repair --environment: unix print ----printers ------printer1 --------attrib1 --------attrib2 …

[COLOR=#000000]For years I have been working with MS Access and enjoying the simplicity and ease of use. I am now making the move and converting all of my sites to MSSQL. Virtually everything works but in the process, I have found an oddity that I am not used to.[/COLOR] [COLOR=#000000]I …

Hi Friends, I have the following query, i am using the column alias by this way, select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature it works fine and i get this output. Work Code Work Nature 1 External 2 DE-Sales 3 DE-Miscellaneous 4 DE-Equipments &Transport But my requirement …

In my database, I have two tables: Forum and Files Files have two fields. First one is [B]FileID[/B] and second one is [B]FileAddress[/B]. [B]FileId [/B]field is fine. but in [B]FileAddress [/B]field I have a lot of urls. I want to just change certain parts of url. For example, instead of …

i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d. thanks

We are considering upgrading SQL 2000 to SQL 2005. I just love the idea of getting newer technology, But i'm hesitant to upgrade MS stuff, cause of bugs and licensing stuff... So here's what i'm wondering: 1. If we move to 2005, will we lose any databases/querys/dts packages/etc ?? or …

If this is in the wrong place, I apologize. I simply couldn't think of anywhere else to put it. I've recently been attempting to decipher a set of files with the extension .wbo. The files themselves appear to have been part of a database setup, but I don't know what …

hi, table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 how can i get reqult which has been shown below ? MAX value ali elli 5 ali elli 5 …

Hey, I'm doing a simple INSERT command, can you tell me what's wrong with it? I won't bother you with the php right now, cause I'm simply trying to get it work in the MySQL command line. Here is the exact command: [CODE] INSERT INTO Birthdays(ID, firstname, lastname, birthday, group) …

Greetings. How are all of you? I'm new to Daniweb, but heard of you through Mauisun. Anyhow, I have a copy of SQL 2000 standard, but it's an old school copy without reporting services. I understand that 2000 now comes with RS for free... does anyone know where this "free" …

Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me. I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information …

I'd like to split a full name field on a space into first name last and update my database, I would prefer to stick to TSQL/SQL if it can be done on SQL Server 2005, any ideas? table actors actor_id int Unchecked actor_name varchar(50) Checked rating smallint Checked actor_last_name varchar(50) …

Hi Guys I've got a bit of problem with date. When I transfer data of a table to txt file the date column that appears in the table like "28/03/2001" changes to "28/3/2001 0:00:00" in the txt file. I've tried to change the format of date in the table but …

Hi everyone I have one master table with the following structure incm_id Category SubCategory 1001 Expenses A 1002 Expenses B 1003 Income C 1004 Income D I have a child table where i am capturing amount value for the above table and structure is something like id fk_incm_id Amount 10001 …

Hi all - I am a newbie to this forum, but maybe someone there can help. I have a table using an Identity property. The purpose of it is to just have a unique id value... the problem is that the system automatically fills this table with lots of data, …

I am at the basic stage of planning out a Relational Database and I am looking for a freeware program that I can use to draw my initial relationship diagrams (with entities and the relationships between them). It would be useful if the same program could later be used to …

I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as …

I'm not sure if I should post this in PHP or MYSQL, oh well. I have a nfl predictions site, and I want to dynamically update my stadings from another table in the database. I have one table (called: matchData) with all of the matches with the following fields: lid …

Greetings all! To get to the point, I'm having issues accessing SQL databases. The specific error is as follows: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Here's the setup: The workstation(s) …

Hi all, DECLARE @STA as char(50) SET @STA = 'TT' SELECT * FROM ABC_TBL where ABC_Filed in (@STA) if i have multivalue in parameter @STA, like 'TT', 'DD', 'AA' so how can i write my statement? i only need to pass one parameter with multilist, so do anybody know how …

I am currently in charge of a running installation of the Slony replication procedure for Postgresql databases. I inherited this installation from my predecessor; I have no clue how slony works. I am in need of some kind of beginner's guide, if anyone knows where such a thing might be …

I'm getting the error [inlinecode]Incorrect syntax near '='.[/inlinecode] when I use the following case statement in a view. Obviously I'm not an expert on MS SQL, but I'm curious as to why I am allowed to use the '=' sign in a preceeding statement but not in the THEN section. …

Hi! I am creating a database for a class. It is supposed manage the hospitals Drug inventory as well as the patient's information and what patient is on what drug. I created a drug table (with drug_id, num_in_stock, and num_prescribed) and a patient table (with patient_id, name.. blah blah blah) …

hi, i am looking for a free download by oracle meant specifically for linux. i am using fedora core 5 32 bit version of linux. thanks.

Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get …

Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …