7,494 Archived Topics
Remove Filter  | |
| | Hello, I'm making a phone book application (ASP.NET, C#). I store general information of people such as name etc on one table called "people", and I've another table called "relatedInformation" which has 5 columns (ID, Name, Info, PersonID, Type). In this table I store all other information regarding people, because …  |
 | I have 2 tables: Match and Team. Match(matchID is primary key, team1, team2, ...) Team(TeamID is primary key, ...) I mean how to force team1 and team2 is different from each other. Ex: We won't want to see: Brazil vs Brazil ^^ Any help is appreciated... Databases microsoft-access |
| | Hi all, I seem to be having a problem. I get the above error when trying my login script. [CODE]<?php $dbhost = "localhost"; $dbname = "userlogin"; $dbuser = "adminuser"; $dbpass = "xxxxxxx"; $dbtable = "users"; mysql_connect ( $dbhost, $dbuser, $dbpass, $dbtable)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); session_start(); $username … |
| | Hi, I would like to know if it's possible to create a procedure, where we pass 2 arguments (the databases where the search must be done) and how to use those parameters in select clause What I would like to know is if it's possible something like: [CODE]create proc dbo.uspMySearch … Databases mssql  |
| | While i was importing .sql file in my database i got this error #1064. [code] #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `att_poll_log` ( `id` … Databases mysql |
| | I recently started developing with MySQL and PHP. I'm building a web application which allows users to post a question which other users then post responses to, much like Yahoo! Answers. I would like advice about how best to structure a database to support this application. It would seem natural … Databases |
 | Hello all, im looking to try and find a simple set of pros and cons with regards to comparing Enhanced-Entity-Relationship Diagrams and Object Role Modelling diagrams. Basically any plus or negatives given for/against either would be great. Databases |
| | I'm working with SQL 7 on a Windows Server 2003 R2 Ent. Things will be working just fine and then we will for some unknowen reason start getting this error message and then we have to restore the DB to resolve it? This has now happened twice within the last … Databases mssql windows-server |
 | I wanted to ask this before I tried to build these two large tables myself. Does anyone know where or if I can find an MS Sql table of the United States, Cites and States. Possibly with the relationship between state and cites already built, or even an Sql procedure … Databases mssql |
