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 jsiimml

  1. jsiimml

    DateDiff Problem

    Problem solved, I googled my question and come up with: vblNextDrawMinutes = DateDiff("n", Now(), vblDrawsArray(1,0)) vblNextDrawHours = vblNextDrawMinutes \ 60 ' note the \ returns an integer when it divides vblNextDrawDays = vblNextDrawHours \ 24 vblNextDrawHours = vblNextDrawHours -...
  2. jsiimml

    DateDiff Problem

    Hi, I have a lottery script on my forum and I need to work out the next draw date based on todays date and the datetime field stored inthe database. So far I've got: vblNextDrawDays = DateDiff("d", Now(), vblDrawsArray(1,0)) vblNextDrawHours = DateDiff("h", Now(), vblDrawsArray(1,0))...
  3. jsiimml

    Beginner Question

    Hi, I've been using asp for the last few years to do some sites and thought it was about time for an upgrade. I'm fine with the idea behind the event handlers and using the page_load handler. I've been doing specific if statements within the handler to change values in label fields but now I...
  4. jsiimml

    Regular Expression (return text between body tag)

    Hi, I want to create a regular expression which will return the content within the <body> tags of a string. I have retrieved the string but I can't get the regular expression to work. I've tried: Set objRegExp = New RegExp objRegExp.IgnoreCase = True objRegExp.Global = True...
  5. jsiimml

    Run sql script

    Hi, I have a file with a series of sql statements, eg -- truncate tables truncate table test truncate table test2 etc To tidy up my database for testing purposes. I was wondering how I can read the file in (tidydb.sql) and run it line by line (ignoring comments and blank lines). Appreciate...
  6. jsiimml

    Logic Problem

    Yeah I think i'm going to go back and make the changes while I have the chance. Cheers for your feedback. The Recursion Tree is starting to grow on me. If I store the categories in an array then I will only need one query. Itshim could you share how you've done it so that I can use it for...
  7. jsiimml

    Logic Problem

    Just read the tutorial, and really looking to optimize so the first method would not be the preferred method. As for the second method it seems abit fiddly for what it is. The problem is that I have done all the backend bits getting the database navigation to work how I explained above. I...
  8. jsiimml

    Logic Problem

    The reason you are displaying 4 and 7 is a way of getting to the upper categories or the navigation would not work. Will take a read of that tutorial abit later so will report back on which method i prefer. Cheers
  9. jsiimml

    Number registered for a month

    Genius worked a treat. Thanks
  10. jsiimml

    Number registered for a month

    Hi, I have a customers table with the following structure: - id (auto number) - datecreated (date/time) I wish to return the the number of people who have registered for the current month and previous 3 months. Appreciate the help. Thanks
See more

Part and Inventory Search

Back
Top