Question: With XSL, can I change the value of global parameters inside the templates named temp? Answer: No. Parameters and variables in XSLT, once defined, essentially are fixed for a

Question: What does the ‘* 1’ mean in this constant declaration? Public Const gcsDelimiter As String * 1 = “|” Answer: The * in your example defines the size of

Oracle 8I gives developers a new feature to allow execution of native dynamic SQL. This is an alternative to the DBMS_SQL package previously required. Now developers can use dynamic SQL

The sp_who internal procedure allows users to view current activity on the database. This command provides a view into several system tables (e.g., syslocks, sysprocesses, etc.). The sp_who command returns

Question: Can I use computed values from a select list in a WHERE clause? For example: select age + 10 as AGE_10 from employee where AGE_10 > 50 Answer: This

Question: The table I am using stores date values as strings due to conversion data. The format is 2000-07-01 for July 1, 2000. I need to be able to age

Question: I am writing a SQL statement in Access that is a union query. I am getting an error saying “The number of columns in the two selected tables or

Question: How do I delete a column, and all the values in it? Truncating will delete only the values, not the column itself. And I don’t want to drop the

Question: I need a container of different objects. I have made all derived classes of the same base class and pushed them onto the container. The problem then arises in

Question: What is the SQL command for retrieving the current date? Answer: The GETDATE() function returns the current date and time. Write it like this: SELECT GETDATE() AS CurrentDateCurrentDate —————————

I’ve been trying to find a way to assign helpstrings for Enums in Visual Basic. The Class builder utility does that only for methods, events, and properties, but not for

This is something that expert VB developers know very well, yet every know and then an otherwise perfect VB app stops with a fatal overflow error because of Integer overflow.

Unlike other languages – such as C and Delphi – VB lacks of the capability to increment and decrement a variable. Adding this feature, in the form of reusable Function

‘ Comb Sort an array of any type” CombSort is faster than all but QuickSort and close to it.’ On the other hand, the code is much simpler than QuickSort’

Type SAFEARRAYBOUND cElements As Long ‘ # of elements in the array dimension lLbound As Long ‘ lower bounds of the array dimensionEnd TypeType SAFEARRAY cDims As Integer ‘ Count

Option Explicit’ Class Name : BTree’ Author : John Holfelder’ Date : 17-Apr-2000 12:08 pm’ Description : This class is a way of creating Binary search’ trees. Instead of pointers

Suppose you create a vector and fill it with elements: vector MyVector;MyVector.reserve(20);for (int i=0 ; i tmp(MyVector);MyVector.swap(tmp); The vector temp has the same number of elements that MyVector has. By

One of the common sources for bugs and security risks is using a fixed size char array as a buffer for inputting data. For example: char buff[20];cout > buff; //

The standard C library declares the function calloc() in as follows: void *calloc(size_t elements, size_t sz); calloc() allocates space for an array of elements, each of which occupies sz bytes

Certain STL containers and algorithms require that you overload operator < for the class type they store as elements in order to sort and compare these elements. Note that STL

Suppose you need to fill a container with pointers to objects instead of actual objects. Usually, you do this when you want to store objects of different types in the

Unix systems keep dates in a single number format that represents the numberof seconds past January 1, 1970. January 1, 1970 is considered the EPOC and is the date that

We know that using Hashtable we can put and get the java objects relatively fast. But Hashtable does not maintain the order in which you add and retrieve the objects.

Question: How do I format my numbers in the format ######, where a number of 123 would display as 000123? Answer: Concatenate a string of zeros to the left of

Question: How do I change the size limits of messages in a mailbox? Answer: You can’t really set a limit on the individual messages already in a mailbox, but you

Question: How do I define a new line character in ASP? Answer: In ASP (VBScript), use the constant vbCrLF to add line breaks in your string variables: strString = “Hello”

Question: Can I make a COM component in VB return a query result in the form of a recordset to the calling ASP Script? Answer: Yes, a COM component can

Question: How do I send data from a form in an ASP page to a database table in SQL Server 7.0? Answer: Obtain the data from the ASP page’s Forms

Question: Can I use Outlook 98 to read my hotmail messages like I can with Outlook Express? Answer: Not like you do with Outlook Express, no. With Outlook 2000, you