The SPORTS PAGE ARCHIVE

Serving the Tri-Cities from 1976 to 1984

SECTIONS

SPI Menu

100: Full DB List

400: Contact Sheet List

130: Search

800: Documentation

You find links to 750
in 100 and 720.


720: OLD Auto Load

740: Database Records

760: DIR CONVERT (2023).

770: Audit issues and pages

780: Update Amazon/Kindle codes

790: Audit Database


710: Test TXT file LINE read

Directory test

FTP test




500-ERROR analysis and tests:

"Auto Load" basics to test 500 error

Force 500 (NO flush)

Error, but NO 500. (with cfFLUSH)




SPI-t010
rev 03/30/2024 16:49


SPI-0790.cfm rev 03/03/2024 10:58       SPORTS PAGE ANALYZE MAIN DATABASE (2)       {ts '2024-04-23 11:06:23'}

 

First box. Count records on file

Start tick 1,713,884,783,625
SPI_Type = P says individual page entry.

<cfquery name="SPIq_Stories" datasource="MyBayCity" >
      SELECT * FROM mbc_tsportspage_idx
      WHERE SPI_Type = "P"
      ORDER BY SPI_IssueDate
</cfquery>

SPIq_Stories returned 6,304 pages.

End tick 1,713,884,785,657
2.032 seconds elapsed.
 

close 1st box.


Start 2nd, DISTINCT box

DISTINCT ISSUE YEARs on file list.

      <cfquery name="SPIq_Issues" datasource="MyBayCity" >
          SELECT DISTINCT SPI_IssueDate FROM mbc_tsportspage_idx
          WHERE SPI_Type = "P"
          ORDER BY SPI_IssueDate
      </cfquery>

SPIq_Issues returned 10 distinct years.

[] quoted nul value [0] len zero (nul) not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year is Null
      </cfquery>
      SPIq_IssuePages returned 25

[1976] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1976"
      </cfquery>
      SPIq_IssuePages returned 236

[1977] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1977"
      </cfquery>
      SPIq_IssuePages returned 498

[1978] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1978"
      </cfquery>
      SPIq_IssuePages returned 752

[1979] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1979"
      </cfquery>
      SPIq_IssuePages returned 1021

[1980] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1980"
      </cfquery>
      SPIq_IssuePages returned 974

[1981] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1981"
      </cfquery>
      SPIq_IssuePages returned 584

[1982] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1982"
      </cfquery>
      SPIq_IssuePages returned 585

[1983] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1983"
      </cfquery>
      SPIq_IssuePages returned 788

[1984] value [4] not-isNull
      <cfquery name="SPIq_IssuePages" datasource="MyBayCity">
              SELECT SPI_Issue_year FROM mbc_tsportspage_idx
              WHERE SPI_Type = "P" and SPI_Issue_year = "1984"
      </cfquery>
      SPIq_IssuePages returned 841

End distinct years box 1.769 seconds elapsed.


Start 2nd, DISTINCT box

DISTINCT ISSUEs on file list.
<cfquery name="SPIq_Issues" datasource="MyBayCity" >
      SELECT DISTINCT SPI_IssueDate FROM mbc_tsportspage_idx
     
      ORDER BY SPI_IssueDate
</cfquery>

SPIq_Issues returned 360 distinct issues.

                   
1976-07-05
1976-07-19
1976-08-02
1976-08-16
1976-09-06
1976-09-20
1976-10-04
1976-10-18
1976-11-01
1976-11-15
1976-12-06
1976-12-20
                   
1977-01-03
1977-01-17
1977-02-07
1977-02-21
1977-03-07
1977-03-21
1977-04-04
1977-04-18
1977-05-02
1977-05-16
1977-06-06
1977-06-20
1977-07-04
1977-07-18
1977-08-01
1977-08-15
1977-09-05
1977-09-20
1977-10-03
1977-10-17
1977-11-07
1977-11-21
1977-12-05
1977-12-19
                   
1978-01-02
1978-01-16
1978-02-06
1978-02-20
1978-03-06
1978-03-20
1978-04-03
1978-04-17
1978-05-05
1978-05-12
1978-05-19
1978-05-26
1978-06-02
1978-06-09
1978-06-16
1978-06-23
1978-06-30
1978-07-07
1978-07-14
1978-07-21
1978-07-28
1978-08-04
1978-08-11
1978-08-18
1978-08-25
1978-09-01
1978-09-08
1978-09-15
1978-09-22
1978-09-29
1978-10-06
1978-10-13
1978-10-20
1978-10-27
1978-11-03
1978-11-10
1978-11-17
1978-11-24
1978-12-01
1978-12-08
1978-12-15
1978-12-22
1978-12-29
                   
1979-01-01
1979-02-02
1979-02-09
1979-02-16
1979-02-23
1979-03-02
1979-03-09
1979-03-16
1979-03-23
1979-03-30
1979-04-06
1979-04-13
1979-04-20
1979-04-27
1979-05-04
1979-05-11
1979-05-18
1979-05-25
1979-06-01
1979-06-08
1979-06-15
1979-06-22
1979-06-29
1979-07-06
1979-07-13
1979-07-20
1979-07-27
1979-08-03
1979-08-10
1979-08-17
1979-08-24
1979-08-31
1979-09-07
1979-09-14
1979-09-21
1979-09-28
1979-10-05
1979-10-12
1979-10-19
1979-10-26
1979-11-02
1979-11-09
1979-11-16
1979-11-23
1979-11-30
1979-12-07
1979-12-14
1979-12-21
1979-12-28
                   
