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 TouchToneTommy 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: jsiimml
  • Content: Threads
  • Order by date
  1. 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))...
  2. 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...
  3. 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...
  4. 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...
  5. 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

Part and Inventory Search

Back
Top