Question: I am trying to query a database with the following: SELECT DISTINCT SystemName, OwnerID, Location, Productver, StartDate, EndDate, ProjectNameFROM DevicesORDER BY SystemName I only want to have the DISTINCT

Question: I’ve heard that Nokia’s strategic aim is to make sure that every automobile on earth has its own e-mail address by 2010. Have you heard that too? Answer: I’ve

Question: Is it possible to have a grid bound to a cursor? If so please tell me how. Answer: A grid is bound to a cursor the same way that

Question: I have two tables Region(RegionId-PK, RegionName) and District(DistrictId-PK, DistrictName, RegionId-FK). When I open a recordset (rs) like : Dim rs as new ADODB.Recordsetrs.Open “SELECT District.*, Region.RegionName FROM District INNER

Question: How do you pass a parameter to a stored procedure from within another stored procedure? Answer: To call a stored procedure from inside another stored procedure, let’s take an

When using a select list that will allow multiple selections, the selections will be provided to you in the Request object as a comma-separated list. Using the new Split function,

If you’re doing a lot of development using server-side components, you’ll have found that once the DLL has been used by IIS, you have to reboot the Web services in

Question: How do I synchronize all NT 4 workstation system clocks on a network with a central point of contact? Answer: The NT 4.0 Server Resource Kit contains a file

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ read a byte from memoryFunction PeekB(ByVal address As Long) As Byte

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ read a value of any type from memoryFunction Peek(ByVal address As

‘ write a value of any type in memory” The value is written in the format of the value passed’ as the second argument, but you can overwrite it by

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ convert a BSTR into a VB StringFunction StringFromBSTR(ByVal pointer As Long)

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)Private Declare Function lstrlenA Lib “kernel32” (ByVal lpString As Long) As _

You can quickly evaluate the age of a person using the following function: Function Age(BirthDate As Date, Optional CurrentDate As Variant) As Integer If IsMissing(CurrentDate) Then CurrentDate = Now Age

‘ Evaluate the Easter date for a given yearFunction EasterDate(ByVal Year As Integer) As Date Dim G As Integer Dim C As Integer Dim H As Integer Dim i As

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal bytes As Long)’ write a byte into memorySub PokeB(ByVal address As Long, ByVal value

A global function may be declared inline. If you use the same function in different development environments, e.g., C and C++, you can hide the “inline” keyword from a C

When you need to compute the time that elapsed between two dates, use the standard function difftime(). This way, you avoid potential bugs such as leap years or Y2K issues.

The standard strstream family of classes enables you to convert numeric values into their string representation easily. You need to instantiate an strstream object, insert the numeric value to it

Linkage between C++ and non-C++ code fragments can be achieved using a linkage-specification. For example: extern “C” int func(int arg1); // func has C linkage The quoted string in the

In the following declaration of the template min, the template parameter T is passed by value: template bool equal(T first, T sec){//

The best way to tackle alignment/wrapping issues with invisible tables is tomake the tables visible. To do this, you should set the border property oftables that contain form fields or

Question: How do I make 1 bool take 1 bit instead of 1 byte? Answer: Instead of an array, you should use an STL container that is specifically designed to

Question: Is there any software that will convert database files from Informix to dbf files? Answer: I’m not aware of any. Sort of like rebuilding a Ferrari and putting in

Question: How do I put a named constraint on a social security number defined as number(9) so that no hyphens are allowed in? Answer: To prevent numbers with hyphens from

Question: Can I arrange the WML information on my server in one huge file and still have it delivered to a WAP device? Answer: The largest “deck” you can have

Question: Let’s say a WAP server has a WAP stack of the following layers: Connectionless WSP UDP IP Would you give me example packets that arrive at the server from

Question: Why does our Exchange server randomly slow way down once a day? Answer: There are a number of reasons why that could happen. I suspect you may find some

Question: Can you please name a few compilers that implement bool? Answer: Almost every C++ compiler nowadays supports bool. You don’t have to define or #include anything; bool is a