Paul’s answer isn’t wrong but it is not the only part to consider: You will need to go through each of these steps to make sure that you are getting consistent results; IMPORTANT: These steps have to be performed on each and every page in your web application or you will have problems (emphasized by … Read more
Try this: System.Configuration.ConfigurationFileMap fileMap = new ConfigurationFileMap(strConfigPath); //Path to your config file System.Configuration.Configuration configuration = System.Configuration.ConfigurationManager.OpenMappedMachineConfiguration(fileMap);
Description Instead of using a split, I think it would be easier to simply execute a match and process all the found matches. This expression will: divide your sample text on the comma delimits will process empty values will ignore double quoted commas, providing double quotes are not nested trims the delimiting comma from the … Read more
FOR XML PATH trick and article CLR User defined aggregate for sql server prior version 2005 – temporary tables An example of #1 DECLARE @t TABLE (EmpId INT, EmpName VARCHAR(100)) INSERT @t VALUES (1, ‘Mary’),(1, ‘John’),(1, ‘Sam’),(2, ‘Alaina’),(2, ‘Edward’) SELECT distinct EmpId, ( SELECT EmpName+’,’ FROM @t t2 WHERE t2.EmpId = t1.EmpId FOR XML PATH(”) … Read more
The advice below relates to both Server.CreateObject and CreateObject use in vbscript jscript vba The Web Server sections are specific to asp-classic but still worth reading. What Causes This error? Server.CreateObject Failed is caused most commonly when Web Applications are moved from one Web Server to another without an understanding of external COM components that … Read more
Date formatting options are limited in Classic ASP by default, there is a function FormatDateTime() which can format your date is various ways based on the servers regional settings. For more control over date formatting though there are built in date time functions Year(date) – Returns a whole number representing the year. Passing Date() will … Read more
I have come to the same problem and fixed the same way as Alex K. So if “Send Errors To Browser” is not working set also this: Error Pages -> 500 -> Edit Feature Settings -> “Detailed Errors” Also note that if the content of the error page sent back is quite short and you’re … Read more