Using this tip, you can create a drop-down list, which is populated from a database, and include it in a Web (ASP) page. This will basically increase the performance via

Question: I am trying to upgrade a program from DAO to ADO that will take a flat file and create a new database, add the needed fields and then populate

Question: I am a SQL beginner and I am trying to write this query. I have a table with four columns: ID STATUS DESCRIPTION CURRDATE1 open Test1 6/1/001 open Test1

Question: These are the fields of my table: id, email, firstname, and lastname. There can be multiple records for a single email. I only want to group by email and

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