application.cfm for SportsPage. rev: 2022/04/27 11:15
Sports Page SPI-0720.cfm Auto Load Pages to databse. apptitle: [This is application.cfm for SportsPage by SGK. see notes]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE17.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [17]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '17'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3245]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE18.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [18]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '18'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3246]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE19.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [19]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '19'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3247]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE20.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [20]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '20'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3248]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE21.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [21]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '21'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3249]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE22.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [22]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '22'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3250]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE23.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [23]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '23'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3251]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE24.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [24]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '24'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3252]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE25.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [25]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '25'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3253]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE26.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [26]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '26'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3254]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE27.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [27]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '27'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3255]
Include SPI-0720-FileName-Parse.cfm rev 05/07/2022 10:27
04-20-1979_SPORTS PAGE28.txt
SPIfnp_Date [04-20-1979] FIXED [1979-04-20]
SPIwk_pageStartCol [23]
SPIfnp_PageNumber [28]
Bottom of include SPI-0720-FileName-Parse.cfm
TEST RECORD for table of file names <cfquery name="SPIq_TestIssue" datasource="MyBayCity" >
SELECT * FROM mbc_tsportspage_idx
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '28'
</cfquery>
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3256]
0720 Tick Now | 1,686,101,542,157 |
0720 Tick Begin | 1,686,101,541,063 |
0720 Tick Now | 1,094 |
WHERE SPI_Type = 'P' and SPI_IssueDate = '1979-04-20' and SPI_Issue_Page = '18'
SPIq_TestIssue returned 1 stories. SPI_ProgramID [3246]