2,403 Solved Topics
Remove Filter  | |
| | 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  |
| | 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 |
 | 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 |
| | 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 |
| | 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 |
| | 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 |
 | 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 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 |
| | Hi all, I using PHP & MySql. Here's the situation: 1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have. These skills list will be shown on their resume. I have an array … |
| | hi, i need some advise regarding storage of data is it good to store data in files rather than storing into database? (eg data like comments or additional features of products that users advertise on our website.) will it help for speed optimization. Databases file-system mssql storage |
| | Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, …  |
| | Hey can anyone give me the query to retrieve a list of databases on a server rather than this query [code]SELECT NAME FROM sysobjects[/code] which gives me a list of tables ???? Thank you Databases mssql |
| | I need to get the 'customers_info_date_account_created' from the 'customers_info' table where the field 'customers_info_id' matches with the field 'customers_id' in the following query: [code=sql]SELECT * FROM customers WHERE customers_id NOT IN( SELECT customers_id FROM orders )[/code] I basically have all the information in columns from the query and need an … Databases mysql |
| | I'm trying to display data in cold fusion but when I add my history table I get duplicate listings. I've tried select distinct different joins. How do i join my history table and not get duplicate listings My store procedure in MS SQL is [CODE]USE [Website] GO /****** Object: StoredProcedure … Databases mssql |
| | Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement … Databases microsoft-access sql |
| | I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the value of the autonumber from a master table and write it … Databases mssql |
| | I have a busted five table design for a food item guest ticket . Here are the names(Actual) of those tables: GuestTicketType, GuestTicket, GuestTicketOrderCategory, GuestTicketOrder & GuestTicketPayment. The incomplete(busted) design looks like this: guesttickettype has a field named guesttype, which is one of three guest types: dinein, takeout, delivery. The … Databases microsoft-access |
| | OK .. I was migrating an application from a staging server where the MySQL version is 4.1.10a to a live server where the MySQL version is 5.0.45. There apparently is quite a difference between query syntax on one versus the other. For example, in version 4, this worked: [CODE]SELECT uas.usr_id_users, … Databases mysql |
| | I would like to create a variable in my trigger - @DBNAME. When the trigger executes, this value should be set to the name of the database it was executed in. E.g. for the master database the value of @DBNAME would be master. How would I go about figuring out … Databases mssql |
| | I was wondering how do you countdown to a given date, like for and enevnt or something. Let's say you know the target date is let's say Christmas and you have the current date, how do I calculate how many days are between them? Databases mysql |
| | 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 |
| | 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 |
| | 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 |
| | 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 |
| | 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 |
| | 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 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 |
| | 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, 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 |
| | 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 … |
 | 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 |
| | Hello all, I am designing a database and, while I have used simple databases before, I am by no means an expert on relational dB design and so am seeking advice and help. The database functionality I need is as follows: A third normal database in the structure represented by … Databases database-design |
| | Hi, In my Insert SP, I have 5 local variables: @MemberID int, @VideoID int, @Total money, @DateRented datetime, @DateDue datetime insert into RentalRecord values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE())) When I try to execute the SP, I get this error: Procedure or function 'sp_AddRentalRecord' expects parameter '@DateRented', which was not supplied. Please advise. … Databases mssql |
| | Hi Everyone I have been given the task of designing a database for a volutery organsiation and i have been give the following information as basis to design the database.The following information below is example of a paper record •Volunteer details Volunteer ID Name Telephone Address Services provided by volunteer … Databases database-design |
 | |
| | Hi Everyone! I have to make a forum with MS SQL, and, as I'm Hungarian, we use characters, like áéíőúű, etc. Now, if I insert a text with the letter ő or ű, I get back o and u. How can I solve this problem? The users write posts in … |
| | Hi everyone. I'm printing a list of articles from my database. Some articles are set as 'sponsored', meaning they appear at the top of the list. Articles also have a 'type' field - if it's set to 0 then there is no specific type, otherwise the value corresponds to a … Databases mssql |
| | Hi Everyone, I would need your help. I have a project that I need to insert multiple records into my table. Here is more detail. I design a purchase order table with 3 columns (a, b, c): a: is primary key with identity (1,1) primary key b: is defined integer … Databases mssql |
| | Hello Everyone! I'm new to MS SQL, so this may be a dumb error, but anyway, I can't figure it out. I'd like to connect to an SQL server on the internet, I've a valid username and password, but it can't find the server. So, I've tried the following connectionstring: … Databases mssql |
| | hi all!... i have a small doubt... incase i have a database field for ID and i want my id to be of 5 digit field length... and append with zeros incase there are less than 5 digits... example if the number is 34 it should become 00034 please help!.. … Databases |
| | i am working on a home project for basically multiple members to share payments, or for one member to pay and the other members pay them back the concept is sort of like if you have a roommate and you pay all the bills, then he would pay half and … Databases |
| | i'm using vb.net 2005 express + mysql connector to connect to mysql database. i want to save image into mysql database. so i've created a table with img field as longblob. to save the image, first i convert it into byte() and then insert into the table. the problem is … |
The End.