Search results for query: *

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...

dude, you are seriously a genius. Thank you so much for your help. That looks exactly like what I was looking for. You just helped me out a lot.

Hello, I am attempting to program a pretty challenging Stored Procedure in SQL 7. I thought I'd put it up on here because you all might think of something I have not. Here's what I'm trying to do. I am trying to do a real time desk count for users in an office for a reporting time period...

Well... rebooting the server works for me. But the cause is something corrupting in the DNS servers on AD after a period of time... If your reboot dosn't work... you may have to look at it closer to find a bigger problem.

Never mind, folks. I got it worked out. It was related to a DNS issue I'm having. Thanks anyway.

I have a strange problem I'm hoping someone can help me with. I run 2 Windows 2000 servers, one with Exchange 2000. On both I have them set up as DNS servers. Well, every now and then... with increasing frequency the DNS starts throwing errors that certain records cannot be found. It...