Search results for query: *

HI Everyone, I am running a big delete query through some code and it is TAKING AGES. It took about 20-30 seconds on a test database but when i tried it on our production database (that has to remain in use) it took about 4 hours. All up this query cycles through only about 400 records (the...

Hi. I want to be able to export my Outlook Calendar so that I can put it on the web allowing clients to see when I am free and when I am busy. If I could make this automatic using active server pages or similar then that would be great! Any ideas, comments? Thanks

Hi people. I am trying to set up in Excel a way for the spreadsheet to query a website on our intranet that basically gives a summary of the calls logged at our call centre... number added over the last week, number completed etc. I know I can get that data by using the spreadsheet as an...

I was wondering does anyone know if PHP supports parameterized queries? This is a function in asp.net that allows you to set the specific parameters for your query AFTER setting the query up. Is there something similar? Thanks

HI! I would like to know how to add to the current time. The following is some vbscript that I am trying to convert to javascript. Bascially when the user chooses the priority of a job it calls a function which will add either four hours or a day to the current time and put that as the time the...

Hi Do the commands Request.ServerVariables(LOGON_USER), Request.ServerVariables(REMOTE_USER), & Request.ServerVariables(AUTH_USER) work on a system runing off a novell server? Currently my asp is sitting on an NT server and I cannot see any issues with swapping it to a Novell server but someone...

Hi, I'm trying to write a pretty basic report with asp. The inputs are the ledger code (account code) and the start and finish dates of the report. For some reason it doesn't like my query. I used response.write to show it on screen. Next I tried copying the query into Access and it worked...

HI, I have code to set focus on an input area (type="text") or even to select the default text value...... BUt when it does automatically select the text value I can't write to it. I have to tab out of the field and then back in again to be able to write to it? Why does it select the...

Hi all, I want to read a random line of text onto the top of my page as a message of the day. I was hoping to just be able to store them in a .txt file or something simple like that, but if it has to be a db then that is no problem. Whenever a user goes to my page they will then get a new...

Hi. I have to PC's one running Win98 and one running WinME. both have working network cards (I know this because we have networked together when both were running Win98). We have tried to connect but to no avail. First trying a crossover cable and then trying with a hub after we had no luck...

Hi. I have an asp page that reads maintenance and other similar issues from an Access2000 db. Some of the data is small such as the name of the caller, room number, telephone, but there is also large amounts of information kept in memo fields, such as an explanation of the problem (sometimes a...

I want to join a user table (M list) to a payment table (pay) via the user ID. HOwever, Access wants to only display those users who DID make a payment and I want all users displayed even if they didn't make a payment. Current query is SELECT [M List].*, Pay.P_AMOUNT FROM [M List] INNER JOIN...