Good bye, David

by Administrator Thursday, May 19, 2005 6:47 AM

David Kirk died yesterday - cancer took him at last. He did quite a bit of work with us in the past before he got sick, and Kathy and Denise counted him as a good friend.

I didn't know him quite as well, but I worked with some of his code. That may not seem much, but it always showed invention, clarity and attention to detail in an environment that doesn't particularly reward good behaviour seeing as it's completely hidden from the ordinary human being. I respect that.


Running multiple websites on XP Pro

by Administrator Monday, May 16, 2005 1:15 PM

IIS Admin is a beautifully simple tool to use when doing web-based developing on an XP workstation, and it makes my life bearable some days. It's a blessing to be able to create a directory structure for each client project that actually replicates their real-life site from the web root down. Nathan told me about it. Thank you Nathan Mayr, I'm naming my children after you. Yeah, all of them.

From the website: "IIS Admin is a small tool for for use on Windows XP Professional. As you may have noticed, Windows XP Professional's IIS installation only allows one running website at a time. This is where IIS admin enters the picture, it allows you to easily create multiple websites on Windows XP Professional and quick switching between them."

I like the very understated "as you may have noticed" bit. It's more like, "as you may have wept tears of bitter frustration into your keyboard such that the individual keys rusted shut."


Online ordering project - Lincoln Center Institute

by Administrator Monday, May 16, 2005 11:47 AM
Spring 2005: Andornot has recently upgraded our schools online ordering project for the Lincoln Center Institute in New York. Lincoln Center Institute (LCI) is an arts and education organization whose approach is based on aesthetic education and the writings of such innovators as John Dewey and Maxine Greene. The Institute works in partnership with pre-K through grade twelve educators and degree-granting teacher education programs, and provides numerous professional development opportunities.

LCI, a national leader in arts and education, has been a model for organizations across the nation and abroad. Since its inception it has served over 2.7 million students and some 50,000 educators.

In past years, when Spring came around, LCI would prepare and mail out a hard copy annotated catalog of resource materials to support the Institute's work in their Focus Schools and Teacher Education collaboratives. Resource co-ordinators at these schools would then have 2 months to place their orders for delivery by the time the new school year started in the Fall. LCI staff worked with emails, faxes, Excel spreadsheets etc. to manage the ordering process for multiple titles for 20 or so different schools within this tight timeframe.

In early 2004 Andornot designed an online ordering system using WebPublisher PRO to streamline and enhance this workflow. For the first time, school resource co-ordinators were able to log in to search a web based catalog for works on a specific repertory, or by format, audience level etc. and then place selections in their shopping cart. They were able to see at a glance the total amount of their order, how much they had left in their budget, and could add and remove items until they were satisfied with their selections. Once they submitted their order, their school colleagues were able to view items ordered, along with item order status, to plan their programs for the upcoming year. Open access to the catalog for the general public was simultaneously maintained. See

This year, 2005, Andornot was commissioned to further enhance the system. A wishlist feature has been added, allowing teachers and teaching artists to identify catalog items as desirable as they browse the catalog. The resource coordinator sees all wishlist requests with attached comments, and can immediately transfer the request to the school's order cart.

Behind the scenes, linked DB/TextWorks databases keep track of the catalog, schools, suppliers and of course the orders themselves. Purchase orders are emailed to vendors from within DB/TextWorks, and the status of the order is updated as each item is received and sent out to the schools. This information is then immediately available via the web interface for schools to track the status of their orders.

Also, of interest to developers, this year the entire project was upgraded to use the Andornot WebPublisher Results Control. The WebPublisher Results Control allows us to contain all HTML results generated by WebPublisher within a .NET environment, giving us programmatic control over content and behaviour of WebPublisher results before they leave the server, but without resorting to ODBC or SOAP so all native WebPublisher functionality is retained. For the LCI project, this meant all the original forms designed within the catalog database continued to be used, but we were now able to programmatically manipulate "add to cart" and "add to wishlist" features based on both record content and user login role, server-side. We thus were able to simultaneously increase the muscle power of the LCI application while reducing time-to-complete. The WebPublisher Results Control is part of the Andornot WebPublisher Developer Kit.

The schools online ordering project is one of two that Andornot has created for the Lincoln Center Institute. An interface to the Pforzheimer/LCI Catalog of the resource collection at the Heckscher Foundation Resource Center of the Lincoln Center Institute can be seen at

Contact Andornot for more information on our shopping/request carts, and the WebPublisher Developer Kit.

Andornot in Boston

by Administrator Tuesday, May 10, 2005 11:35 PM
Not much of a rant, nor a muse. We're all in Boston, attending Inmagic Dealer Days. Or more accurately, we're done attending dealer days and now are trying to relax even though the hotel bar closes way too early. Somehow I've not been able to sleep well, though that is normally NOT a problem for me. I could use a bucket of Visine.


Inmagic ODBC permissions when ASP.NET impersonates

by Peter Tyrrell Friday, May 06, 2005 1:38 PM

With ASP.NET set to impersonate a non-anonymous Windows account, I found the Inmagic ODBC driver flipped a henry when asked to perform a SELECT MAX statement. The error returned was "ERROR [S0000] [Inmagic, Inc.][DB/Text ODBC Driver]Unable to do ORDER BY".

It turns out that read/write permissions on the Documents and Settings\[machinename]\ASPNET\Local Settings\Temp folder are required (this is an XP machine I'm talking about). (Thank you Filemon.) I assume the ODBC driver requires some workspace in order to sort the records and pick the most maxest one. I don't know if this is the case with any ORDER BY clause or what. The ASPNET account has full control of that temp directory by default. Giving the Users group read/write access cured this otherwise intractable phenomenon (the Windows account in question was a member of the machine's Users group).

If you're wondering how to flip a henry, use your imagination.


Tags: Inmagic ODBC

Month List