Consider for a moment just how hideous the following URL is: http://www.zope.org/dtShow?MEMBER=mcdonc&TIME=3am There’s no way you’re going to tell your mom that URL over the phone. You’re gonna have to email it to her, or in the worst case, drive over to her house and type it in for her if y
Author: SSWUG Research
How to use Oracle LOBS/BLOBS/CLOBS
Oracle 8 supports LOBs (Large Objects) which are objects with methods resembling those used for file access, e.g. read, write, length and trim. LOBs are quite powerful but very tricky to use, here is a description of what you need to know to get aquainted. You need DCOracle2 for LOB support (Ora
Custom Exceptions using Microsoft Exception Management Application Block
(Shreenivasa Ramadurai) The Microsoft Exception Management Application Block provides a very simple framework for handling exceptions. It also provides the Interface to implement custom exception to log the error in different Data sources like –Text File –Alert to Pager –MSMQ –Data b
Sort Dates With XSLT
(Dan Wahlin) XSLT 1.0 doesn’t let you sort dates using the xsl:sort tag. This can present a problem because dates frequently play an important role in various applications. For example, XSLT doesn’t let you sort the Customer nodes based upon the data contained within the CustomerSince nodes in this
Benefits of XML in Business
(Phoebe Yi, Paul Fretter and Sophie Zhong) XML has become a hot topic over recent years due to its core qualities: extensibility, platform independence, and self-describing nature to name a few. Considered by many to solve a wide variety of e-problems, it has enjoyed an optimistic following that bel
Virtualize This!
(David Stodder) On September 22, at the IBM Almaden Research Center in San Jose, California, friends, relatives, and former colleagues of Dr. Edgar F. Codd gathered for "an afternoon of tribute and celebration" of his life and work. The greatest legacy left behind by Codd, who passed away on April 1
Expiration Date Calculator
(John Peterson) Some scripts you have to write… others you write because they’re interesting or just plain cool… and finally there are scripts like this… scripts that don’t do much and take longer to write then it would have taken you to just do what you wrote the script to do! Let me expl
Create a clustered index on primary key
(Prashant Dahalkar) Here’s a way to create a table with clustered index on a composite primary key. A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore, the table can have only one clustered index. The leaf nodes of a clustered ind
@@IDENTITY crisis
(Manohar Kamath) If you have worked with SQL Server, you are probably familiar with identity columns. These are equivalent to the “AutoNumber” columns in Access. The main purpose of these columns is to provide a primary key to the table, when a primary key can not be defined using other fields in th
Seven Ways to Mess Up with XML
(PG Bartlett) A successful XML publishing project inspired this article. The project’s leader, who claims that the financial return gained for his company “made his career” there, achieved success for two reasons: he focused on the right goals and executed the project in the right way. This arti