Sometimes, you need to retrieve a concatenated string from one column of a table without using the cursor. To do this, you can use string aggregation. Here’s how: Create &

Extracting parameters from a file using regular expressions can be a very effective and practical way of doing things. Suppose, for instance, that you need a logon script that maps

Most Java programmers close a connection with the database directly?without closing the ResultSet or Statement. For example, take a look at the following code snippet: try { Class.forName( “sun.jdbc.odbc.JdbcOdbcDriver” );

The sizeof() operator gives you the number of bytes required for storing an object. It also operates on a data type or a value. Another way of determining the size

Let’s say your XML looks like this: default.aspx?ID=13 Now, you need to transform this tag via XSL to the HTML tag: . The following XSL will do the trick: new

If a compiler supports both and , the headers are subtly different.In particular, if you include , you get the elements of the iostream library enclosedwithin the namespace std. If

The select statement below takes the name “george” and finds how many occurrences of “ge” appear within it. select (length(‘george’) – length (replace(‘george’,’ge’,”))) / length(‘ge’) countfrom dual/ COUNT———- 2 Using

This code demonstrates how to look up a DataSource object in your Web server using JNDI Lookup. import javax.sql.DataSource;import java.util.Hashtable;import javax.naming.InitialContext;public void findDatasource() { // Initializing DataSource object DataSource dataSource

When you’re dealing with huge Ant files, it can be difficult to follow targets and their dependencies.Luckily, there’s a tool called Vizant that can generate a graph of your Ant

Suppose you have objects of type MyClass. Further assume that you have a collection (named myCollection) containing objects of type MyClass. To sort this collection, follow these steps: MyClass must

For any script that takes more than just a few seconds to run, it’s always a good idea to track the runtime itself. This is especially useful in the development

This tip shows how binding Windows Forms controls to each other can reduce the code and logic needed to synchronize color changes between controls in a Windows Form. This technique

Today, most browsers are designed to handle the known mime types in a very user-friendly manner. For example, if a server program writes an image/jpeg as a mime type, the

This small snippet shows how to use a XPath on a DataSet. Here are the used classes: DataRowDataSetXmlDataDocumentXmlNodeListXmlNode Here’s the XML file: One Three Four Two Finally, here’s the code: