7,494 Archived Topics
Remove Filter  | |
 | In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to … |
| | Hi, Please I'm new in database and I need your help, I'm working on my database project and before to continue I would like to be sure that my NORMALIZATION 3NF and my ER Diagram are correct. **Normalization 3NF** DESIGN PARTS SPECIFIED IN DESIGN PARTS PARTS USED AS SPECIFIED IN … Databases database-design web-design  |
 | Hello, In my database schema, for one fiels "exp" i have made it as float(3,2) it stores value properly up to 9.99 but for then it goes out of range and stores 9.99 how?? whats wrong in this? i expect it store values up to 999.99 but it stores uo … Databases mysql |
 | //In Node/JS myDate = moment(data.myTime.format('YYYY/MM/DD HH:MM:SS')).toISOString(); //myDate shows '2014-09-24T04:09:00.000Z' Insert INTO (dateColumn..) Values(myDate)... This is the error I get after inserting, note column in Mysql is a "datetime" type. MySQL Error:: { [Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2014-09- 24T04:09:00.000Z' for column '_dateColumn' at row 1] code: 'ER_TRUNCATED_WRONG_VALUE',  |
| | Hi, WebSQL has been deprecated but it is still useful for some applications at this time. How would I update a row of data saved into WebSQL, when using a foreach KnockoutJS binding? <table class='producttable'> 2. <tr> 3. <th>Name</th> 4. <th>Description</th> 5. <th>Price</th> 6. </tr> 7. <tbody data-bind="foreach: products"> 8. … Databases |
| | Hi, How would I save the data inputted into a list into WebSQL, when using a foreach knockoutjs binding? <table class='producttable'> <tr> <th>Name</th> <th>Description</th> <th>Price</th> </tr> <tbody data-bind="foreach: products"> <tr> <td> <input data-bind='value: name' /> </td> <td><input data-bind='value: description' /></td> <td><input data-bind='value: price' /> </td> </tr> </tbody> </table> Databases |
| | Hello Guys I want to insert into two tables with one query in mysql the first table contains a primary key and other stuff the second table contains a foreign key and other stuff I'm wondering how this would happen ? and if so how would be the query of … Databases mysql |
 | In true Microsoft fashion they have made the download process so counterintuitive that your chances of getting what you want is near impossible. Fortunately someone has created a "simple" [12 step process](http://www.istartedsomething.com/20140616/the-12-step-process-to-download-microsoft-sql-server-express-2014/). For yuks, see also [here](http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/). And to see how little things have improved see [Bill Gates Chews Out … Databases client-server microsoft mssql sql |
 | actual differecne between SQL Server's STORE PROCEDURES and USER DEFINED FUNCTIONS ? i looked up these in google but couldn't satisfy me. Differences ? better to use ? and why does UDF can only implement SELECT statements not else , y ? Databases mssql |
| | Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) … |
| | Hi I installed mssql200. It works fine, but outside application can't communicate with it because it doesn't open port 1433 as it is configured to do. Instead it opens 2 other ports that communicate with the DNS server. What is required to change in order to open port 1433? Ronni  |
 | ## Before You Ask ## - Engage your brain! We understand that running into a problem can turn off the rational centers of the brain, but please sit back and think for a bit about your problem before running off to find help. All too often a little common sense … Databases data-structure mssql |
 | I have a scenario that I am assisting with. I am not sure how to advise in this case. I am hoping that someone with a lot more database design/normalizing experience can clarify this for me. I am working on a simple database which will contain a table to track … Databases database-design web-design |
