JohnFx

JohnFx has asked 24 questions and find answers to 126 problems.

Stats

About

Product Manager, Development Manager. Software Developer. Texan.

You can follow me on twitter at: http://twitter.com/johnfx

I also have a blog at: http://improvingsoftware.com

JohnFx questions

Is there a Windows API to modify file type associations for an extension?
How can I determine if an AD group contains a given DirectoryEntry from another (trusted) domain?
How can I get a reference to the TFS WorkItem in a WorkItemChangedEvent?
Does SQL Server wrap Select...Insert Queries into an implicit transaction?
Is there a syntax to resolve ambiguity in CSS class names between two style sheets?
What is the point of Finalize and Dispose methods in .NET? (see details before answering)
Need some tSQL Wizardry: SQL Update Based on Running Total
How can I change the view of an MS Access subform at runtime in VBA code?
JQuery: How can I replace a tag without disturbing the content?
Do there exist any compilers with localized versions of programming languages?

JohnFx answers

Database Compacting and Archiving - MS Access Backend
SQL to select rows that match a URL with wildcard
How to extract a GUID from a Win32 DLL or OCX
MySQL - Query All users WITHOUT an appointment
Using VBScript how can I check if the Spooler service is started and if not start it?
SQL Functions and Recursion
how to generate a cookie in text file
Where/How are (My)SQL Databases Stored on Webservers?
Shell commands in VB
SQL database: how to create a database with data/values predefined