By Jorge Cano – I would like to know how I can write a query that would only show my customers once, even though they are in the database more than that. Check out the solution.
Community
Buffer Overrun in Microsoft SQL Server 2000 Utilities
Cesar Cerrudo discovered two vulnerabilities in Microsoft SQL Server 2000 and Microsoft SQL Server Desktop Engine (MSDE) 2000. The vulnerabilities are related to a buffer overrun and SQL injection. Microsoft released Security Bulletin MS02-038 (Unchecked Buffer in SQL Server 2000 Utilities Could All
Oracle 9i Locally-Managed Tablespaces (LMT) Migration Method
By Greg Johnson – So you’ve just migrated your Oracle8i databases in which all your various sized segments reside (which incidentally were stored in the single “USERS” Tablespace) and now you want to place them in appropriately sized Locally-Managed Tablespaces (LMT’s). Here is a brief guide to help
Linking SQL Server 2000 to Oracle 8i
By Carl Lim – The following were the steps we took to create a Linked Server from SQL Server 2000 to Oracle 8i. (R)
CERT Warns of Multiple SQL Flaws
By Amy Newman – A CERT advisory issued Monday evening warns of several vulnerabilities in Microsoft SQL Server.<br><Br>Microsoft SQL Server 7.0, Microsoft SQL Server 2000, and Microsoft SQL Server Desktop Engine 2000 are affected.
XML and PHP
by Santosh Jaini – “XML and PHP” is designed to teach you just one thing: How to use PHP to create XML-based applications. Unlike some of the heavier books out there, it does not attempt to cover every single PHP function; rather, it zooms in on the XML API built into PHP and illustrates, with some
Working XML: Wrapping up XI
Columnist Benoit Marchal continues to shape XI, an open-source project that converts legacy text to XML. For increased efficiency, XI now implements the SAX XMLReader interface, which proves handy in linking XI to an XSLT processor. Code samples demonstrate the techniques, and the complete source co
Perl 5.8 released
The Perl Foundation have announced version 5.8 of Larry Wall’s popular scripting language, Perl, which includes improved Unicode support.
Use XML in Access 2002 to Share All Types of Data
by Susan Sales Harkins and Martin W. P. Reid – Importing foreign data into an Access application can be difficult and time-consuming if Access doesn’t support the data format. You could try to find a go-between-a third format that’s compatible to both the data you’re importing and Access. Unfortunat
Using XInclude
by Elliotte Rusty Harold – It’s often convenient to divide long documents into multiple files. The classic example is a book, which is customarily divided in chapters. Each chapter may be further subdivided into sections. Traditionally one has used XML external entity references to support document