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 Related Posts Baltimore port crisis ignites infrastructure concernsR Comes to the Enterprise with Microsoft R ServerAsus ROG Ally Z1 Extreme discounted

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

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