7,494 Archived Topics
Remove Filter  | |
| | First of all Hello to this forum. I have the follwoing problem. When I am runnig an UpdateCommand with codebehind : sqldatasource1.Update() I get the following error. (I want this command to CompareAllValues) [COLOR=#000000][B][I]You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed … |
| | Hello, I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: … Databases mssql |
| | Hi, I have two fields...both are not unique, but both can't be the same. So two fields: user | fruit | joe11 apple angel bananna bobby apple jeff orange julie orange angel apple angel orange ---------- So lets say the above was my table, notice how both fields are not …  |
| | Hi, Need in brief: [COLOR="Blue"]Have 3 tables. I need to extract data from two tables and fill the third table.[/COLOR] Table structure: COM PROFILER: CREATE TABLE comprofiler ( [COLOR="Green"] id int(11) NOT NULL default '0', user_id int(11) NOT NULL default '0', firstname varchar(100) collate latin1_general_ci default NULL, middlename varchar(100) collate … Databases data-structure email mysql  |
| | Hi i having a few problems what i need to do is find duplicate rows in a mssql database i can do from one table but i need it to run across 2 tables this is the code i useing to do one table SELECT COUNT(*), sID1, sID2, sID3 FROM … Databases mssql |
| | Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in … |
| | Already typed my post once, having to do it again.... With the following code in MS SQL 2K: SELECT Users.*, Trainers.FirstName AS TFirstName, Trainers.Surname AS TSurname, Trainers.DisplayAs AS TDisplayAs, Trainers.DIRealname AS TDIRealname, Trainers.UserID AS TUserID, Trainers.TrainerExpiry AS TTrainerExpiry FROM Users LEFT OUTER JOIN Users AS Trainers ON Users.UserTrainerID = Trainers.UserID … Databases asp first-post mssql |
| | hello , is anybody here who help me in foxpro. for following requirement every week i get a table of some databse from server and i have to modify the structure of that file every time to use that file in some other application ,so i want to make a … Databases microsoft-access |
| | Dear all I have a few questions. I would be grateful if you could take the time to answer. I have installed on windows xp home apache2, php 5 and mysqlserver 5. The [URL="http://localhost"]http://localhost[/URL] page of apache works fine. The <?php echo phpinfo(); ?> page works fine. However when i … Databases apache mysql php windows-server |
| | I currently have a form that i have created using html, (can create in another language if makes it easier) however, i can't seem to find how to send the information from that form to my database. I have searched over the internet and asked some people that I know, … Databases mssql |
 | I can't find it anywhere! :rolleyes: I want to install it onto a test Red Hat box so that I can replicate our live environment before doing an upgrade. I've scoured and scoured. If the internet had been a saucepan, it'd have very little of its copper bottom left. :lol: … |
| | hello frinnds, i am new to this forum.........afte seeing this i feel it is gonna helpme..... right now my problem is-> i am usin msql, here i am using a table in a database..inside this table i have field called [B]ID, i[/B] want autoincrement feature for this field......... i don … Databases mssql |
| | [code]mysql> insert into fund_history select * from temp_fund_history where data_date='2006-06-30' and index_num between 1 and 10; Query OK, 0 rows affected (0.03 sec) Records: 10 Duplicates: 10 Warnings: 0[/code] I am really wondering why this INSERT statement is not inserting 10 records. Its saying 10 Duplicates: 10, and there is … Databases mysql |
| | I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one … Databases first-post mssql sql windows-server |
| | Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number …  |
| | I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this? Databases mssql |
| | Hi, I have an access database that I use for recording the sickness of my employees. One of the tables holds the dates, Start Date, End Date and Count of Days etc. I need to produce a query that will show me a count of all of these dates between … Databases microsoft-access  |
| | Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not … Databases mssql sql windows-server |
| | Hi All, I am writing this just to even know if this is possible. What I would like to do is a UnGroup. Crap this is so hard to explain...okay I have a table in sql that is five columns long. The first Column is, ohh never mind. Copy and … Databases mssql |
| | Sir, I had mysql file ss.sql. Now I want upload the file in the Database. Is there any way to do the same. Kindly help me in the matter. Ashwin Perti |
| | hi,everyone my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I … Databases mysql |
| | I'm having problem in inserting into table. I'm inserting data from one table into another [I]insert into table1 select * from table2 where condition = expression[/I] I have 962 records in table2 for specified condition, but only 105 rows are getting inserted. Both tables are in same database. What could … Databases mysql |
| | Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i … |
| | Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as … Databases mysql |
| | I need to set ft_min_word_length=3, so that my users can perform boolean fulltext searches for words of three characters instead of four. However, I share the MySQL server with other customers of my ISP. My ISP's administrator is willing to change this system variable, [B]provided[/B] I can show him an … |
| | Hi i try to sum two column in Sql, but don't get it.... this way is not working.... [COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#808080]+ [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])))[/COLOR] [COLOR=#808080],[/COLOR] and with that is not working to [COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#000000] as A ,[/COLOR][COLOR=#808080] [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])) as B[/COLOR][COLOR=#808080],[/COLOR] sum(A+B) as Result can someone … |
| | Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it? mysql_num_rows(): supplied argument is not a valid MySQL result Regards, omesa Databases mysql |
| | hello I am new to sql and database design. I am looking for to learn diffrent ways of designing them and making them efficent. any tips or hints will be appreciated. Thank You All. Databases database-design sql |
| | Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g … Databases mssql |
| | I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I … |
| | I have put together a Human Resource database for your company. The HR manager wants me to setup the vacation time field to automatically adjuster it's self each time their vacation changes each year from their Hire Date. My fields are: Date_of_Hire and VTBeginningBalance. Each time their hire date comes … Databases microsoft-access |
| | I need to "clean" the database so I only have data starting from 1-1-06. Can anyone help? Thanks.:) Databases mysql |
| | |
| | HI Everyone, I have recently joined this site because I cannot find help anywhere online about FileMaker Pro (without a charge, that is). Every month I import about 80 excel files from 1 file folder. In order to do so, I have to individually import each file into my database. … Databases microsoft-access |
| | I am trying to do something in Filemaker Pro that I could do easily in Access with a subreport. I have a table with the fields (student ID, subject, course number, course name, grade, CRN, semester, credits). In one section of the report, I want to list all records with … Databases microsoft-access |
| | My page displays the info in the text boxes, but when we run the click sub for the update button it returns the info that it has been updated sucessfully. Here is the page code and below that is the stored procedure it uses, but not update in the database. … |
| | I have been trying to learn this database thing for the last 3 months without much success , its understanding the structure that puzzles me the most say for example i want a page listing all types of fruit oranges apples bananas grapes then i would want another page listing … Databases mysql  |
| | Hello and a BIG Thank-You!!! To you who have helped me... This I think will be my last image question. Okay the user uploaded a picture , it went to the (Photos directory) (Name and Type Show) Great!... Next to the (Mysql Database under aphoto_filename) Again with (Name and Type … |
| | Does anyone know of any way to select only a certain number of records to appear on one page - say, like 30? - then having links to other pages of records if the number of records exceeds 30? Databases mssql |
| | Hi All, I have a problem with a table level constraint i want to create. i have 3 tables: products categories product_categories - use to connect product to categories since a product can be added to more then one category. my problem is i want to create a contraint in … Databases mssql |
| | Hi, I have a slight problem. I am trying to create a mail service for a new game which I have started creating recently. Each user that registers also creates a table for their mail. As the usernames are variable and the table name is the username, I need to … |
| | Hi all, I am seeing the following error in my tomcat log file. Please see the attached file for the full error with stack trace. When I first bounce the server all is ok. After running for some time (I haven't yet been able to determine the exact amount of … |
| | I have a table to store the answers of users of our sweepstake. The table that consists of 3 fields: the userid, the questionid and the answervalue. Now I need to find the users with the most identical answers as a certain user. For example I may have values like … |
| | In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any answer. Databases client-server mssql sql |
| | I have a table in MS SQL Server 7.0 Like this: Id Cat_Name Definition Image 101 A1 --------------- ************* 102 B1 ----------- ************* 101 A2 ------------------ ************* 103 C1 ----------------- ************* 101 A3 --------------- ************* 101 A4 ------------------ ************* 102 B2 -------------------- ************* 101 A5 -------------- ************* 101 A6 ----------------- … |
| | Hi, I'm fairly new to databases and database design - I'm wondering the best way of implementing a method of versioning a record. I'm designing a database for a simple document management application. The database has users who create and edit documents as well as adding comments to the docs. … Databases database-design |
| | I am developing a system where: - Users can go to a website, sign up for classes, and pay for classes - Or they can come to the store and sign up in person I was wondering if someone could walk me through the steps from the beginning of making … Databases mysql |
| | Hi, I'm writing some complex queries on a very poorly designed database. We're running on MS SQL Server2000. I was wondering if its possible to do in-line if-else blocks within a query.. i.e. [PHP] SELECT * FROM tablename IF (condition1 = 'a') WHERE condition2 = 'a' ELSE WHERE condition2 = … |
| | Hi, This is Abhishek. I am a newbie in PHP and we have to develop an Inventory management application. We have a MySQL database structure which looks like this (dissimilar) VORTEX Table 1: hardware ========================================== hwid | total | manufacturer | hardware type | model no | specs | remarks| … Databases mysql user-interface |
| | What i am trying to do is to extract data from mysql table into a .CSV file and then after editing upload it again to update my DB. I am planning on using php but i at the time dont know which command will convert mysql table into .CSV and … Databases mysql |
The End.