admin – Page 15 – WebCheatSheet

ASP

ADO and ADO.NET Connection Strings

Last updated: August 26, 2026. Classic ASP uses ADO connection strings. ASP.NET applications normally use ADO.NET providers. The keywords differ,…

ASP

Last updated: August 26, 2026. Classic ASP connects to databases through ADO. Keep the connection string in protected server configuration,…

ASP

Last updated: August 26, 2026. Classic ASP can open an Access database through ADO using the ACE OLE DB provider.…

ASP

Last updated: August 26, 2026. Classic ASP can connect to Oracle through ADO using an Oracle OLE DB provider or…

ASP

Last updated: August 25, 2026. Classic ASP applications normally connect to SQL Server through ADO. Use a supported SQL Server…

ASP

Last updated: August 26, 2026. ADO can connect to MySQL through Connector/ODBC using a system DSN or a DSN-less connection…

PHP

Pretty often you need to run a couple of queries against your MySQL database on the client’s web server. Usually…

PHP

Many web developers consider PHP a second-class language. The truth is, as DHH puts it: “You can build the best…

Last updated: August 26, 2026. The SQL LIKE condition matches text using wildcard patterns. A percent sign matches zero or…

Select lets you use the Distinct keyword to eliminate duplicate rows from the query results. Distinct is very useful in queries where…