7,494 Archived Topics
Remove Filter  | |
| | OK, now that I managed to insert data properly into a relational database using a linking table, I am now faced with pulling the data properly out of the database, a displaying it so it makes sense. As a recap, I have inserted user data into a data base that … Databases mysql |
| | Guys I need to upload an image on SQL server 2000, I dont want a C# or VB code for that I just wana know if it is possible to just upload a picture straight to SQL server without the insert statemt coz I have loads of images I need … |
| | Hello everyone: I am designing a database for a web application. The idea is user should able to pick a restaurant by enter restaurant name, category(American, Chinese) etc I currently have two tables: user table and restaurant table. I have adminID as a primary key in user table. I used … Databases |
 | I'm working on a web app in which each user will have their own account. Each account would have its own data (duh) and this data needs to be kept separate from everyone else (either by putting it in another database JUST for that user or combining all data into … Databases mysql  |
| | Hi, Thanks in advance for any help someone could offer. I'm trying to display a list of stories submitted to my site from a table titled stories, the name of the person who submitted the story and how many comments about the story have been posted. I'm working with three … Databases mysql |
| | I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at [url]http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx[/url] It does exactly what I need. The only thing that would make this code better … Databases microsoft-access microsoft-office open-source |
| | I am using MS SQL server, and I'm trying to create a SQL query that adds data to a "Reminder" table if data in the "Occurrences" table meets certain criteria. This might be a little difficult to explain. Here's the problem... I have a table "Occurrences" which i updated every … Databases mssql |
| | Sorry all, this is probably an asked question already, but can't seem to find it. I have designed and uploaded a website for a company. Static pages (3) with a simple form using php to direct the form to one of the companies e-mails. I now need a members log-in … Databases client-server mysql |
| | hello guys, i know all of you are gurus at this as for i am a rookie, i am currently using MySQL 2000 and i would like to retreive information from the database from a certain table via an HTML website what are the scripts that i could run to … Databases mysql |
| | I need help with joining these two tables: Table1 idx idy --------- one 1 two 2 tree 3 Table2 idy u ------- 1 a 2 b 3 c 4 d 5 e 6 f I want to show rows from the Table1 that have idx=one joined with all the rows … Databases mssql |
| | I am new to MySQL and did not notice this before. In order to get the query to work I have to use two different quote marks. Notice that the single quotes on the left where I list the column names are from the keyboard key with the tilde `~ … Databases mysql |
| | Hii Group, This is samuel Like to hav a small suggestion from you hope u ppl do. "[B]I would like to copy dat from one table to another of the same database in a give timestamp,I mean when system time equals to the feild time then the entire data should … Databases data-structure mssql |
| | Hello, I have question about backup and restore procedure for MS SQL 2000. If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. … |
| | Hi, I wanted to make use of a algorithm script for computing scores nd though i started doing it with a single database, i after testing script, decided to get a master and score databases both having same tables and data. I imported 2.5 GB of data dump to both … |
| | First off i'm not sure if this post goes in mysql or php so if this is the wrong place please move this post for me. I am setting up a page with a list of commands that are pulled from a mysql database. I have the page that displays … Databases mysql  |
| | Help I want to learn how to connect SQL to my java program? is there any free online tutorial? help my please.. |
| | Hi there! Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' …  |
 | Good morning everyone, Is there a way to find out [B]how many MySQL connections are on a particular page[/B]? I am limited to 50 db connections (MySQL+Linux shared server). It seems that my site cannot handle more than two people at once. I have been told by my hosting provider … Databases mysql |
| | Ok ... after receiving some great help and education as to how to design a relational database, I went on to try and create the front end for one. I am learning here so bear with me. To put this into context, so you know, I am using DreamWeaver and … Databases adobe database-design mysql |
| | The following query: [code]CREATE PROCEDURE GetDistance AS SELECT a.ZIPCODE, a.CITY, a.STATE, ROUND( (ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) ) ) * 3963,1 ) AS distance FROM Zipcodes a, Zipcodes c WHERE ( ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) … Databases mssql |
| | hi, in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern. What might be the reason. Please help me. Regards Jagadeep Databases microsoft-access |
| | |
| | I am an amateur when it comes to Advanced SQL but here is the situation. I have a Test Table with data such as below: Name(char) Qty(number) Date (char) Location (char) Test1 1 11/14/08 10000 20050 Test1 1 11/14/08 10000 20100 Test1 1 11/14/08 10000 20000 Test1 1 11/15/08 10000 … |
| | All, I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). Basically I want to fill in the form then before … Databases microsoft-access |
| | Hi Guys , I would appreciate any help on the following problem: Volunteer details Services provided by volunteer Volunteer No 10 Name Ian Wright Telephone 020 7089 6576 Address Hard Grove, isleworth Booking records client no client name date required hours required service code 004 Lee smith 19/01/08 2 01 … Databases |
 | Hi all, I have a server in our network contains the database of the project (SQL Server 2005). Suddenly a developer computer couldnot connect to the database which in that server. and now another computer did the same. The strange is the designer computer which still connecting to the server. … Databases mssql sql visual-studio windows-server |
| | I have a combo box on a sub form. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. I've tried to have the choice change the Row Source on the 2nd combo box but I've been unsuccessful. Both of the combo … Databases microsoft-access |
| | Hello Group! Its been about 5 years since i have messed with SQL. I'm creating a database for a simple .xls that will be searchable. Here is a exmple row of data: Make:ACURA Model:INTEGRA Year:1990 Engine: L4 Edition: GS Trans Cooler: x=true Oil Cooler: Horse Power:0-400 Comments: Part Number:9E-HE790-01 Tube … Databases database-design |
| | Hi there, please can someone help me with this. I have a VARchar field for NAMES and I need it order numbers correcly and I cant seem to work out the right SQL systax. My sql is this [CODE] SQL = SQL & " Select Distinct" & vbCrLf SQL = … |
| | Hi Fellows, Well. let me start by higlighting the problem i face.I have two columns namely PID which is the primary key and also a auto number.The second is Serial No. which is also a auto number. The problem i face is that when i submit my form spcifying a … Databases mssql |
| | hi I am new in SQL Scritpting and my question might sound stupid, but please help me out to understand. Can one explain the difference between the two and similarity? The need and and use of the two? As for Temporary table does one create them or it comes with … Databases mssql |
| | Hi Guys, I have some confusing part in the sql command the question is i have 2 different query : a)[code=sql] Select SUM(T1.Amount+T2.Amount) as Total From TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID[/code] b) [code=sql]Select Sum(Amount) as Total FROM TABLE3 [/code] the result if a) query is 100 … Databases mssql |
| | Hi Everyone, I'm designing a database for a Motoring School and I've been given the following information: • Pupils book either a single lesson or a course of lessons. Pupils are allocated a particular instructor when they register with the school. Sometimes, pupils ask for their instructor to be changed. … Databases database-design session |
| | Hi all, I've been given a project to design/build a distributed database on a small parallel cluster. I have plenty of experience with mysql but none with distributed databases. I've been searching information all over the net, but haven't located much on actually building a distributed DB. Can somebody point … Databases database-design mysql |
| | I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA. |
| | Hello all. Thanks for the help! Two tables: Table `posts` holds 'p_id', 'post', 'u_id' Table `users_profile` holds 'u_id', 'profile_key', 'value' How do I return [U]one[/U] row for each 'p_id' that includes all the information in the `posts` table as well as the information in the `users_profile` table WHERE `posts`.`u_id` = … Databases mysql |
| | I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA. Databases display microsoft-access |
| | Hello, I'm building a structure for a fee schedule for a construction business. let's say that the client is paying for roof. THen, the way they charge is: they charge $7.00 for the first 1000 feet and 5.00 for the rest. With this in mind, I created 4 columns: Base … Databases database-design |
| | Hi, I have produced an er diagram for an assignment which I have attached. Can somebody please tell me if it is correct and if not can you please let me know where I went wrong Thanks Databases |
| | Hello everyone, I'm a beginner with databases and I'm trying to do some homework. I'm writing down the exercise and I'll be putting what i've done so far replying this thread. I'd appreciate if someone could help me saying if I'm in the right way or how should i do … Databases |
 | |
| | Hi All, I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder. I have a table projects and a table clients [B]Projects_Tbl[/B] ProjId ProjName ClientId [B]Clients_Tbl[/B] … Databases mssql |
| | Hi all, I would appreciate any help on the following problem: I have a one-to-one-to-one ternary relationship where [B]Supervisor[/B] “chooses” [B]Student[/B] for [B]Project[/B] A supervisor chooses one student for one project (This is going to be the case when there are many students applying for the same project with a … Databases |
| | I have several questions: Here is the context: The ASP.NET application I'm building - a web service in essence - will be connecting to MSSQL to log requests to a table. These are basic INSERT commands. During high-volume hours, do I risk race conditions? How does MSSQL handle sequential INSERT … |
| | Hello ALL The project we're working on is a document retrieval system I have 3 tables as follows. Table 1 contains words from a example doc. Table 2 contains words from documents in a database. Table3 contain only one column ‘DocID’. I would like to search the database to find … Databases mysql |
| | Hi to xperts here, I do not know how to update with the follwing requirement [code]$score_update_query = "UPDATE participation_score SET score_last_update = '$date' , score = (IFNULL((SELECT avg(score)*0.8 FROM entity_score WHERE entity_score.contributor_id = contributor.contributor_id) , 4) + IFNULL((select participation_score*2 from participation_score where participation_score.contributor_id = contributor.contributor_id), 1) ) WHERE participation_score.user_id is … Databases mysql |
| | can't solve a homework problem for computer class. Any clues?: Given two tables, USERS and LOG, where USERID is a primary key in USERS and a foreign key in LOG, write a SQL statement that will return LOG records (all fields) with corresponding USERIDs in USERS. The report should include … |
 | Hi ppl! Im using a java servlet to access a mysql 5.x database, BUT when I run the servelt from my web browser I get this error : "No suitable driver found for jdbc:mysql://localhost:3306/spacemandb?User=root&Password=admin " I have intsalled all the necessary drivers viz mysql driver and it is working. here … Databases mysql web-browser web-server |
 | I was under impression that declaration of [icode]char(4)[/icode] can store only values of [B]exact length[/B] of 4 characters. However I was able to insert empty string and strings of less characters than 4. Is there some datatype that will only accept string of declared length? Strings with less characters should … Databases mysql |
| | Im trying to connect from windows xp using my program using odbc connector and SQLyog to a mysql server which is installed in windows 2000 server.. i keep on getting the same error.. i tried to use wamp server also but i was not able to connect at all.. i … Databases mysql windows-server |
The End.