Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bevan

  1. bevan

    Slow delete query

    Thanks everyone for the advice. I will do some more tests over the next couple of days and see if any of your ideas help. Bevan
  2. bevan

    Slow delete 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...
  3. bevan

    Outlook Calendar Export

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

    Sort a table by clicking on Column Headings

    hi. Check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndude/html/dude07232001.asp This shows a way to do it using htc includes. An easier way is to use asp. Make the column headers into HREF's. Link to the same page and pass forward the sort order in the query...
  5. bevan

    weekly query

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

    asp vs php

    in php all strings have a dollar sign in front of them (and its all automatic!) so if the URL is passed forward in the querystring (something.php?url=www.myplace.com) then $url is already www.myplace.com Easy huh? Then to write it to the screen use echo <?php echo &quot;$url is a cool...
  7. bevan

    parameterized query

    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
    • bevan
    • Thread
    • Replies: 1
    • Forum: PHP
  8. bevan

    adding to current time

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

    Code for detecting if browser's back button was clicked

    hi, I dont think theres any way of capturing the back button click. I've never found a way to do it anyway (I'd LIKE to....) Bevan
  10. bevan

    Hi y'all.. Does anyone know how

    <body onSelectStart=&quot;return false&quot;> Is that what you mean?
  11. bevan

    Novell server

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

    Date query doesnt work

    Just to let you all know..... I have got this query to work now. I changed the query in access. Before it was quite a complex join so I made an intermediary query first and then joined two of them. Basically the problem was in the access query - NOT in the asp code. B
  13. bevan

    Date query doesnt work

    Time_stamp is the date and time that the record was entered into the database. It is set as a date/time field in Access. Basically all the query does is look for all the orders that were entered into the system in a certain time frame. B
  14. bevan

    Date query doesnt work

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

    set Focus on input area

    Thanks guys but your ideas didn't actually help. The code WILL select the text, but it won't let you write over it? Then you go to another area, go back again and NOW you can change the text. I want the user to just be able to put in the value as soon as they enter the screen. SO at the moment...
See more

Part and Inventory Search

Back
Top