We’ve been hacked again.  I’m still not sure how as the last time we locked down all our pages and sql calls.  Or, at least, we thought we did.  Odd.  They managed to insert new entries into a table, and also append data to many entries in a table too.  The appended text is mostly [...]

I was getting this, oddly, suddenly from a function that had been working for months without a problem: Set xmlObj = Server.CreateObject("MSXML2.FreeThreadedDOMDocument") xmlObj.async = False xmlObj.setProperty "ServerHTTPRequest", True xmlObj.Load(url) Which I use to grab an XML feed. The error was thrown on the load line. After some searching, a few pages said that this was to do with character encoding issues.  On [...]

Getting this? You will get this is trying to do a ServerHTTPRequest with MSXML2.FreeThreadedDOMDocument, and the url is is one only found in your hosts file - try changing it for the IP address, or use an address anyone could find on the net.

This was curious for a while - in Firefox 3, some webpages were displaying little square boxes with 4 digits of hex in them, e.g. FFFD, instead of some character that would normally be there. Example for ‘»’ Solution: Check your encoding. The browser has selected UNICODE (UTF-8) and the page is not. (Menu / [...]

So, you’re suddenly getting this error? uncaught exception: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIDOMScreen.width]” nsresult: “0×80004005 (NS_ERROR_FAILURE)” Check your HTML does not have two elements with the same ID in it. It can cause this. Thanks to http://www.howtocreate.co.uk/emails/CraigStrickland.html for solving a brain-teaser!

I recently wrote a page to generate a video sitemap for Google, which is similar to the normal sitemap format: http://www.google.com/support/webmasters/bin/answer.py?answer=80472&ctx=sibling You then submit the sitemap here: https://www.google.com/webmasters/tools/sitemaps After a period of waiting, if you check back you’ll see if it was parsed correctly or not. You might get this, like I did: Error: Unsupported file format Your Sitemap does [...]

The new code to replace the ‘legacy’ goes like this: var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); var pageTracker = _gat._getTracker("UA-xxxxxx-1"); pageTracker._initData(); pageTracker._trackPageview(); Which generates, promptly, for me the following error: _gat is not defined var pageTracker = _gat._getTracker("UA-xxxxxx-1"); Both in FF and IE. My IE is raw, that is, no add-ons of [...]

A curious problem just cropped up on one of our sites. An allowance field (int) was negative in almost all records of a table. Different negative numbers, but many the same, like -32, -16, etc. Some head scratching later revealed a bit of SQL like this: ' Reduce allowance sql = "UPDATE myTable SET allowance = [...]

What’s the easiest way to select items from X that are NOT present in Y? e.g. In X we have ID, Name [1, Bob; 2, Rita; 3, Sue] In Y we have ID, Name [2, Rita] So we want a result set of [Bob; Sue] My solution is: SELECT X.ID, Y.Name FROM X WHERE X.Name NOT IN ( SELECT Y.Name FROM Y WHERE Y.Name [...]

If you parse an RSS feed (see http://www.ralphcapper.eu/2007/classic-asp-xml-feed-reader/) you may miss essential values that are set as attributes of a node, rather than an entity you can access with xmlItem.childNodes. <item> <title>Helo World</title> <hello:content foo="bar" url="http://myurl"></hello:content> </item> One solution is to loop through each item like so: For Each xmlItem In xmlList For Each xmlItem2 In xmlItem.childNodes if xmlItem2.nodeName = "hello:content" then For Each [...]