| | On the surface, the top n per group query is a fairly common one and I have used a few variations on other projects. However, I really cannot get my head around this one and I think it is due to the number of joins. My query (at the bottom … Databases mysql |
| | Hello DaniWeb, I personally work with SQL databases for web development work however I need to learn about Access databases for some upcoming AS Level exams. I asked my teacher, whether Access was vulnerable to Injection attacks and she looked at me with a quizical expression on her face so … Databases |
| | I'm having a strange issue that I'm sure has a reasonable answer, but it's making me nuts. I am using the code below, but no matter what I do, on the host's server it displays the created_date as '0000-00-00 00:00:00'. I get the correct response locally. If I go to … Databases mysql |
 | Halu guys! How to store an *image* to **MySQL database**? Do it needs to convert? |
| | Hi, I have my data which looks like '0/1,0/2,0/3,0/4' or '0/1,0/2,0/6,0/3,0/4' I need to select min and max of the numbers for example for first example my output should be 0/1-0/4 and for second it should be 0/1-0/6.. I am able to get like 0-1 or 0-6.. Any help would … Databases mssql |
| | ok so , i have a sql query puzzles . say that i have a table "PERSON" with the data look sumthing like this: PERSON Name ID ----------------------- John 12123 Kimberly 33311 Leo 87892 And i have a table score that look sumthing like this: SCORE ID MARKS ------------------------ 12123 … Databases data-structure sql  |
| | Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I … |
| | Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and … Databases client-server mssql sql |
 | Pls design a site but am still a dummie so I cant connect my site with a table in my db am using phpmyadmin. Please I need a tutor to guide me on how to begin connection to db using php. Databases mysql |
| | Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver varchar(25), dollar decimal(10,2)) insert into #temp values(201201,221,'ABC123','dwcustcomm',52.37) … |
 | OMG Optimization.... One of those things that is widely discussed but with no real specifics because everyones setup and situation is different. So I spent all day trying to find ways to accomplish this as our SQL server was maxed out. Let me do a bit of setup explination.... We … |
| | Hey All, Context: I am creating a feed for work, similar to facebooks, that hits the database every 5 seconds to see if an update is made and if so returns the results to the feed. The problem I have is that we have over 35,000 users and if they … Databases client-server mssql  |
| | Hi, Needs to construct the tables with the meta info retrived by another stored procedure I wrote, given the table id or name. There could be some flaws in the logic, not sure. The flow is - - iterate through one table which stores tbl name, id info - pass … Databases mssql |
| | here is my dilemma I have a database that consists of tables (duh!) for an award nomination project where I have a table for nominees and a table for each category of qualifications for example table 1 (nominees) name ID_NUMBER PK DEPARTMENT NAME PHONE# table 2 (education_information) ID_NUMBER FK DEGREE … |
 | Hello, I've built a timekeeping aplication from a fingerprint machine with automatic import to db and I'm getting some reports. One report is that I'm getting the employees time if they are late from work. But my table is small with 20.000 entries, but with the following query, the results … |
 | Sooo ... I learned during my schema migration that our webpages use UTF-8 encoding but our MySQL database (all InnoDB tables) uses latin1. After finally running some utf8_decode() php magic, I was finally able to successfully get all posts to display correctly again. However, now that I realize there's an … Databases mysql php-codeigniter seo |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … Databases data-structure mysql sql |
