I have a function that tests to see if a time is within a range of two other times. I am using military time only showing as an integer. (800, 830, 900, 930, 1000 etc)The statement that tests the range is below:
If tsToTest >= tsStart AND tsToTest < tsEnd Then
tsToTest is the time being tested. It is military time from 8:00 AM to 8:00 PM and is being fed by a manually populated array. The array is multidimensional, it has 3 columns and 25 rows. The two additional columns are being used in table cells to define the time. (8:00 - 8:30) The test statement is followed by a select statement to see if the "reservation" is approved.
tsStart AND tsEnd are only available in the database. I used getrows to retrieve them but when I loop through with the second array my table is duplicated when there is two records and I am assuming tripled if there were three.
Is it posible to manually populate some of the columns in an array and pull three other columns from a database? And to make this tougher, the three columns from the db could be empty or have any number of records.
I have tried using getrows around where I call the function but I get the same result.
Any help or ideas would be appreciated!
If tsToTest >= tsStart AND tsToTest < tsEnd Then
tsToTest is the time being tested. It is military time from 8:00 AM to 8:00 PM and is being fed by a manually populated array. The array is multidimensional, it has 3 columns and 25 rows. The two additional columns are being used in table cells to define the time. (8:00 - 8:30) The test statement is followed by a select statement to see if the "reservation" is approved.
tsStart AND tsEnd are only available in the database. I used getrows to retrieve them but when I loop through with the second array my table is duplicated when there is two records and I am assuming tripled if there were three.
Is it posible to manually populate some of the columns in an array and pull three other columns from a database? And to make this tougher, the three columns from the db could be empty or have any number of records.
I have tried using getrows around where I call the function but I get the same result.
Any help or ideas would be appreciated!