Recent content by cpuphantom

Half way through describing all the code I figured it out. I'm an idiot. The error is not coming from the page directly, it is coming from a custom error page I just created that references a SSI file that references the "translate" function but doesn't include the "start" file the function...

It's hard to post all of the code since it's so massive and on so many different pages. But that's the thing... the code is an exactly copy/paste from my other server which works perfectly. I was hoping something might ring a bell about some new-fangled security thing I have to turn off in...

Hello, I need some help on this one. I've migrated an application from Win2k/IIS 5 to Win2003/IIS 6. The code hasn't changed. I have a function that I use often throughout my application that I include into each file with <!--#include file="start.asp"--> When I open the app, the home...

wait... I spoke too soon. You're still a genius... but my script was bad. It was giving me one row per week... but the sum was for everyone in the DB... not the specific group I wanted. This worked much better... though I have a week that went bad for some reason... select...

You sir, are a genius. :) I didn't separate the views since actually all of those things such as the dates and id list are dynamic... but took your idea and combined them like so: select (select sum(b.billings) from tbNumbers as b where b.datestamp between dateadd(d, -6, a.datestamp) and...

Hello! Here is what I have: select (select sum(b.billings) from tbNumbers as b where b.datestamp between dateadd(d, -6, a.datestamp) and a.datestamp and b.user_id = a.user_id) as metric_week, a.datestamp from tbNumbers as A where a.user_id in (64, 152, 72, 118, 95) and a.datestamp...

Hey, thanks for the update on the MSDE 2000 and SQL Express. I will look for them.

Thanks... I saw that. But I couldn't use it. My boss is too fricken cheap to want to upgrade past SQL 7. And SQL 7 doesn't support Functions. I guess I should have mentioned the version in my first post. So can this only be done with a custom function? I guess so...

Hello All, I need some help. I've done a few Google Searches, and searched this forum but am not seeing a good answer. Here is what I am trying to do. It's actually kind of simple. I am trying to get a list of user id's from users (stored in tbMembers) that belong to an office group...

I'm trying to put together a single stored procedure that I can pass a number to. It will then return me the percentile that number was compared to a group, as well as the max, min, median, 75th percentile, and 25th percentile numbers from the group. I put together a nifty little script that...

Here is a challenging algorithm I need help with: I have a table called tbNumbers that stores billings values per user per office. Each record has a datestamp. Here is an example of some data from the table: id user_id office_id billing datestamp 1 15 1...

heh heh, you are right about the vendor not knowing computers. But here's what I know... according to what limited part of the MCSA I have studied so far, Window XP (at least) may actually require you to manually update the HAL in the Device Manager from ACPI Uniprocessor to ACPI...

Hello. I just purchased a new server with a single Xeon Processor with HyperThreading. HyperThreading came enabled from the vendor and Windows Server 2003 was pre-installed. The HAL is set as an ACPI Multiprocessor HAL. The software I'm installing on this server is a call processing...

Well, shucks. Thanks anyway... Now I need to go harrass the database vendor to add MAPI/Exchange compatibility to their application. :)

Not sure if this is possible, but it would be nice if it was. We currently use Exchange 2000 with Outlook XP as the client. But a database program we use in-house needs to be able to send/receive email using the POP/SMTP protocols. That part of it works fine... but would be awesome as hell...