Monday, November 29, 2004
Extra Filled Wraps & Foxpro
Well it's been a while since I wrote. I've just been so incredibly busy lately. I'm getting ready to travel back to Victoria. This time I will be staying for an extended period of time. I'll be there for around 2 weeks.
I'll be driving out this Saturday. I'll be stopping in Vancouver for a couple of nights to stay with my good buddy from back home Heath Horejda. I haven't seen him since around Christmas 2 years ago so I'm pretty excited about staying with him. He's bar tending and playing the starving actor quite well. He has a new girlfriend Chelsea. I'm really looking forward to catching up and seeing the guy. He's one of "the boys", you never loose the ties, you know?
Anyways ... I had left him a message earlier this week, and he phoned me back while I was driving last night. I was on my way to grab something to eat and head home. I ended up stopping at the Mr. Sub right on 14th. It was almost closing time on Saturday. And I realized something about eating later than normal. When you go into Mr. Sub right before closing they'll really dish out the chicken for a Louisiana Chicken Wrap! I was shocked! Normally you get a tiny portion, but the guy was like ... it's closing time ... we'll probably throw it out anyways ... load him up. I was getting two wraps (because they are normally pretty small), and the girl looked at him kind of weird. He was like ... never mind, just make his wrap ... flicking his hand at her. I realized what was happening then ... I was getting the biggest king kong style chicken wraps to ever go down in Mr. Sub history! By the way ... they were SUPER DELICIOUS!
So I have 5 days to tie up all of the loose ends around here and get out to B.C. I pretty excited about going. It'll be some cool work. They are a windows shop, and I know I'm not going to convert them. They use Fox Pro in the back end of things. At least I'll be using PHP which is a bonus. If it was VFP with ASP and VB then I probably wouldn't be overly interested. I've been doing to VFP research (with what limited time I have), and it seems alright. It's not a full RDBMS like PostgreSQL would be, but they have the existing work in Fox Pro already. It would take a whole lot of effort, and work to port something into another DB model. I'm not really up for that today. Maybe someday I'll convince Chris of the OS world. ;-)
I've been researching ADODB somewhat. I don't know if it is currently what another developer out there is using or not, but it looks like the way to go. Apparently you have to Connect to VFP with the OLE DB, and not just ODBC, otherwise the stored procedures will not be accessible. Alright ... that seems pretty gay to me ... but I'm not concerned. The ADODB seems like a pretty good DB extraction layer. I prefer my own framework (because it includes much more than DB extraction), but I'll probably use a subset of my framework, and interact with ADODB. I mean ... it's not that hard to figure out the concept of
1. make a connection
2. execute commands
3. go through the results somehow
ADODB did have a cool feature which executed a command to retrieve one row (like I end up doing all the time e.g. you get an ID and you need other fields corresponding to that field). I thought that was cool, it's not hard to do long hand, but it would save about 5 lines of code every time I did that. Someday I'll come up with something better for myself ;-)
¶ 1:56:00 PM
I'll be driving out this Saturday. I'll be stopping in Vancouver for a couple of nights to stay with my good buddy from back home Heath Horejda. I haven't seen him since around Christmas 2 years ago so I'm pretty excited about staying with him. He's bar tending and playing the starving actor quite well. He has a new girlfriend Chelsea. I'm really looking forward to catching up and seeing the guy. He's one of "the boys", you never loose the ties, you know?
Anyways ... I had left him a message earlier this week, and he phoned me back while I was driving last night. I was on my way to grab something to eat and head home. I ended up stopping at the Mr. Sub right on 14th. It was almost closing time on Saturday. And I realized something about eating later than normal. When you go into Mr. Sub right before closing they'll really dish out the chicken for a Louisiana Chicken Wrap! I was shocked! Normally you get a tiny portion, but the guy was like ... it's closing time ... we'll probably throw it out anyways ... load him up. I was getting two wraps (because they are normally pretty small), and the girl looked at him kind of weird. He was like ... never mind, just make his wrap ... flicking his hand at her. I realized what was happening then ... I was getting the biggest king kong style chicken wraps to ever go down in Mr. Sub history! By the way ... they were SUPER DELICIOUS!
So I have 5 days to tie up all of the loose ends around here and get out to B.C. I pretty excited about going. It'll be some cool work. They are a windows shop, and I know I'm not going to convert them. They use Fox Pro in the back end of things. At least I'll be using PHP which is a bonus. If it was VFP with ASP and VB then I probably wouldn't be overly interested. I've been doing to VFP research (with what limited time I have), and it seems alright. It's not a full RDBMS like PostgreSQL would be, but they have the existing work in Fox Pro already. It would take a whole lot of effort, and work to port something into another DB model. I'm not really up for that today. Maybe someday I'll convince Chris of the OS world. ;-)
I've been researching ADODB somewhat. I don't know if it is currently what another developer out there is using or not, but it looks like the way to go. Apparently you have to Connect to VFP with the OLE DB, and not just ODBC, otherwise the stored procedures will not be accessible. Alright ... that seems pretty gay to me ... but I'm not concerned. The ADODB seems like a pretty good DB extraction layer. I prefer my own framework (because it includes much more than DB extraction), but I'll probably use a subset of my framework, and interact with ADODB. I mean ... it's not that hard to figure out the concept of
1. make a connection
2. execute commands
3. go through the results somehow
ADODB did have a cool feature which executed a command to retrieve one row (like I end up doing all the time e.g. you get an ID and you need other fields corresponding to that field). I thought that was cool, it's not hard to do long hand, but it would save about 5 lines of code every time I did that. Someday I'll come up with something better for myself ;-)
¶ 1:56:00 PM
