From an MSDN blog post: http://blogs.msdn.com/mikhailarkhipov/archive/2005/06/24/432308.aspx Here is how to make ASP debugging work: Enable ASP debugging on the server. (I also added DEBUG verb to the asp extension, but I am not sure if it is required). Open classic ASP in VS 2005. Set breakpoint. View page in browser or run without debugging. Debug … Read more
(?:) creates a non-capturing group. It groups things together without creating a backreference. A backreference is a part you can refer to in the expression or a possible replacement (by saying \1 or $1 etc – depending on flavor). You can also extract them from a match afterwards when using regex in a programming language. … Read more
Try &HABCD, that’s how it works for most BASIC languages.
The conditional ternary operator doesn’t exist out of the box, but it’s pretty easy to create your own version in VBScript: Function IIf(bClause, sTrue, sFalse) If CBool(bClause) Then IIf = sTrue Else IIf = sFalse End If End Function You can then use this, as per your example: lunchLocation = IIf(dayOfTheWeek = “Tuesday”, “Fuddruckers”, “Food … Read more
Edit In hindsight, a better answer is to log to BOTH file system (first, immediately) and then to a centralized database (even if delayed). Most modern logging frameworks follow a publish-subscribe model (often called logging sources and sinks) which will allow multiple logging sinks (targets) to be defined. The rationale behind writing to file system … Read more
Why not use For Each? That way you don’t need to care what the LBound and UBound are. Dim x, y, z x = Array(1, 2, 3) For Each y In x z = DoSomethingWith(y) Next
You are setting the html of #showresults of whatever data is, and then replacing it with itself, which doesn’t make much sense ? I’m guessing you where really trying to find #showresults in the returned data, and then update the #showresults element in the DOM with the html from the one from the ajax call … Read more
There are two approaches, you can code in JScript or VBScript which do have the construct or you can fudge it in your code. Using JScript you’d use the following type of construct: <script language=”jscript” runat=”server”> try { tryStatements } catch(exception) { catchStatements } finally { finallyStatements } </script> In your ASP code you fudge … Read more
Just formatting it for readability will clarify a lot: set ansi_warnings off DECLARE @T VARCHAR(255), @C VARCHAR(255) DECLARE Table_Cursor CURSOR FOR select c.TABLE_NAME, c.COLUMN_NAME from INFORMATION_SCHEMA.columns c, INFORMATION_SCHEMA.tables t where c.DATA_TYPE in (‘nvarchar’,’varchar’,’ntext’,’text’) and c.CHARACTER_MAXIMUM_LENGTH > 30 and t.table_name = c.table_name and t.table_type=”BASE TABLE” OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T, @C WHILE(@@FETCH_STATUS=0) BEGIN … Read more
I know this is way late, but for anyone else who encounters this problem: If you are using a loop of some kind (in my case, a Do-While) to display the data, make sure that you are moving to the next record (in my case, a rs.MoveNext).