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.


740: Database Records

720: OLD Auto Load

760: DIR CONVERT (2023).

770: Audit issues

710: Test 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 12/01/2023 16:30


SPI-0720.cfm rev 12/01/2023 16:35       SPORTS PAGE AUTO LOAD       {ts '2023-12-01 23:44:48'}


OLD STYLE PROGRAM

Replaced by SPI-0760



Defaults:       {ts '2023-12-01 23:44:48'}
      SPIf_FileNumber [2]
      SPIf_RunLive [N]

 

SPIuse_Prefix [d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/]
      This just tells us the folder where the raw files are found.

SPI_Raw_list shown in a textarea:
      This is a list of all the rew files we want to process.
      The fils are found in the [SPIuse_Prefix] shown above

      As files are finished, new files are uploaded and we change this list.
      The list is hand build within this script.



SPI_Raw_list has 12 entries.

Loop over SPI_Raw_list and build table of contents of the 12 entries:

cfloop index="AITix1" from="1" to="12"
 
line DATE PAGE REC ID ADD UPDATE VIEW dB FILE NAME
                Start date 1979-04-20
1 1979-04-20 17 3245
04-20-1979_SPORTS PAGE17.txt
2 1979-04-20 18 3246
04-20-1979_SPORTS PAGE18.txt
3 1979-04-20 19 3247
04-20-1979_SPORTS PAGE19.txt
4 1979-04-20 20 3248
04-20-1979_SPORTS PAGE20.txt
5 1979-04-20 21 3249
04-20-1979_SPORTS PAGE21.txt
6 1979-04-20 22 3250
04-20-1979_SPORTS PAGE22.txt
7 1979-04-20 23 3251
04-20-1979_SPORTS PAGE23.txt
8 1979-04-20 24 3252
04-20-1979_SPORTS PAGE24.txt
9 1979-04-20 25 3253
04-20-1979_SPORTS PAGE25.txt
10 1979-04-20 26 3254
04-20-1979_SPORTS PAGE26.txt
11 1979-04-20 27 3255
04-20-1979_SPORTS PAGE27.txt
12 1979-04-20 28 3256
04-20-1979_SPORTS PAGE28.txt


BOTTOM OF TABLE OF FILES {ts '2023-12-01 23:44:50'}  

{ts '2023-12-01 23:44:50'}
Default SPIuse_ListItem to 1.       (numeric)
SPIuse_ListItem [2]

SPIuse_FileName [] Original value
SPIuse_FileName [04-20-1979_SPORTS PAGE18.txt] RAW VERSION
SPIuse_FileName [04-20-1979_SPORTS PAGE18] fixed .TXT
SPIuse_FileName [04-20-1979_SPORTS PAGE18] fixed .HTML
SPIuse_DataFile [d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/04-20-1979_SPORTS PAGE18.txt]
 
SPIuse_Date [04-20-1979]       FIXED [1979-04-20]

SPIwk_pageStartCol [23]
SPIuse_PageNumber [18]
SPIs_Background [ background:pink; ]
SPIflag_Include [N]

SPIcondition_Inc_1 [next ->]
SPIcondition_Inc_2 [<- Previous]
SPIcondition_Inc_3 []]]] First]

show SPIuse_Date again [1979-04-20]
Now show SPI_DteWork [1979-04-20]
 
Dump some iniial values
      SPIuse_Date [1979-04-20] IS date
      SPIuse_PageNumber [18] numeric
      SPIuse_FileName [04-20-1979_SPORTS PAGE18]       used for SPI_Issue. (4/30/2022 WAS SPIuse_issue)

TEST FOR FILE EXIST
[d:/Websites/bcra-mlscom/mmcctech/SportsPage/1979-02-12-raw/04-20-1979_SPORTS PAGE18.txt]
 
FILE WAS FOUND
 
Look for  SPIcondition_Inc_1 [next ->],
          SPIcondition_Inc_2 [<- Previous],
          SPIcondition_Inc_3 []]]] First]

 
Line Data
1 [[[[!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"]]]] [[[[HTML]]]]
2 [[[[TITLE]]]] [[[[/TITLE]]]]
3 [[[[META NAME="description" CONTENT=""]]]]
4 [[[[META NAME="keywords" CONTENT=""]]]]
5 [[[[META NAME="author" CONTENT=""]]]]
6 [[[[META NAME="generator" CONTENT="Iceni Technology: GeminiSolo"]]]]
8 [[[[BODY bgcolor="white"]]]]
9 [[[[A HREF="04-20-1979_SPORTS PAGE_101.html"]]]] <- Previous [[[[/a]]]]  
                  Found SPIcondition_Inc_x     [next ->]     OR     [<- Previous]     OR     []]]] First]
                  BEGIN INCLUDING TEXT IN OUTPUT with next line.