| | HI, I am a beginner. I have designed a simple site in HTML. I want to add a login and register page. And I want to add a database to store the login and register informations. Can anyone help me with this? I am beginner in database. Databases html-css microsoft-access |
| | Hi, I am currently trying to develop my system that would send an email reminder to a user when the deadline for a particular matter is approaching. I did a bit of a research online and I realised that I will need to do some sort of a cron job. … |
| | Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order … |
| | Hi Group, I have a small Query regarding calling a procedure from a trigger please go through the following and please let me knwo if any thing wrong happened. [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`sample` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sample`() BEGIN insert into test.out(num,message) select num,name from test.in,hotel where … Databases mysql |
| | How would I select everything from last month in a sql statment my cell has a time stamp in it [CODE]SELECT DateTimeStamp from Get_estimates[/CODE] Ouput [DateTimeStamp] 2008-02-28 11:39:35.247 2008-03-09 13:15:12.513 2008-03-09 13:16:53.700 2008-03-26 13:30:20.077 2008-03-26 13:30:51.810 Databases mssql |
| | Hi there, I'm completely lost. I have 3 tables: - work (workID, description) - machine (machineID, name) - work_machine (machineID, workID, hours) What I want is to obtain a result similar to: work, machine1, machine2 A , 1 , B , 3 , 5 The problem is that the number … Databases mssql |
| | I'm trying to make a membership system where users can 'approve' or 'disapprove' another member only once. If they have approved the member previously or disproved the member previously, I want to be able to detect it. I also want to display the average user approval for each member on … Databases |
| | I am building a site search that involves a union of two tables in two databases and needs to have relevancy factored in. I do not want to use a full-text or boolean search. I can search one database and one table using relevance fine. I can union the two … Databases mysql |
| | Hi all, I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone help me? I would need to get something like:- [CODE]Year | Month … |
| | Greeting When it comes to SQL I'm a novice and I think what I want to do is WAY outside my expertise. I have a file management system called ProjectWise. Everything to create the folder path is located in a single table. You start with the lowest folder then you … Databases mssql |
| | I took a backup of a database a while ago and I'm having trouble with running it on a new (Windows 2003) server through phpmyadmin 3. Whenever I execute it the resulting tables, fields and data are all converted to lowercase! If I use phpmyadmin to create them it works … Databases apache data-structure mysql windows-server  |
| | Hi Group , A small Query ,I need to know how can I notify a new row entry in a table. to be more specific I have a table Users If at all a new users registers from web his details are stored in database. i would like to know … Databases mssql |
| | hello Guys, I facing a sql query problem which is i need to join many query into one query. That is : a) [code=sql]SELECT sum(Total) As [MONEY1] FROM ((SELECT SUM(T1.Amount+T2.Amount) AS Total FROM TABLE1 T1 INNER TABLE2 T2 ON T1.ID = T2.ID) UNION ALL (SELECT SUM(T3.Amount+T4.Amount) AS Total FROM TABLE3 … Databases mssql |
| | using PHP with mySQL, or ASP with msAccess 2000 on a win2000Server web server; also using a "rich text format" utility to allow formatting of text in a text area: when i use the mySQL command "UPDATE", and data from the textarea is written to the database, it adds erroneous … Databases html-css mssql mysql web-server windows-server |
| | Hi I have a problem when I am copying data from my excel document to sql server 2005. I have a document called database.xls Every time I try to copy files from the document to sql server. It comes up with an error. "Column 'tid' does not allow DBNull.Value." You … Databases mssql open-source sql web-server |
| | hi i need to undresdatn the relation which mention in that table which i attached plzzz.... any one. thanks inadvance... Databases mysql  |
| | here is my situation: i have a prepay online store and i advertised a contest to win a free code when buying at least 5 codes during 24.11-24.12 2008 period. now this is my table: [CODE]orders_id customers_id customers_name customers_company customers_street_address customers_suburb customers_city customers_postcode customers_state customers_country customers_telephone customers_email_address customers_address_format_id delivery_name delivery_company … Databases mysql |
| | hi, any help will be appreciated. I use Oracle discoverer plus. recently I tried to build a running total (average) calculation using the template provided. I defined 10 previous observations for this purpose. discoverer performed the calculation but the problem is with the first 9 (in this case) observations of … Databases oracle |
 | Sorry for the simple question... But please i need help from you guys... How to import and export the database in oracle..iam have been using oracle 8i in my computer... im completely new to this environment... please help on this.. Thanks in advance... Shanti. Databases oracle |
| | In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary … Databases oracle |
| | |
| | I need to replicate data from server A to server B, server A is for transactional use, while server B is for reporting, where we do some database modification, for example posting, the problem is everytime the replicate agent run, it reset the modification into the original data. and when … Databases client-server mssql |
| | We are building a query to count the number of events per hour, per day. Most days there are hours that do not have any activity and therefore where the query is run the count of activities per hour show up but there are gaps and the query excludes these. … Databases mssql |
| | I need to connect my hosted vps in a data center to my sql server so I can pull info out of a database for our website. I setup a vpn by the windows dialup vpn wizard. It works fine but when I logoff the VPS it disconnects the VPN … Databases mssql sql windows-server |
| | i want to get the [COLOR="Red"]ROLE [/COLOR]of an user by entering the username and password in login form.... for example:: username password role ramesh xxxxxxx manager loginform:: enter username: enter password: [U]plllllzzzzz any one post the required query of the above problem[/U] Databases oracle  |
| | Hello guys. I'm trying to make a database about football games (results, managers, players etc.). For my Players table i want to include these stats: - first and last names, nationality, date of birth (constants through time) - games played the current season, goals scored, cards received, minutes played in … Databases mssql |
| | hi, i just have a general question that if I registered for a domain with space to put up my files. can i use that space to store my database? such as connecting php myadmin to the domain. can anyone explain a bit on how to do this?  |
| | I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008" Databases mysql  |
| | I accidently inserted a lot of my data wrong in mysql. Its something like this 32-Bit versions • Windows Vista • Windows XP • Windows Me • Windows 2000 • Windows 98 • Windows NT 4.0 • Windows 95 • Windows NT 3.5 64-Bit Versions • Windows Vista x64 • … Databases display mysql windows-vista |
| | Hi, I am trying to copy som data from an excel document that I have on the server into a table in my ms sql server. I think the problem now is that I am having trouble connecting to the sql server. I'm using sql server 2005. You can see … Databases mssql open-source sql web-server |
| | how to convert the file format of access .mdb to .dll system? can anyone know? Databases microsoft-access |
| | hi i have an error when i try tio insert special characters ' insert into lydia(id,resume)values('$ids','$i') idis int,resume is a varchar ERROR3:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Degree please do … Databases mysql |
| | I'm using the Brinkster control panel Database Manager to investigate a database on a site I just took over. I don't know anything about the database. I tried a SHOW TABLES and got an error. I also tried SHOW ALL. Do you think I need a ; after the command … |
 | hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this one little problem... How can i get the application to display a list … Databases mssql |
| | Hi all, I need help in designing a database for an equipment finance system I want to implement as a project. This is how the system will work. 1. A client would make an application to a finance company for a loan to buy a machine. The loan will be … Databases finance |
| | Hello ALL, I have a table contains words extracted from a few documents. [Code] DocID Word Tag 1 Book noun 1 Pen noun 1 Pencil noun 2 There prep 2 Hand noun 2 Have verb 3 Oil noun 3 Thorough adv 3 Drive verb 4 Red adj 4 Blue adj … Databases mysql |
 | Is it possible to update the AUTO_INCREMENT value who's attributes are primary key, not null, auto increment and also an INT type The thing is I need to synchronize the 'image_id' to access images sequentially and if one row is deleted the sequence is destroyed Help me! [code] <?php include('db_conexn.php'); … Databases mysql |
| | |
| | Hi i have a website hsoted on a shared server with a service provider and i am getting the below error at times while i am adding text in the database thru the CMS module provided to me by the developer. The developer says its a server issue and and … |
| | hi, i have one table called EMP with 3 fields SSN,ENAME,MGRSSN. query to retrieve all employees name and their respective manager names(only using this table no other table and ssn primary key. i know till here.. [code=sql]SELECT ENAME,??? FROM EMP WHERE SSN=MGRSSN ;[/code] here im only getting manager's name..so how … |
| | Hey there, i really want to break my pc by now can anyone tell me how to get around this ?? I just want to update the new database here [code] USE NGCOLLECT GO INSERT INTO dbo.Cases ( CustId , Consultant , Bank , OldAccountNo , LastAmountReceived , DateReceived , … Databases mssql |
The End.