weblogs

matt goyer
midnight inferno
mayhaps
devil or angel
zeldman
succaland
joel
evhead
                         

[Previous entry: "Well"] [Main Index] [Next entry: "Update #2"]

06/10/2001 Entry: "update ... Friday"

It's been a little while. Friday I spent some time doing research for my new project for work. I've been calling it auto-phormation because we haven't really given it an official name. It's all going to be opensource stuff so I guess it doesn't matter if I explain the idea. Basically I creating a program which you'll be able to point at a database, and it will create an admin site using php/phormation that lets you view/edit/add/delete stuff from the database. I've got a general idea of what I need to do. I need to get the table names and field names/types for the database, and then write the php that will write the php/phormation for the admin site. It seems pretty straight forward but there aren't any SQL statements that get this information, so I need to figure out how to do this for different types of databases (MySQL, Postgress, Oracle, ODBC stuff). I found the functions that I need for MySQL and ODBC, and decided I'd try out the ODBC stuff because I have Access and ODBC all set up on my computer. But I kept running into weird cgi errors when I called the functions I wanted to use. I hacked at the code for a while trying to figure out where the error was occurring and I finally narrowed it down...but it makes no sense. I function call works fine a couple time, and then stops working. Maybe if I have time I'll put the code up here later. I hate it when I know how to code something, but then run into stupid problems. It's very frustrating. Oh well, at least on Friday night I was able to watch the Sixers vs. Lakers game on our one TV channel. Too bad the Sixers lost. They put up a good fight. (Note: I'm from Akron, PA a little over an hour from Philly, so the Sixers are my hometown team. Sorry Toronto :) In case I haven't told you already, we lost our cable a week or two ago, and now only get one channel. We were getting free cable since we moved in, and figured they just didn't care about turning it off. But now I think they gave it to us for a month hoping to get us hooked.