Travis Vandersypen
President
Travis Vandersypen is a Senior Software Developer at EPS Software Corporation, located in Houston, Texas.
He concentrates on consulting on and developing COM-based, distributed applications. He is an international author and speaker, co-author of the Fox Extension Classes, co-author of the Voodoo Web Controls, and 3-time Visual FoxPro Excellence Award Nominee.
He can be reached via email at: travis@eps-software.com.
Articles Authored
-
XML UpdateGrams in SQL Server
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2002 - January/February
The new XML features in SQL Server 2000 give the developer more power to implement distributed solutions.One of the newest features, XML UpdateGrams, allows the developer to handle the inserting, updating and deleting of records while getting around some of the limitations of URL queries and OPENXML. XML UpdateGrams perform their operations against an XML view, which is provided by an annotated XDR schema that contains the necessary information to map elements and attributes back to their corresponding tables and fields.
-
XPath Queries in SQL Server 2000
Last updated: Wednesday, December 8, 2021
Published in: CODE Magazine: 2001 - Issue 1
Imagine the potential of accessing your database without needing to know any specifics about how that data is stored.Imagine the possibility of allowing your DBA the freedom to change the database structure without affecting your software code. Impossible? Not with XPath Queries and XDR Schemas. Using these two methods, practically any developer can write a program to access data in SQL Server 2000, just by knowing the structure of the XML documents returned by the server.
-
Query XML from SQL Server 2000
Last updated: Friday, November 21, 2025
Published in: CODE Magazine: 2000 - Fall
In this article, Travis Vandersypen explains how Microsoft SQL Server 2000 introduces native XML support, allowing developers to query data directly in XML format using the `FOR XML` clause with options like AUTO, RAW, and EXPLICIT. He details the configuration steps for enabling XML support via IIS, demonstrates querying data through URL and Template queries, and shows how XSL stylesheets can transform XML output for various presentation needs. Vandersypen emphasizes that this built-in XML functionality simplifies data integration for distributed applications by eliminating the need for custom conversion routines, enabling developers to focus more on business logic.