Yet another programmer blogging about code

Posts Tagged ‘xml’

Convert Microsoft Access .XSD file to SQL table create statement

Monday, August 20th, 2012

Here’s a quick-and-dirty XSLT script for transforming a Microsoft Access XML schema file into an SQL table create statement. Being quick and dirty, you need to edit the resulting statement, but it will get you most of the way there. (more…)

Filter invalid characters from XMLReader input files

Wednesday, August 15th, 2012

I just ran into a problem reading XML data exported from a Microsoft Access database. For whatever reason, Access has written VT (vertical tab) characters in the XML, which PHP’s XMLReader baulks at. To be able to handle that on each data load without requiring the user to edit their XML, I wrote a simple PHP stream filter that replaces each VT character with a LF (line feed). (more…)

Integrating Classic ASP with WordPress using AJAX

Sunday, July 15th, 2012

I’ve built a few websites now in WordPress with some custom data that had to be integrated into Classic ASP websites. Here’s how I did this using AJAX from VBScript. (more…)