10 [[[[A HREF="04-20-1979_SPORTS PAGE_101.html"]]]] First [[[[/a]]]]
11   [[[[A HREF="04-20-1979_SPORTS PAGE_103.html"]]]] Next -> [[[[/a]]]]
14 [[[[IMG SRC="04-20-1979_SPORTS PAGE_102-00.jpg" WIDTH="1654.00" HEIGHT="2480.00" BORDER=0 ALT=" 04-20-1979_SPORTS PAGE_102-00.jpg 4594x6888 (pixels)"]]]]
16 4
18 Sports Page, April 20,'1979
20 .
22 Editorial
24 Pressure's On The Kids
26 Pinconning Year Book Advisor Says Thanks
28 will be using them in our Once again, thank you.
30 yearbook as they were ex-
32 Thank you very much for cellent photos showing the Phyllis Mosciski
33 the action photos from our emotion and excitement of the
35 PARENT PRESSURE - AN ANSWER
37 Dear Mr. Cunningham,
39 (Ed. Note: This "open letter" at*eared in the Lansing State
40 Journal. It ir about hockey but certainly pertains to most any
41 sport. Thanks to S. R. Murin of Saginaw for sending it our
43 way.)
45 Dear Mom and Dad,
47 Yearbook Advisor
49 district basketball game. We game.
51 Writer Has A Question
53 I)ear Sir,
55 I hope you won't get mad at me for writing this letter, but
56 you always tell me never to hold anything back, and bring it out
57 in the open. So here goes.
59 It's about hockey. You're always embarrassing me.
60 Yesterday when I went after the puck in front of the goal,
61 trying to score and I fell, well, Mom, I could hear you yelling at
62 the goalie for tripping me. Gosh, Mom, it wasn't his fault. He's
63 supposed to keep me from scoring.
65 Then, do you remember yelling at me to get on the blue
66 line? Well, gee, I didn't know where to go then; 'cause the
67 coach had told me to cover my man, and I couldn't if I listened
68 to you, so while I tried to decide what to do, the other team
69 scored against us, then you yelled at me for being in the wrong
70 place. I wish you'd yell some good things at all of us sometimes.
72 Dad, you're always yelling "hit him" or "get him" and
73 gosh I'd rather play hockey than sit in the penalty box. Besides
74 my coach tells me to "lean" on my man and steer him away
75 from the goalmouth and into the boards. That way it's a clean
76 check and I get to stay on the ice and play some more.
78 Dad, I'm not saying that all coaches teach that way, but
79 our coach tells us we've got lots of time to learn how to hit
80 harder and how to do it right.
82 But what got me really mad, Mom and Dad, was what
83 happened after the game. You shouldn't have jumped on the
84 coach for pulling me off the ice. He's a pretty swell guy and he's
85 a pretty good coach and he knows when he needs a power line
86 on the ice. Besides, he's just a volunteer coming to the rink at
87 all hours to help us kids, just 'cause he likes sports and he likes
89 kids.
91 Thank you.
93 Enclosed is a check for $5
95 Anthony R. Trogan
97 for another year of Sports
99 Bay City, Mich.
101 Page. I like it very much.
103 Find out who is the oldest [Does anyone out there know
105 the answerl -Editor.]
106 bowling scorekeeper and put it in the paper.
108 --
110 And then neithe of you spoke to me the whole way home. I
111 guess you were pretty sore at me for not getting a goal. I tried
112 awfully hard, but I guess you think I'm just a lousy hockey
113 player. And I guess I am. But I love hockey. I like being with
114 the other kids and learning how to compete as a good sport in a
116 really great sport.
118 And another thing. Last week when we played in Center
119 City, the parents there actually gave one of our players a
120 standing ovation... boy, did that make us feel great. Anyway,
121 I wish our parents could see how great it was.
123 I guess what I'm trying to say, Mom and Dad, is I wish you
124 were good sports 'cause I thought I was playing hockey for fun,
125 to have a good time, to learn how to play a sport as a team
126 member and learn sportsmanship. I didn't know you were going
127 to be so upset because I couldn't become a star.
129 ..
131 0 . 0
133 ... 0 , 1
135 .
137 . 0,
139 0 0
141 1 0
143 .0 .
145 111
147 .I¢
149 ¤ YES!
151 I'd like to talk to a loan officer
152 about a loan!
154 I've checked the box at left indicating
155 the amount of loan rm interested in!
157 516.99
159 Valu*
161 S 15.99
162 value
164 c OFF .
166 0 NO!
168 h B. Engineer Burge
170 But here's my $100 deposit
172 for the rose!
174 111 1 .I0
176 LIST LOUNGE
177 2648 Broadway
179 __895-9564 Take Out
181 at the
183 1
185 ADOMESS- - -
187 111 1 ,
189 1,1
191 07¥- z- --
193 -I.I.
195 *'A'2
197 420064, 60 - -
199 .
201 ij) SPORTS PAGE
203 2 ti
205 SECOND ATIOMAL
207 BAMK
209 809 Saginaw St. Bay City, MI
211 892-ZO 1
213 Sports P,9,(USPS 321411) is published .v.ry Frid.v, 03<copt in January, for 15.00 per year by Spans Pig, Piblications, 109 Sagin,w St., Bay City, MI 41791
214 Second-class post*g* ,*Wit Bal City, M ichigin.
215 POSTMASTER: Send address change. to Sports P.I.,
217 P.O. Box 171. B.v City. Michigan 41717.
219 BAY CITY
221 I1I .
223 ,-AcoND NATIONAL COMRATION BANK
225 $59.99
226 value
228 Publisher ..........................O.J. Cunningham, Jr.
230 Editor ......... ..................... ... David L. Tinglan Staff Photographer :. . ....................... . Leona Bush Office Manager....... ................... . Donna Kraynak
232 }
233 [[[[A HREF="04-20-1979_SPORTS PAGE_101.html"]]]] <- Previous [[[[/a]]]]  
234 [[[[A HREF="04-20-1979_SPORTS PAGE_101.html"]]]] First [[[[/a]]]]
235   [[[[A HREF="04-20-1979_SPORTS PAGE_103.html"]]]] Next -> [[[[/a]]]]
238 [[[[/BODY]]]] [[[[/HTML]]]]


  Block contains 5,204 bytes.

 

