Things I love
Oct. 18th, 2005 01:00 am10:25 PM: I think to myself, "I should get to bed soon."
10:30 PM: I start preparing to go to bed.
10:33 PM: My supervisor sends me an email: "There's a problem with the website that needs to be fixed now."
1:00 AM: I finish working out the problem with the website.
The problem, if you're curious: Access is a pansy-ass application that can't handle my webpage asking for more than 255 fields in one query. Either that or it's Microsoft ODBC. I don't run the back-end on this server, so I can't tell.
The solution: break the 255+-field query up into chunks.
The hard part: I have to assign a different name to each query, so everything that was cheerfully looking for getData now has to look for getData or getData2 or getData3 or getData4, depending on what chunk of fields they're looking for. And since this is dynamic - I don't know before the page loads how many fields the user is going to want (it's dependent on date - the later the date, the more fields get pulled, which is why this is only coming up now, three months after I wrote the page in the first place) that means that sometimes things are only going to be looking for getData, and sometimes things are going to be looking for all four queries, and sometimes it's in between.
So, yeah.
I think maybe I'll try and get some sleep, and ignore that my alarm is set for 6:30. I really wish I weren't such a presentee; I could get away with missing classes tomorrow if I absolutely had to, but I would feel awful about it for the rest of the week, so it's probably not worth it.
10:30 PM: I start preparing to go to bed.
10:33 PM: My supervisor sends me an email: "There's a problem with the website that needs to be fixed now."
1:00 AM: I finish working out the problem with the website.
The problem, if you're curious: Access is a pansy-ass application that can't handle my webpage asking for more than 255 fields in one query. Either that or it's Microsoft ODBC. I don't run the back-end on this server, so I can't tell.
The solution: break the 255+-field query up into chunks.
The hard part: I have to assign a different name to each query, so everything that was cheerfully looking for getData now has to look for getData or getData2 or getData3 or getData4, depending on what chunk of fields they're looking for. And since this is dynamic - I don't know before the page loads how many fields the user is going to want (it's dependent on date - the later the date, the more fields get pulled, which is why this is only coming up now, three months after I wrote the page in the first place) that means that sometimes things are only going to be looking for getData, and sometimes things are going to be looking for all four queries, and sometimes it's in between.
So, yeah.
I think maybe I'll try and get some sleep, and ignore that my alarm is set for 6:30. I really wish I weren't such a presentee; I could get away with missing classes tomorrow if I absolutely had to, but I would feel awful about it for the rest of the week, so it's probably not worth it.