I added what is below to my web.config file: <httpModules> <add name=”MagicAjax” type=”MagicAjax.MagicAjaxModule, MagicAjax”/> <add name=”ScriptModule” type=”Microsoft.Web.Services.ScriptModule”/> </httpModules> And I got: Could not load file or assembly ‘MagicAjax’ or one of its dependencies. The system cannot find the file specified. (C:\Inetpub\wwwroot\TheTracker\web.config line 48) The solution I found that worked was adding the MagicAjax assembly to […]
SELECT CONVERT(VARCHAR(8), GETDATE()-365, 112) This is a way to query and get the date in the following format: YYYYMMDD I came across some dates saved in the database in this format as a varchar and had to use this to initially get the date and then convert it from and integer to varchar.
View Standard Date Formats
Error: Back up the transaction log for the database to free up some log space. To recover from a full transaction log If the log is 100% full you cannot truncate it by backing it up, since the backup has to be recorded in the transaction log. For version 6.5, use: DUMP TRANSACTION dbName WITH […]
Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or SQL Server 2005 Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.
Console Applications are command-line oriented applications that allow us to read characters from the console, write characters to the console and are executed in the DOS version. Console Applications are written in code and are supported by the System.Console namespace. (Source) Hello World – Console Application
The Try word means “Try to execute this code”. The Catch word means “Catch any errors here”. The ex is a variable, and the type of variable it is an Exception object. Example Public Function Delete(ByVal fileName As String) As Boolean Try File.Delete(String.Format(“{0}\{1}”, ConfigurationManager.AppSettings(“ImageDirectory”), fileName)) Return True Catch ex As Exception Return False End Try […]
The em dash (—) is used to indicate a sudden break in thought. The en dash (–) is used to indicate a range of just about anything with numbers, including dates, numbers, game scores, and pages in any sort of document.