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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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 -...- jsiimml
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
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))...- jsiimml
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- jsiimml
- Thread
- Replies: 2
- Forum: Microsoft: ASP.NET
-
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...- jsiimml
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- jsiimml
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
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... -
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... -
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 -
Number registered for a month
Genius worked a treat. Thanks- jsiimml
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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- jsiimml
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
