March 22, 2006

Retrieve Records from a Supplied SQL Statement

To retrieve the required field from the table based on the supplied condition, use the following code: Function GetQueryResults(strSql As String, Optional ReadOnly As Boolean = True) _As Recordset Dim rstQueryResult As Recordset Set rstQueryResult = New Recordset strSql = GetQueryString(strSql) rstQueryResult.CursorLocation = adUseClient ‘ gCnn is the Connection Object

Run Tomcat with a Security Manager

To run Tomcat with a security manager, you must add your own policy lines to the catalina.policy file?like when you build a SecurityManager. The catalina.policy file can be found here: Apache GroupTomcat 4.1conf After you modify this file, run Tomcat from the comand prompt like this: Apache GroupTomcat 4.1in>catalina start

Finding a SQL Server Object

To find a SQL Server object, such as a user table, query the sysobjects system table in the local database. If the database name is unknown, use the following query: Exec sp_MSforeachdb ‘Select * From ?..sysobjects where name like ‘objectname”’ The ? in the query is replaced with the database

Speed Up Your SQL Inserts

atabase performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence, many a performance optimization and tuning book discusses the ways to make queries faster. Even RDBMS makers understand the need

Using Ink on the Web

he Tablet PC SDK makes it easy to get Ink onto your Web page, but then what? This article walks you through the easy part and then dives into some of the trickier stuff such as when (and how) to put the UI functionality into the control or onto the