MECTILE

Mindblown: a blog about philosophy.

  • Simple Ping function VBScript

    I was after a ping function that met the following constraints; Didn’t use GetObject. Didn’t display any command (cmd) prompt. Didn’t use a temporary file. Here is what I found; I was looking at a way to timeout the above ping function after 1 second using threading, but this didn’t quite make it so simple.…

  • Decimal to Binary functions in Visual Basic

    Here are functions to perform decimal to/from binary conversion. CBin – converts a decimal integer to binary string. CDeci – converts a binary string to decimal integer. CBinS16 – converts a decimal signed integer to 16 bit binary string. CdecS16 – converts a 16 bit binary string to decimal signed integer.

  • SQL Server Quickest way to Insert Multiple Rows with VB

    Having to parse huge amounts of data from xml files to an SQL Server database, I needed to greatly optimise my code. Here are some tests to insert 10000 rows into table TABLETESTER. First, using the standard INSERT INTO without specifying column names. TickCount of 70547. Specifying the column names is actually marginally faster. TickCount…

  • Visual Basic 6 – quickest way to find first/last character in string

    When you are parsing large amounts of data, the way you code string matching can make a huge difference. In one case I needed to find if a string was contained within quotes, here are the test results from quickest to slowest. The test situation was to find if the last character in the string…

  • Base64/sexatrigesimal encoding/decoding in VBA/VB6/Visual Basic

    Here is an implementation of Base 36 enconding/decoding functions is VB6.

  • eventquery.vbs – ERROR: Unable to execute the query for the…

    If you received this error when trying to execute eventquery.vbs the cause is an overflow of events past 32,767 (the maximum capacity of a VB6 Integer). There is a very simple fix for this which is to change the data type from an Integer to a Long (which has a maximum capacity of 2,147,483,647). In…

  • List of Foundation Fieldbus Unit Enumerations

    Here’s a current list of Foundation Fieldbus unit enumerations extracted from the freely available DD files. foundation-fieldbus-list-of-unit-enumerations.txt

  • GoogleMap v1.5 – an inline Google map plugin for WordPress

    Recently updated and confirmed still working with WordPress 3.0. The following examples use the included example.xml file. Marker Z – no HTML, nonclickable. Marker 1 – standard maker with some text. Marker Default – no icon defaults to standard Google Maps marker. Marker $ – some symbols can even be displayed on a marker and…

  • How to Unlock Garmin maps

    For information only, How to Unlock Garmin maps. First get your hands on the desired Garmin City Navigator Downloadable Update for your country/city (MapSource A). In the compressed file should be the folders IMG, support and Windows plus a readme.txt. You will need a version of Garmin MapSource 6.13.1 or older which does NOT support…

  • WordPress Tool – a WordPress error and link extractor

    Here is a simple tool that might be useful to others, it does two main things; Parses your post’s content as XML and spits out any possible errors, and Extracts all external links, which can be exported as an Excel Tab delimited file. Post’s content errors Each post’s content is wrapped with XML dummy tags…

Got any book recommendations?

Get In Touch