7,494 Archived Topics
Remove Filter  | |
| | Not sure if I have the right forum...but I am wondering....my employer has advised me that I am going to need to start working with an accountant as I am the DBA. Is this becoming more and more common that DBA's have to work with financials as most databases are … Databases mysql |
| | Hi i have table with following structure mysql> show create table proc\G; *************************** 1. row *********** Table: proc [code=sql]Create Table: CREATE TABLE `proc` ( `a` varchar(16) default NULL, `b` varchar(16) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1[/code] i want to insert values into table proc through procedure what should be the … Databases mysql |
| | I have this table (Account) containing fields ID and ParentID. ParentID's value is the ID of the parent account for that account. Now, I set up a trigger that on delete of the parent, all children also gets deleted. But the delete only works one level. I mean when I … Databases mssql |
| | Hi all hopefully I can explain my problem correctly, this is my first post on DaniWeb. I'm currently working on a legacy medical research database that uses a Varchar field to store a decimal number, this field can also be used to store text entered by a researcher on the … Databases mssql  |
| | |
| | Hi everyone, So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to extract if it's a Sunday or if it's 1st day … |
| | Topic The topic of this question is: db_Connect does not connect. Hello and Thank you in advance for any assistance. [b] System info:netbeans project,database attached or provided at: [url]http://cid-b5cb457363230793.skydrive.live.com/self.aspx/.Public/school.zip[/url] [/b] [b] The purpose of this post is: Try to get a sql statement to work [/b] [b] The functionality of … Databases java-netbeans mysql |
| | I need help with a query. Looking though the forum and other online resources I can usually figure out what I need, but I'm drawing a blank on this one. I have a clients table which has client info in it, and a receipts table with receipt info. what I … Databases mssql |
 | hello! As i am trying to insert multiple rows using following command [ICODE] insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main'), ('C102','Willum','Perryridge','North'), ('c103','Smit','Brooklyn','Park'); [/ICODE] It always gives me an error that [TEX] ERROR at line 2: command not properly ended [/TEX] Please tell me why this error is occuring & what's solution to it? … Databases oracle |
| | hello to all, I am using MS SQL 2005. I have 3 tables, COLLAGE, USER, STUDENT I am providing username & password to collage as well as students. I wanted to assign Foreign Key to 'username' in both tables College & Student. i have done, 1. right click on username … Databases mssql  |
| | Does anyone know if its possible and/or practical to set up database mirroring between two MS SQL 2005 servers that are on completely different networks? The bandwidth between them is around 5mb and asynchronous would be fine. Thanks in advance, Avi Reiter <URL SNIPPED> Databases mssql |
| | |
| | Hi, I don't know how exactly how to do this. So for example I have the following set of data: Table: tbl_country_costs Country Type Cost North America Sales 2000000 North America Expenses 1250000 North America Taxes 250000 North America Profit 500000 Europe Sales 2500000 Europe Expenses 1250000 Europe Taxes 500000 … Databases mssql |
| | hi all ..how are u? i have a problem and i need ur help plz ...i downloaded Apache2.2 server and php 5.3 and now i'm downloading mysql5.1.37 ...but there is a problem ..when i start the Mysql Server Instance Configuration wizard it tells me to choose between 2 version ..and … Databases mysql |
| | Hi, I have setup the MS SQL 2000 database and setup one form for insert query to insert some personal details. But the when the detail contains special character like #,?,=,/ etc.,, database throws the error message. Like: Some details withspecial character # sp. # How can I resolve this … Databases mssql |
| | Not quite sure whether this is a question for the server side programming forum or for SQL forum. Nevertheless, here it is: What is the best way to update a record when 2 users of my site happen to edit it simultaneously? For example, assume the following scenario: Let's say … Databases mssql |
 | :'( Hello everyone, i wrote an application that makes database backups and zips them. Can anyone please tell me what i need to do in order to get the apllication to work on IIS 6 windows server 2003 SQL 05 1. The application works fine on machines for both XP … Databases mssql sql web-server windows-server windows-vista |
 | Hi! How can I seach all of the fields of every table in a databae for a particular value? When it is found, I want to be able to display the table name and the field name, then continue to search. Databases |
| | i have the following Query , i built it in sql server 2008 query builder [code=sql](SELECT CourseNo FROM ppu_RegistrationInfoDetailes WHERE (StudentNo = @StudentNo) AND (SemesterNo = (SELECT TOP (1) SemesterNo FROM ppu_RegistrationInfo AS ppu_RegistrationInfo_1 WHERE (StudentNo = @StudentNo) ORDER BY AcademicYear DESC)) AND (AcademicYear = (SELECT TOP (1) AcademicYear FROM … |
| | Hello all. I have a small db, that has news. I want to update the field "content" to add the phraze "<br>Aproved by Admin" for every row in the database. A better explanation, i have table news, with 1 table that is defined : create table news (id int, creator … Databases mysql |
| | Hi, I'm using Cron Jobs to set up an automated script which checks for jobs which were posted 7 days ago, which will then delete the record and send the customer out an email. I've got a bit of knowledge using php and mysql however i'm not sure on how … Databases mysql |
| | hi every body. i have a stored procedure with a select statment that looped by a cursor . this is the code [CODE] DECLARE res cursor READ_ONLY for (SELECT DISTINCT GroupNo FROM ppu_MajorPlan WHERE (PlanYear =(SELECT majorPlanYear FROM ppu_Student WHERE (StudentNo = @StudentNo))) AND (MajorNo =(SELECT MajorNo FROM ppu_Student WHERE … |
| | Hi guys, im trying to insert data in different tables one after another, the first table is "Account" with P_key "Username" then have another table called "Student" with P_key "Alumnus_no". Username is a foreign key on "Student" table meaning in order to enter records on Student table Username must exist … Databases mssql |
| | Hey; I'm hoping some database wizards could help me out with this question. I have been trying to decide between MYSQL or MYSQLI. I would appreciate as much info from experienced database developers/deployers on which database offers the most security. Databases mysql |
| | |
| | Apologies for the vagueness of the title but I cannot see a way to sum this up in a title... I have a table storing the individual words of sentences. Think one column is for a sentence id, the other is for a word in that sentence. So there are … |
| | hello everyone. i'm a newbie to ms sql but i understand the basics of adding tables and linking them. i have two tables tables that i have linked; Department and Employee. The Department table is the main table with a foreign key in the Employee table. now from by basic … Databases mssql |
| | Hey all :) I am currently working on a database and stuck on a question regarding SQL. I know the basics of SQL although this question has me stumped A list is required of dogs that have career winnings better than that of the average dog. List the dog_id, dog … |
| | Hey Guys, Can you please tell me which version of SQL Server is compatible with Vista. I have a Vista Home Premium Service Pack 1. Databases mssql |
 | This post has nothing to do with Michael Jackson, his death, his kids, his Neverland Ranch or anything related to him. It has everything to do with my need for a virtual laboratory where I can test virtual machines, write about them or produce other documentation about them without a … Databases microsoft oracle virtualization |
 | Busy this weekend? President Barack Obama and his IT staff are [URL="http://www.whitehouse.gov/blog/09/05/21/Opening/"]asking for ideas[/URL] through June 3 to help make government more open. The call for ideas first went out on May 21. So far, there's [URL="http://opengov.ideascale.com/"]1171[/URL]. People can vote thumbs up or thumbs down on the ideas. "Then on … |
| | [URL="http://blogs.zdnet.com/perlow"]Jason Perlow[/URL] and I had the pleasure of interviewing [URL="http://www.kickfire.com"]Kickfire[/URL] CEO Bruce Armstrong for the May 22nd episode of [URL="http://www.blogtalkradio.com/frugalfriday"]Frugal Friday[/URL] to discuss the Kickfire appliance. The Kickfire appliance is a Linux-based, rack-mountable, database appliance tuned for Data Warehousing. Here's the real scoop: Starting at a mere $32,000 US, you … |
| | Well, well, well...Larry Ellison, [URL="http://www.oracle.com"]Oracle[/URL] CEO [URL="http://www.oracle.com/us/corporate/press/018535"]added[/URL] [URL="http://www.virtualiron.com"]Virtual Iron[/URL] to his collection today. Congratulations, Larry. When is Oracle going bankrupt? Every time that I've seen a company acquire too many other companies in a short time period, they always end up in the dustbin. Oracle just acquired [URL="http://www.sun.com"]Sun[/URL] just one … Databases finance open-source oracle virtualization |
| | Will the tech sector lead an economic turnaround? Forbes.com thinks so. This week, Peter C. Beller writes that Monday’s IBM revenues numbers and the fallout from the proposed Oracle and Sun Microsystems could lay the groundwork for an economic rebound. I’ll get to the IBM numbers in a moment, but … Databases oracle |
 | It's probably a little early to be looking for implications of Oracle buying Sun (no, it's official, here's the [URL="http://www.oracle.com/us/corporate/press/018363"]press release[/URL]). They've only just confirmed it's happening, and as one of the journalists who covered Novell buying Lotus many years ago I can confirm things aren't done until they're done, … Databases novell operating-system oracle |
| | Just as the excitement started to hot up, first with the news that the controversial and increasingly popular legal free streaming music service Spotify was to open up with the release of a third party developer API, and then with the actual announcement of the availability of [URL="http://developer.spotify.com/en/libspotify/overview/"]Libspotify[/URL] itself, so … Databases api audio mysql open-source |
 | Seems every time I write a piece suggesting open source as an option, I get a couple of comments warning readers about the scary complexities of open source licenses. So I decided to ask a guy who knows free and open source (FOSS) exactly what the deal was regarding FOSS … Databases bsd mysql open-source |
| | Oracle, Research and Motion and Palm are all releasing earnings statements today, and that should pick up momentum in what has been a fairly dormant technology trading week. The web site Tradingmarkts.com thinks the earnings news means opportunity in two technology-heavy exchange-traded funds (ETFs); Technology Select Sector (SPDR ETF XLK); … Databases oracle |
| | Trying, ever so hard, to find some good news amidst the doom and gloom on Wall Street. At least the market went up for a second straight session, with the DJIA up 400 points on Monday trading; that after rising 500 points last Friday. Investors seemed cautiously optimistic about the … |
 | A few years ago, small businesses just needed a telephone line and maybe a single computer with a dial-up connection to set up shop. Now that technology has exploded, nearly every company needs a reliable phone system, a Web site, and maybe even a whole network of computers to stay … Databases mysql open-source |
| | Is the time that it takes to boot up and power down a computer at the beginning and the end of the day work? [URL="http://www.law.com/jsp/nlj/PubArticleNLJ.jsp?id=1202426038668"]A number of lawyers[/URL] are trying to settle that question. On the one hand, users start rebooting the computer and then spend up to 15-20 minutes … Databases legal microsoft-access |
| | In a report on enterprise open source usage released this week, Gartner research director Laurie Wurster stated in rather strong language that companies could face a big intellectual property issue because they are using the software without understanding the IP implications of the licensing language. But is she exaggerating the … Databases lan-wan mysql open-source |
| | Microsoft announced a new program the other day called [URL="http://www.microsoftstartupzone.com/BIZSPARK/Pages/At_a_Glance.aspx"] Microsoft BizSpark[/URL], where they give away a boat load of software and services to young startups and presumably lock them into Microsoft long-term. For a small start-up with little capital, this has to be a very attractive offer. Microsoft not … Databases microsoft mysql open-source |
 | According to the [URL="http://www.timesonline.co.uk/tol/news/politics/article4969312.ece"]Sunday Times[/URL] today, anyone in the UK who wants to buy a mobile phone will need to produce a valid passport as a form of ID soon. The story is wrapped around the planned introduction of a national database to help combat crime and terrorism. The proposed … Databases politics smartphone |
| | The other day, I saw an article on Forbes.com named [I][URL="http://www.forbes.com/2008/10/10/ellison-cloud-computing-tech-enter-cx_wt_1010oracle.html"]Ellison Shoots Hole in Cloud[/URL][/I] and just had to read further. I did read it. The whole thing. I was puzzled, then I laughed, and finally I was mystified by his comments. The article made me wonder just what the … Databases cloud-computing open-source oracle |
| | The new version of the [URL="http://www.fsf.org/licensing/licenses/agpl-3.0.html"]GNU Affero General Public License[/URL] has been published by the Free Software Foundation, based upon the existing GNU GPLv3 license but with one important difference: support for on-demand software-as-a-service (SaaS) applications. By publishing this license, the FSF aims to foster user and development communities around … Databases mysql open-source publishing web-server  |
| | [URL="http://www.qualcomm.com/"]Qualcomm[/URL] is best known for two things: making mobile phone chips and owning the once hugely popular Eudora email client software. Or perhaps I should say once owning the once hugely popular Eudora email client software as Qualcomm stopped selling it back in May and handed over the codebase to … Databases email mysql open-source |
| | Here at DaniWeb I have always been rather proud of the fact that not only is member feedback encouraged, but the powers that be read what is being said, participate in the debate and sometimes their minds, and system policy, are changed by it. For any real community this feedback … Databases advertising daniweb-feedback microsoft-access |
 | [B]Find out which are the essential design issues when developing applications for handheld devices.[/B] Mobile devices' inherent Web capabilities open a whole new platform for delivering content. Before you dive into developing mobile Web applications, read about some issues that you need to consider. When targeting handheld devices such as … Databases microsoft-access web-design |
| | According to Oxford, UK based database security specialists [URL="http://www.secerno.com/"]Secerno [/URL]databases are open to attack from growing insider threats that give employees carte blanche to access confidential data. Naturally, the company has a product to plug, a database assurance platform called Secerno.SQL, but to be honest I am more interested in … Databases abuse cybersecurity data-protection machine-learning sql |
The End.