When designing an internet application that must provide results in a grid, many developers will use small (1 pixel by 1 pixel) images in order to create a grid effect

Populate a flexgrid control with specified columns and filtered rows by drawing the control and calling this routine: Dim strWhere As StringstrWhere = ” WHERE PeopleAddressesID=4502″Call PopulateFlexGrid(Me.MSFGrid, “tblPeopleAddresses”, strWhere,”PeopleAddressesID”, “BuildingName”,

During development, it is often necessary to have blocks of code for debugpurposes. If the debug code is lengthy, commenting anduncommenting it can be tedious. But if you put either

This is a very simple but time-saving and powerful tip to build a dynamicSQL query (in SQL Server 7.0) that updates a particular column value present in all tables. And

Question: I have some complex engine control software that has to run under MS-DOS 6.2, but it needs to transfer data to SQL Server 7. What’s the best way to

Question: I have a table that stores test answers. It looks something like this: Student Date_taken Q1 Q2 Q3 … Q78 If each question (Q%) is true/false (ENUM(”,’T’,’F’)), how do

Question: I tried a DTS export of a table to an Excel file. The data types of all the columns in the table are varchar. When it exports to the

If you have a recordset already created and want to filter it by some criteria, you can use the Filter property of the recordset to do it. Just change the

You can use the dot operator (.) in XSL transformation stylesheets to refer to, effectively, “whatever element was just identified.” Let’s say you had this template in a stylesheet: Say

If you’re getting a bunch of data for an ASP page, you can retrieve all the data through a single stored procedure and through a single call. Here’s what your

Moving your ASP code to compiled components is always a good idea. Compiled components enable fast execution, along with easy development, debugging, and testing. For example, creating a record set

Question: Is it possible to display the address of the previous Web site as a string so that I can use it elsewhere? Answer: If the user got to your

Question: I have noticed that all rounding to x decimals scripts uses the following format: tenToPower = Math.pow(10, nDecimals);newNumber = String((Math.round(nNumber * tenToPower) / tenToPower)); However, that doesn’t work with

Question: I have tried to reorganize Informix chunks on my disks. So I stopped the Informix and started to copy chunks to a new location with a cplv command (AIX).

You can use savepoints in rolling back portions of transactions to predefined locations. A T-SQL savepoint defines a location to which a transaction can return if part of the transaction

Programming with style sheets is never an easy task if you want to write browser-neutral HTML code. This is because the DOM (Document Object Model) of the Internet Explorer and

The LookupTable object is marked as ThreadingModel=Both and doesn

I have a bunch of files on the server that I wanted to be able to select, for example, to delete them or to give them special treatment. Thus, I

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