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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bevan
  • Order by date
  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...
  16. bevan

    set Focus on input area

    HI, I have code to set focus on an input area (type=&quot;text&quot;) 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...
  17. bevan

    Message of the day

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

    98/ME home network

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

    Performance enhancing on big files

    Thanks guys, You answered my question fully! Now I just have to re-write some code... The don
  20. bevan

    Performance enhancing on big files

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

Part and Inventory Search

Back
Top