Search results for query: *

Hi, How can I check how long an exe has been running? Cheers Derek

Having a disagreement at the moment and hopefully someone can help. I have a database with 2 million records in a main table. The table has a clustered index on areaID, date, userID, typeid in this order. I have been told that i should change the order by swapping the the date and areaID as...

Hi, I'm using IIS6 and getting huge log files (500M) each day and I'd like to remove logging of images and some other folders. I've found this <code> set IISOBJ = GetObject("IIS://localhost/w3svc/1/root") IISOBJ.DontLog = 1 ' Do not log requests. set IIOBJ = nothing </code> I'm not sure...

Hi, Im try to create a cascade of information using plus and minus images. intImage = 2; function swapImage(name, src) { switch (intImage) { case 1: document.images[name].src = "images/plus.gif" intImage = 2 return(false); case 2: document.images[name].src =...

HI, Is is possible to call a DTS package from a stored procedure?? Cheers Moley

I'm stuck with my sp. I'm trying to get a recordset containing assessment, staff, team, score, ave score, team ave score. I'm stuck on the ave scores SELECT Score, TeamID, staffID, (??) AS AveScore, (??) as TeamAveScore FROM tblAssessment GROUP BY TeamID, Score, staffID ORDER BY TeamID I...

Hi, The mde front end opens loading a form, which is the main menu screen. This also triggers a few queries. Just recently users are reporting that when they open the mde file they get the database table view. So either Access is failing or someones hacking. Can anyone shed some light on how...

Hi, The mde file opens by loading a form, which is the main menu screen. This also triggers a few queries. Just recently users are reporting that when they open the mde file they get the database view. So either Access is failing or someones hacking. Can anyone shed some light on how a user...

My code requires two loops, the first is looping through timebands (which is OK) the second moving the @startdate+1 until @enddate This is the first loop, I've been trying to add a second (@startdate) loop without success (using WHILE @startdate<= @enddate) my code.... set @timeband =...

I'm trying to manipulate some data into a table. the results of the query are date 9:00 10:00 11:00 12:00 1/09/03 0 2 7 4 2/09/03 1 5 9 15 and I neesd to insert into date timeslot Value 1/09/03 9:00 0 1/09/03 10:00 2 1/09/03...

I'm trying to format txttime using Cdate(Request.Form (&quot;txtTime&quot;)) the input into txtTime is '0800' but this returns 0 when formatted. can any one help? Moley

I have two record sets being returned as below 1) date code 0-1 1-2 3-4 1/1/03 90 2 9 5 2) available 12 how can i add the second to the first as below???? date code 0-1 1-2 3-4 available 1/1/03 90 2 9 5 12 thanks

Anyone, I'm trying to search my database using the first part of the postcode to return records in an sp. The problem is when i put eh6, i get all eh6 plus eh61, eh64, etc. And when i use just eh I get no recods at all. I cant really use left due to the fact that some postcodes are only two...

Anyone, I'm trying to search my database using the first part of the postcode to return records. The problem is when i put eh6, i get all eh6 plus eh61, eh64, etc. And when i use just eh I get no recods at all. I cant really use left due to the fact that some postcodes are only two characters...

Anyone, I'm trying to call a function when a buttons clicked. Heres the code <% function Accesslevel() 'function to stop access to level1 users If HasAccess = 0 Then alert(&quot; You do not have access to this part of the system.&quot;) return false else return true end if end...

Anyone, I've just swapped a site over to another win2000 server. The site has loads of forms some of which were done using FP components. With a handful of the forms I get the following error 'Cannot run the FrontPage Server Extensions' Smart HTML interpreter on this non-HTML page' the forms...

can any help. i have a disk with an excel file on which i can not open. i've tried copying using dos, explorer, etc but i get 'data error (cyclic redundancy check)' error. Can any one help me rescue this file????????

Anyone??? I taken over an ASP/sql7 database system. Problem is the server has to be reset once a week cause it runs out of virtual memory. I have been told that this is due to memory leakage from the asp connections. Is there any way to monitor the connections to the database or check each...

Anyone??? I taken over an ASP/sql database system. Problem is the server has to be reset once a week cause it runs out of virtual memory. I have been told that this is due to memory leakage from the asp connections. Is there any way to monitor the connections to the database or check each page...