SPI_DteWork IS a valid date. PROCESS ADD or UPDATE
Use date [1979-04-20]       Use page [18]

TEST RECORD PRIOR TO ADD or UPDATE
<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]

Record AIF. UPDATE that record
SPIq_UpdKey: [ SPI_Type = 'P' and SPI_ProgramID = '3246' ]

<cfquery name="SPIq_UpdateIssue" datasource="MyBayCity" >
    UPDATE mbc_tsportspage_idx
      SET SPI_IssueDate = '1979-04-20', ------ date
      SPI_Issue_Page = '18',
      SPI_Issue = '04-20-1979_SPORTS PAGE18',
        SPI_Type = 'P',
        SPI_Link = 'CS_1979_04_20.jpg',
        SPI_Data = '#SPIwk_Block#',
        SPI_Changed = '2023-12-01 23:44:50',
        SPI_ChangedBy = 'SPI-0720'
      WHERE SPI_Type = 'P' and SPI_ProgramID = '3246'
</cfquery>

Run is NOT LIVE.       Record was NOT Updated
















 
 




END OF RIGHT COLUMN, ROW, Table (in t900 rev 05/08/2022 13:46 )
 



application.cfm for SportsPage. rev: 2022/04/27 11:15



SPI-t010.cfm rev 12/01/2023 16:30
now {ts '2023-12-01 23:44:48'}       SPI_TickBegin 1,701,492,288,731
SPI_template: SPI-0720.cfm--- end of t010 startup ---




Sports Page SPI-0720.cfm Auto Load Pages to database.

apptitle: [This is application.cfm for SportsPage by SGK. see notes]

Include SPI-0720-FileName-Parse.cfm       rev 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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 11/04/2022 18:08
      SPIraw_FileName 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,701,492,290,084
0720 Tick Begin 1,701,492,288,731
0720 Tick Now 1,353

 


TEST RECORD PRIOR TO ADD or UPDATE
<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]

Record AIF. UPDATE that record
SPIq_UpdKey: [ SPI_Type = 'P' and SPI_ProgramID = '3246' ]

<cfquery name="SPIq_UpdateIssue" datasource="MyBayCity" >
    UPDATE mbc_tsportspage_idx
      SET SPI_IssueDate = '1979-04-20', ------ date
      SPI_Issue_Page = '18',
      SPI_Issue = '04-20-1979_SPORTS PAGE18',
        SPI_Type = 'P',
        SPI_Link = 'CS_1979_04_20.jpg',
        SPI_Data = '#SPIwk_Block#',
        SPI_Changed = '2023-12-01 23:44:50',
        SPI_ChangedBy = 'SPI-0720'
      WHERE SPI_Type = 'P' and SPI_ProgramID = '3246'
</cfquery>

Run is NOT LIVE.       Record was NOT Updated


0720 Tick Now 1,701,492,290,116
0720 Tick Begin 1,701,492,288,731
0720 Tick Now 1,385

 


SPIc-t900     rev 4/25/2020 10:38
  now: {ts '2023-12-01 23:44:50'}
  SPI_template [SPI-0720.cfm]

Tick counts from t010
SPI_TickNow 1,701,492,290,116
SPI_TickBegin 1,701,492,288,731
SPI_Elapsed 1,385