My chat with Brandon was short, but very productive. (I wasn't able to check before sending off the tarball, but I think it's OK.) It turns out I didn't have one of the plugins I needed, and he also found some basic syntax errors for me. He showed me how to check a plugin version, and I went and found out how to install the plugin I needed. I seem to have DBIx working now.

It would be good to upgrade some of my plugins, but I can't seem to get that to work. I use the "r" command in cpan to list what needs reinstalling, and then I install one of the modules listed, but it remains listed at the same (old) version in the list. I tried for a long time to fix this, but I'm just going to have to ask Nate to help me when he gets back. I did, however, upgrade the version of CPAN.

My next task on this project is to translate the existing SQL code into something that uses the DBIx stuff. I'm partway there. That is, I translated it as best I could, commented out some of the nastier stuff (to be figured out later), and it compiles, and the page even renders. It doesn't actually work, though. It would be really helpful if I could see the SQL code being generated for me. There should be a simple way to do that. Of course, I can't find it. I do get an error that tells me what part of my SQL statement doesn't work, but it'd be better if I could see the whole statement.

To do:

• Test the equipment we received, look at inventory issues (no need to relocate just yet)
• Find out how to view the generated SQL code - ask Brandon?
• Get my DBIx version of Nate's SQL code to work
• Get the advanced features to work
  
• Edit it to look less like rearranged SQL and more like it takes advantage of DBIx?
• Post the solution to my database thread question, for future newbs
• See jun19 doc
• Keep master todo list up to date