Tags: database integration, query
News (1)
Builder's August Top Ten
Have you missed any of the hottest technology development stories published in the past month? ZDNet Australia's Builder channel can help you keep in touch with the top ten stories of August. Read more »
Features (12)
Specify DataSet in XML
This article describes a mechanism that uses a Singleton Factory Class for creating DataSet objects that represent sets of views, locating the base configuration nodes for each view via XPath query. Read more »
SQL basics: Query multiple tables
Learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement. Read more »
SQL basics: SELECT statement options
Master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Read more »
Use Perl DBI to build portable scripts for database access
Learn this functionality and it will become a staple in your Perl bag of tricks. Read more »
Create your own SQL Server views
Follow this step-by-step process from Dan Seewer to build views using Enterprise Manager in SQL Server 7.0/2000. Read more »
When to use a database-driven Web site
A database back end is a tool that helps fulfill a Web site's requirements. Whether a Web site needs a database back end is a different matter. Read more »
SQL joins made easy
If you're new to SQL, joins can be a daunting concept. There are many different types of joins and seemingly little information available that explains and compares them. But after you digest a few basic concepts, the practice of joins actually isn't very difficult. Read more »
PHP gotchas to avoid
When you are debugging PHP code under a tight deadline, start by looking for the most typical problems. Topping the list should be parsing and scope errors. Read more »
SQL Server & XML integration
The newcomer to the ranks of data storage solutions is XML. This new technology has sent many development organisations back to the drawing board in desperate attempts to integrate XML into their products before their competition does. Read more »
Creating XML from MySQL
MySQL makes integrating your data into an XML document as easy as pie. Unfortunately, importing XML into MySQL is more like chocolate cheesecake, but there are solutions available. Just follow this guide and you'll be on your way to integrating Web services with your database in no time. Read more »
News and features
- Latest
- Popular
- Features
- Most Discussed
-
This blog post covers some of the technologies available for creating applications for the Semantic Web. Read more »
-
Bridging the gap between programmers and the visionA successful project will have a hard time flying if you don't walk through the game plan before writing a line of code. Read more »
-
Social news start-up Streem shuts downSydney social news start-up Streem will shut down this afternoon, according to a heartfelt notice posted on the site this morning by its founder Elgar Welch. Read more »
-
How to Reset Windows passwords
2008/10/01 14:31:09
-
Five things to consider when choosing a Linux distribution
2008/10/01 15:50:33
-
Cyber-terrorism 'a big threat'
2008/12/01 12:43:32
What's on?
-
Space pr0n, patent karma and Yang out -- Club Builder
On Club Builder this week: how NASA plans to get the Internet into space, Jerry Yang is out the door at Yahoo and Brendan Eich discusses javascript engine competition.