Databases Forum

hey all pls suggest me how to start creating database and tables in oracle.

I am with WebFusion (part of Pipex) I have upgraded my account in order to get a database. I know nothing of databases and can only design websites using Dreamweaver (not even the HTML coding) the WYSIWUG! What book or CD or anything would someone recommend for me ( I …

[COLOR=#191970]The data table looks like this date num1 num2 num3 num4 num5 num6 1/1/06 1 45 32 21 15 48 SQL script 1 should be able to do the following show the Top 3 number pairs another words if the pair 45 and 15 shows up 98 times and 32 …

Hi I have a test vserver and a production server both running linux. Currently a database has been created on the test server and is used for testing applications. Now the databse is ready to be transferred to the production database. And it should function in the exact same way. …

i have tried to answer this question like this (show your attempt) and i did it like this because (show your reasons why you think it is the correct approach) and the results that it gave are like this (show the results that your query produces) and i cannot understand …

hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod …

[INDENT]I recently bought a piece of software and am having a hard time installing it. The instructions tell me to: 1.create a database on my [URL="http://www.computing.net/dbase/wwwboard/forum/126.html#"][COLOR=green][COLOR=green! important][COLOR=green! important]server[/COLOR][/COLOR][/COLOR][/URL](I have cpanel) 2.create a user 3.Enter this information in dbsetup.php file 4.Create a directory and ftp the files in the public_html folder …

Let's say I have a column within a table that contains codes {0,1,2,3}. These codes are for what color shirt are in stock. We can say 0 is for black, 1 is for white, 2 is for red, and 3 is for blue. Then I run a SELECT query on …

Hi Folks, I'm trying to pass a string between two different forms in ACCESS with code, and I'm having some difficulty tracking down the proper way to do this. Assistance in completing this task is greatly appreciated.. Thanks in advance! - Jordan Here's what I want to accomplish: [B]Form 1: …

Hi guys, I've got a database which frequently need to be sent over the internet so that other users can update their data. As the database is huge with more than 30,000 records, it's really hard for other people to download it as they are on dial up. Is there …

Hi, I have an MS SQL 2000 database with a table that is used to store the header information on product returns. One of the fields in the table is a true/false field that indicates if the return has been processed (become a credit note). Can anyone tell me how …

Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time

Can a query running a selected database access a table on other database? How do I grant this kind of access? Going further, can a Foreign key be created among diferent databases? I'm running around this doubts for a while. Any help is welcome. []s

I'm try to let a form have a drop down bar (linking to a field in a table) which when any name within it is click it will display on the report that area

Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on …

[B]hi all,iI design database by sql by using visual studio 2005,i need to have pdf or any refrence guide to know how to write select,insert, delete statement ,could you help me[/B]

Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. …

I'm real stuck on a php jump script. Basically a value is called from my .html pages; somthing like this: <a href="jump.php?m=c"> which looks at the jump.php page and redirects the user. I track the number of clicks in a MySql database. I want the code to check the database …

UPDATE: MY COMMENTS POST BUT NOTHING ELSE? I have a form that collects firstname, lastname, email, attachment(file), and comments. I can query from my database, but when i submit data the fields are BLANK? What is going on? Below is sql on export. Table structure for table `clientlist` -- CREATE …

Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes …

ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. …

Hi All, I have a stored procedure which displays list of ADMITTED,QUEUED and DISCHARGED patients. The patient status is stored in a table. A represents ADMITTED patient, Q represents QUEUED patient and D represents DISCHARGED patient. I am using a dropdown to display the ADMITTED,QUEUED and DISCHARGED patients respectively. I …

Hi all,:confused: God Bless U, i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer 4 Goeffery Empl0yer ------------------------------------------------ Here the identity column is the first one. Now …

Is there an open source script of some sort, or can how can I make something that takes a backup of a give MySQL Database and every day it daves a .gz of the database toa directory on my server, so it is backed up automatically every day....:cheesy: Thanks for …

I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else …

why does [code]$sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "68104"'; $query = mysql_query($sql);[/code] find 23 records, but [code]$testvalue="68104"; $sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "$testvalue"'; $query = mysql_query($sql);[/code] finds none? Shouldn't they be the same? Can I not use …

[B]Intro[/B] Here is how to set up Microsofts MSDE for personal development. [B]Getting started[/B] Download the MSDE from: [url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url] Select 'SQL2kdesksp3.exe' and save it to your computer. Double-click on the SQL2kdesksp3.exe you downloaded. Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt. Start > Run …

I have a simple database for hockey stats for my son. I can enter data into the db and pull it back, but I wanted to have points, which is goals + assists, displayed without entering into the DB. I enter both Goals and assists into the database and display …

hello has anyone installed and uploaded phpadmin through dreamweaver. can anyone explain to me how? im a bit stuck

Hi, I'm trying to use a Do Loop to look at 2 seperate tables. It needs to check the value in one field on the first table. If it finds a "T" it should look to a field in the other table and count down 3 rows. Then it needs …

Hi everyone, I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of …

Hi, Is there any freeware to convert mdb format to mdf format? When converting mdb to mdf, why does it keeping prompting for server name , then user then password. Even thou i'm converting it from local server....without having to use the lans connection. Is there any other way of …

MySQL version 4.0.27-standard I want to write selected columns from a table to a file in my web site I've written the following SQL statement, but I'm unsure about the syntax SELECT event, location, eventTime, eventDate FROM commingEvents INTO OUTFILE '/home/_wmevents/public_html/wmEvents.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED …

What is the most popular scripting language on the internet? what is the most popular Database?

I've been requested to update a segment of a database, and given that it's kind of longish, I was looking for some way to directly write the data I've got from a file into the DB. I know it can be done via a third party; I have used Delphi …

[COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over …

I am new with SQL Server 2005. Is it possible to store a column ALIAS at time of table creation? User wants business name and cryptic alias.:mrgreen:

Problem: I have two tables and those two table have one field in common which is "S_ID" first table have 2 fields: "S_ID", "T_ID" second table have these fields: "S_ID", "First", "Last" ---------------------------------- What i want to do is that i need to extract the the field "S_ID" from the …

I have 3 tables that need be joined. (Not necessarily needed info but might help: using Coldfusion with ODBC to Foxpro database) Table 1: Timecard -------- loginname date wrknum time ----------- --------- --------- ------ afrank 7/17/06 1 3 afrank 7/17/06 2 2 afrank 7/17/06 3 3 afrank 5/20/06 1 3 …

Hi all, Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped. Here is the query [CODE] SELECT * FROM MOTORS WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR (CUSTOMERID = '62') OR …

Hey guys, my name is Thomas Thelwall and I am new to this place. I am currently in the process of building a website, and I am in desperate need of some help. The website I am building is nothing big, however, we are hoping that it will grow over …

Hi guys, Need some help in some query processing... Here goes,this is the results i have obtained so far |id |cat | name | 1 .....a apple 1 .....b banana 2 .....a austria 2 .....b brazil 2 .....c china 3 .....a abraham 3 .....c clinton Column cat can have at …

Hi, How to create an account in Mysql that does not require SSl Vinay

Having built a work around for the counting feature not working, in any of the normal ways Ihave the following problem. [b]This works perfectly:[/b] [b][size=1][color=#ff0000][i] <%[/i][/b][/color][/size][size=1] [i][b]RSPage[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [b]TRIM[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]Request[/b][/i][/size][i][size=1][color=#008000].[/color][/size][b][size=1]QueryString[/b][/i][/size][i][size=1][color=#008000]([/color][/size][size=1]"page"[/size][size=1][color=#008000]))[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]Len[/b][/size][size=1][color=#008000]([/color][/size][b][size=1]RSPage[/b][/i][/size][i][size=1][color=#008000])[/color][/size][size=1] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][/i][size=1] [i][b]Max[/b] [/i][/size][i][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]10[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]1[/color][/size][size=1] [/size][b][size=1][color=#008000]Then[/b][/i][/color][/size][i][size=1] [b]Offset[/b] [/size][size=1][color=#008000]=[/color][/size][size=1] [/size][size=1][color=#ff00f0]0[/color][/size][/i][size=1] [/size][b][size=1][color=#008000][i]If[/i][/b][/color][/size][i][size=1] [b]RSPage[/b] …

From last two days i am searching for the answer of this querry. I want to know how can i access the rows of tables in stored procedures using loops(Without cursor). We don't want to use cursor for that because of the performance issues.

[B][U][COLOR="Navy"]What is a database?[/COLOR][/U][/B] A database is a collection of data stored in some organized fashion. The simplest way is to think of it is to imagine a database as a filling cabinet. [B][I]What are tables in the database?[/I][/B] When you want to store some file with information you just …

Good day, Iam traying to get result of my record as below If next record is biger than previous show "1" If next record is same previous show "1" If next record is smallest show "0" if next record is same previous show "0" Example: id Time Code Price Res …

I am not a citizen, national, or resident of, and am not under control of, the government of Cuba, Iran, Sudan, Iraq, Libya, North Korea, Syria, nor any country to which the United States has prohibited export. I will not download or otherwise export or re-export the Software, directly or …

Hi guys, I have this situation.. The Min funcition in SQL returns lowest value in query but I what to return is the 2nd lowest instead. Take this table for example col=Pay(3000,2300,1000,1900,1200) Min(pay)=$1000 but I want to return Min2ndlowest(pay)=1200 Is there a way to solve this problem. Thanks for help …

Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group-> INTEL\FR6EnterpriseDB (Windows NT) Btw …