Automatic Private IP Addressing (APIPA)
Automatic Private IP Addressing (APIPA), is a feature of Windows (except Windows NT) operating systems. With APIPA, DHCP clients can automatically self-configure their IP configuration with an IP address and …
How does DNS Work?
DNS stands for Domain Name System. DNS is used for name resolution on a TCP/IP network. Before you can understand what DNS is and where it came from, you have …
OSI: Layer 3 – Network
The network layer is the third layer (layer 3) of the seven-layer OSI model. The network layer is directly above the data link layer and is concerned with getting data …
ASP.NET Web Server Controls
ASP.NET Web server controls are ASP.NET specific objects or tags understood by the ASP.NET engine running in IIS. Like HTML server controls, web server controls are also processed server-side by …
ADO Querying a Database
In most cases, if you are running a web application that includes server-side scripting such as ASP, you are most likely providing dynamic content to your visitors by accepting input …
ADO Capturing Errors
Troubleshooting errors within your ASP web application can be challenging sometimes. When working with ADO, the Error object can be used since it contains details about data access errors that …
ASP Special Characters
All programming languages have special and/or reserved characters that are used for specific purposes. ASP is no different. In this tutorial, we will cover the most common special characters that …
ASP Looping Statements
As with most programming languages, ASP allows (through VBScript) for several types of repetitive operations, also commonly known as loops. Loops are used to repeat the same group of statements …
SQL Cursors
Transact-SQL cursors are used mainly in stored procedures, triggers, and Transact-SQL scripts. Cursors make the contents of a result set available to other Transact-SQL statements. The typical process for using …
MySQL CURTIME Function
The MySQL CURTIME function is used to display the current time. The equivalent function in Microsoft SQL Server is GETDATE, but would require formatting with the CONVERT function. Syntax Example …
SQL GETDATE Function
The SQL GETDATE function is used to get the current date and time. This function is used when querying a Microsoft SQL Server. For MySQL Server, you can use the …
SQL LEN Function
The LEN function returns the length of the value in a text field. Employees Table employeeID employeeName age 1000 John Smith 40 1001 Fred White 27 1002 Jane Scott 53 …