devxlogo

The Latest

Accessing an Object From Another Process

On modern operating systems, a process consists of an executable file that the OS loads into the system’s memory and executes. A process normally has an entry point and one

Table Columns

Question: How do I drop a table column? Answer: To drop a column, use this syntax: ALTER TABLE Employees DROP COLUMN HomePhone Just remember that you can’t drop a column

Constructor for a Protected Class

Question: How do I create a constructor for a protected member of a class? I have declared the function in the header file but not defined the definition.The error message

Visual Basic Data Access, ADO, OLE/DB

Question: What are the differences between Provider=MSDASQL.1 and Provider=SQLOLEDB.1 in an “Open” “Select” statement? Also, what is the difference (if any) between “ADO” AND “OLE/DB”? And finally, in Visual Basic,

Deadlock Timeouts

Question: I have two questions: 1. How can I determine what the server’s lock mode currently is (e.g. WAIT, NO WAIT, etc.), without actually setting it at the same time?

Outer Joins in Where Clause

Question: What’s the syntax for outer joins in the where clause in Informix? Answer: The syntax is: SELECT c.customer_num, c.lname, c.company,c.phone, u.call_dtime, u.call_descrFROM customer c, OUTER cust_calls uWHERE c.customer_num =

Getting CGI Output

Question: Using C or C++ for CGI programs, is there a way to make a CGI program that calls another CGI program, and then takes the output of that called

uniqueidentifier vs. int

Question: If I have the option of using the uniqueidentifier or int data type for a primary key, will choosing the uniqueidentifier mean a significant performance degradation? Answer: The uniqueidentifier

GetBiosInfo – Retrieve information about the bios

Const HKEY_LOCAL_MACHINE = &H80000002′ Return information about the Bios (NT only)” Requires the GetRegistryValue routineSub GetBiosInfo(BiosDate As String, BiosVersion As String) ‘ These keys appear to exist only on NT

GetCpuInfo – Retrieve information about the CPU

Const HKEY_LOCAL_MACHINE = &H80000002′ Information about the CPU’ you can pass a number 1 to the last argument to retrieve’ information on all the processors in a multi-CPU system” Returns

NumberOfCPUs – The number of processors

Const HKEY_LOCAL_MACHINE = &H80000002′ Return the number of processors” Requires the CheckRegistryKey routineFunction GetNumberOfCPUs() As Integer Dim keyName As String ‘ loop on the subkeys of HKEY_LOCAL_MACHINEHardwareDescriptionSystem ‘ CentralProcessor ‘

Avoid Double Quotes Inside Quoted Strings

Avoid putting double quotes inside of double quotes in your HTML code. You may not get a compiler error, but your script just won’t work. Instead, substitute single quotes for

Pass Variables From Page to Page

We can pass variables from page to page with the following script: This snippet of ASP script will also automatically create hidden fields that will be dumped into all following

Nest Frames Within Frames

If you’re writing complex frame sets by hand, it’s easy to get lost in “spaghetti code.” To keep a handle on the situation, don’t build the entire frame set at

Determine Which Style Sheets to Use

There are some differences in Cascading Style Sheet implementation in Internet Explorer 3 and 4. So you may want to choose which set of style sheets to load for your

Identifying Browsers Using ASP

Using the BrowserType object, your ASP pages can detect the type of browser being used to download the page. In addition, you can also test the browser for specific capabilities.

Mouseover Effects for Links

The following code can be used in the tag of an HTML document for automatic mouseover effects on all links on the page. The styles ‘a’ and ‘a:visited’ are used