1980-01-01
1980-02-01
1980-02-08
1980-02-15
1980-02-22
1980-03-07
1980-03-14
1980-03-21
1980-03-28
1980-04-04
1980-04-11
1980-04-18
1980-04-25
1980-05-02
1980-05-09
1980-05-16
1980-05-23
1980-05-30
1980-06-06
1980-06-13
1980-06-20
1980-06-27
1980-07-04
1980-07-11
1980-07-18
1980-07-25
1980-08-01
1980-08-08
1980-08-15
1980-08-22
1980-08-29
1980-09-05
1980-09-12
1980-09-19
1980-10-02
1980-10-09
1980-10-16
1980-10-23
1980-10-30
1980-11-06
1980-11-13
1980-11-20
1980-11-27
1980-12-04
1980-12-11
1980-12-18
1980-12-25
                   
1981-02-05
1981-02-12
1981-02-19
1981-02-26
1981-03-05
1981-03-12
1981-03-19
1981-03-26
1981-04-02
1981-04-09
1981-04-16
1981-04-30
1981-05-07
1981-05-14
1981-05-21
1981-05-28
1981-06-04
1981-06-11
1981-06-18
1981-06-25
1981-07-02
1981-07-09
1981-07-16
1981-07-23
1981-07-30
1981-08-06
1981-08-13
1981-08-20
1981-08-27
1981-09-03
1981-09-10
1981-09-17
1981-09-24
1981-10-01
1981-10-08
1981-10-15
1981-10-22
1981-10-29
1981-11-05
1981-11-12
1981-11-19
1981-11-26
1981-12-03
1981-12-10
1981-12-17
1981-12-24
1981-12-31
                   
1982-02-04
1982-02-11
1982-02-18
1982-02-25
1982-03-04
1982-03-11
1982-03-18
1982-03-25
1982-04-01
1982-04-08
1982-04-15
1982-04-22
1982-04-29
1982-05-06
1982-05-13
1982-05-20
1982-05-27
1982-06-03
1982-06-10
1982-06-17
1982-06-24
1982-07-01
1982-07-08
1982-07-15
1982-07-22
1982-07-29
1982-08-05
1982-08-12
1982-08-19
1982-08-26
1982-09-02
1982-09-09
1982-09-16
1982-09-23
1982-09-30
1982-10-07
1982-10-14
1982-10-21
1982-10-28
1982-11-02
1982-11-04
1982-11-11
1982-11-18
1982-11-25
1982-12-02
1982-12-09
1982-12-16
1982-12-23
1982-12-30
                   
1983-01-27
1983-02-03
1983-02-10
1983-02-17
1983-02-24
1983-03-10
1983-03-17
1983-03-24
1983-03-31
1983-04-07
1983-04-14
1983-04-21
1983-04-28
1983-05-05
1983-05-12
1983-05-19
1983-05-26
1983-06-02
1983-06-09
1983-06-16
1983-06-23
1983-06-30
1983-07-07
1983-07-14
1983-07-21
1983-07-28
1983-08-04
1983-08-11
1983-08-18
1983-08-25
1983-09-01
1983-09-08
1983-09-15
1983-09-22
1983-09-29
1983-10-06
1983-10-13
1983-10-20
1983-10-27
1983-11-03
1983-11-10
1983-11-17
1983-11-24
1983-12-01
1983-12-08
1983-12-15
1983-12-22
1983-12-29
                   
1984-01-19
1984-02-02
1984-02-09
1984-02-16
1984-02-23
1984-03-01
1984-03-08
1984-03-15
1984-03-22
1984-03-29
1984-04-05
1984-04-12
1984-04-19
1984-04-26
1984-05-03
1984-05-10
1984-05-17
1984-05-24
1984-05-31
1984-06-07
1984-06-14
1984-06-21
1984-06-28
1984-07-05
1984-07-12
1984-07-19
1984-07-26
1984-08-02
1984-08-09
1984-08-16
1984-08-23
1984-08-30
1984-09-06
1984-09-13
1984-09-20
1984-09-27
1984-10-04
1984-10-11
1984-10-18
                   
2022-05-04

End 2nd box 0.016 seconds elapsed.


 
 




End right column, row and table         (in t900 rev 03/30/2024 16:16 )
 



t900 PUT BOX AROUND DIAGS 12/08/2023 17:17

SPIc-t900     rev 01/15/2024 21:06         now: {ts '2024-04-23 11:06:27'}
  SPI_template [SPI-0790.cfm]

Tick counts from SPI-t010
SPI_TickNow 1,713,884,787,442
SPI_TickBegin 1,713,884,783,625
SPI_Elapsed 3,817

t900 AFTER BOX around DIAGS 12/08/2023