| | Hi I have one sql query. using this query i can download 10 lakhs of data in csv file for 6 hours. now i want to download 20 lakhs of data for 6 hours or less. please tell me how to increase the performance. SELECT id as imp_addr_id,userEmail, email ,name,mobile_no,gender,city,income,profession,experience,country,pincode,type …  |
| | Before I really dig in ----- HAPPY NEW YEAR EVERYONE! A few of you may remember that I have been working on producing a large wood knowledge base (woodsoftheworld.org). It is totally none profit. I am getting much closer to having enough working that soon I hope to be able … Databases mysql |
| | Hi folks. I'm looking for a bit of help and guidance on what you think would be the most suitable DB for a project I'm working on. This isn't a web-based project but as I couldn't find a more suitable sub-forum to post this query, I thought I would ask … Databases |
| | |
| | I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though … Databases mathematics mysql sql |
| | Hi, When I run query below I get duplicated records. Instead of 2, I get 4 records. I guess there is a problem with JOIN because when I remove [B]image JOIN[/B], it works fine but without [B]image JOIN[/B], the query is helpless for me. Please help, thanks in advance [B]QUERY[/B] … Databases mysql |
| | Hello everyone, I have installed oracle 9i and iam unable to open sqlplus with scott and tiger. I tried many other usernames and passwords like system/manager, sys/sys as sysdba, sys/change_on_install but iam unable to login sqlplus. With scott/tiger, it is giving TNS protocal adapter error and with sys/sys as sysdba, … Databases oracle  |
| | I currently have two queries that separately show goals scored and appearances made by players in a football team but need to bring them together in one query so I can aggregate results against each other, as well as output records from both in one html table. The two queries … |
| | Hi I am using the following join query to get a list of stores that have sold policies during the day. But I need it to be distinct [CODE] $Query = mysql_query("SELECT tblpolicies.StoreId , tblpolicies.DateReceived , DailyGroup.GroupName , DailyGroup.StoreName , DailyGroup.PortfolioName FROM tblpolicies LEFT OUTER JOIN (SELECT StoreId , GroupName, …  |
| | When is it appropriate to use InnoDB table types? What about for a forum such as this one with huge post and thread and memberlist tables? I was reading on dev.mysql.com that it is more efficient than MyISAM for large table types? Is this always the case? Would it make … Databases first-post mysql |
| | I have an idea for a friends list based off a user's account info. 'guid' is the character id number 'account' is the player's account number 'friend' is the player he is friends with 'online' 1 = online; 0= offline Here's what the layout is like: Friends List [CODE] `character_social` … Databases mysql |
 | Many of the biggest forum-based online communities, including DaniWeb, are powered by vBulletin software. So it came as something of a shock when the BBC reported that a [URL="http://www.bbc.co.uk/news/technology-10714192"]vBulletin security flaw means that any hacker could "easily access the main administrator username and password for a site"[/URL]. But is the … Databases cybersecurity mysql php |
 | when I try to access my phpMyAdmin. It occurs this error message. [QUOTE]MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and … |
| | My goal is to have a directory password protected, and have the usernames and passwords stored in mysql. Having the htpasswd linked to my database using the mod_auth_mysql module looked like exactly what I needed, but when I enable the module it disables my site. Most of the sites I've … Databases mysql |
 | Hi friends..... As when i am doing this task and found know help .............. here i am putting steps for importing data from Excel sheet into SQL Server 2003. How to Import data from excel sheet to SQL Server Note : - Sheet should be exactly same as Table in …  |
| | Over the weekend, software development and collaboration tools specialist Atlassian suffered a security breach to an internal system, potentially exposing customer passwords. The reason? It forgot about an old legacy database which had not been taken offline. According to Atlassian spokesperson [URL="http://blogs.atlassian.com/news/2010/04/oh_man_what_a_day_an_update_on_our_security_breach.html"]Mike Cannon-Brookes[/URL] the company had migrated its customer database … Databases cybersecurity |
| | [COLOR=#000000]Can you help me to normalize Online Hotel Reservation System. In the database I will store information about the hotels (name, city, country, number of stars, room prices, total number of double rooms, total number of single rooms, number of available rooms, etc); customers (name, email, telephone, address, username, password, … Databases email |
| | Hi all, I am working as a dba in a small bank and I got an assignment to develop an in-house tool for detecting fraud scenarios. I know the technical part of manipulating multiple data sources and mining data, but do you happen to know what tests/scenarios the banks use … Databases mysql |
| | Can Somebody plz tell me how to give the form ,a footer & header. I want to write in Heaer-REPORT FIRST But i m not getting how to type the text in Header & Footer, plz reply. Bydefault the user is able to resize the form,I also want that the … Databases microsoft-access |
| | I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home … |
The End.