| Revision 615,
1.0 KB
checked in by liquan, 6 years ago
(diff) |
|
Modified results function to correct the search for provided enddate.
|
| Line | |
|---|
| 1 | SELECT * FROM closures WHERE closures.id = "T5AA"; |
|---|
| 2 | SELECT * FROM closures WHERE closures.id = "T55AB"; |
|---|
| 3 | |
|---|
| 4 | /* closureid + lognum */ |
|---|
| 5 | SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 1; |
|---|
| 6 | SELECT * FROM closures WHERE closureid = "T55AA" and lognum = 5; |
|---|
| 7 | |
|---|
| 8 | /* Route */ |
|---|
| 9 | SELECT * FROM closures WHERE route = 5; |
|---|
| 10 | SELECT * FROM closures WHERE route = 13; |
|---|
| 11 | |
|---|
| 12 | /* Route + direction */ |
|---|
| 13 | SELECT * FROM closures WHERE route = 5 and direction = "N"; |
|---|
| 14 | SELECT * FROM closures WHERE route = 5 and direction = "E"; |
|---|
| 15 | |
|---|
| 16 | /* Route + start date */ |
|---|
| 17 | SELECT * FROM closures WHERE route = 5 and startdate >= "2020-04-01"; |
|---|
| 18 | |
|---|
| 19 | SELECT * FROM closures WHERE route = 5 and startdate >= "2020-05-01"; |
|---|
| 20 | |
|---|
| 21 | /* Route + end date */ |
|---|
| 22 | SELECT * FROM closures WHERE route = 5 and startdate <= "2020-01-23"; |
|---|
| 23 | /* entry 71 */ |
|---|
| 24 | SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07"; |
|---|
| 25 | |
|---|
| 26 | /* Route + end date */ |
|---|
| 27 | SELECT * FROM closures WHERE route = 5 and startdate >= "2020-03-17" and startdate <= "2020-03-20"; |
|---|
| 28 | /* entry 69 */ |
|---|
| 29 | SELECT * FROM closures WHERE route = 5 and startdate <= "2019-01-07"; |
|---|
| 30 | |
|---|
| 31 | |
|---|
Note: See
TracBrowser
for help on using the repository browser.
