problems uploading online

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   kurt:
DIAG: iBrstonect=0
DIAG: iOpstonect=1
DIAG: iHwgtct=1
DIAG: iLwgtct=1
DIAG: iHhamct=1
DIAG: iLhamct=0
DIAG: iCaberct=1
DIAG: iSheafct=1
DIAG: iWfhct=1
DIAG:Result was previously entered
DIAG: total pts init=0
DIAG: dbase Brstonepts=
DIAG: total pts after brstone=
DIAG: total pts after opstone=
DIAG: total pts after hwgt=
DIAG: total pts after lwgt=
DIAG: total pts after hham=
DIAG: total pts after lham=
DIAG: total pts after caber=
DIAG: total pts after sheaf=
DIAG: total pts after wfh=
DIAG:UPDATE Results SET Athletes_ID=1646, Class_ID=8784, Place=1, Points=1, Opstoneft=39, Opstonein=8, Opstonepts=629, Hwgtft=43, Hwgtin=2.5, Hwgtpts=870, Lwgtft=82, Lwgtin=8, Lwgtpts=888, Hhamft=108, Hhamin=4, Hhampts=881, Cabersc='70', Caberpts=630, Sheafft=25, Sheafin=3, Sheafpts=716, Wfhft=17, Wfhin=1, Wfhpts=851, Decpoints=, Possiblepts=7000, NASGAsc= WHERE Results_ID=23207;

Microsoft JET Database Engine error '80040e14' 
Syntax error in UPDATE statement. 
/dbase/resultsentry.asp, line 2743 

I have enter these scores 3x and get the same results. I notice craig smith ran home to enter his results ..so would that be an issue...
I notice in the error it was his stats that in the error report.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Snider Members Profile Send Private Message Find Members Posts Add to Buddy List Postaholic Joined: 8/30/04 Location: United States Status: Offline Points: 2518	Post Options Post Reply Quote Snider Report Post Thanks(0) Quote Reply Topic: problems uploading online Posted: 5/28/07 at 1:59am
	kurt: DIAG: iBrstonect=0 DIAG: iOpstonect=1 DIAG: iHwgtct=1 DIAG: iLwgtct=1 DIAG: iHhamct=1 DIAG: iLhamct=0 DIAG: iCaberct=1 DIAG: iSheafct=1 DIAG: iWfhct=1 DIAG:Result was previously entered DIAG: total pts init=0 DIAG: dbase Brstonepts= DIAG: total pts after brstone= DIAG: total pts after opstone= DIAG: total pts after hwgt= DIAG: total pts after lwgt= DIAG: total pts after hham= DIAG: total pts after lham= DIAG: total pts after caber= DIAG: total pts after sheaf= DIAG: total pts after wfh= DIAG:UPDATE Results SET Athletes_ID=1646, Class_ID=8784, Place=1, Points=1, Opstoneft=39, Opstonein=8, Opstonepts=629, Hwgtft=43, Hwgtin=2.5, Hwgtpts=870, Lwgtft=82, Lwgtin=8, Lwgtpts=888, Hhamft=108, Hhamin=4, Hhampts=881, Cabersc='70', Caberpts=630, Sheafft=25, Sheafin=3, Sheafpts=716, Wfhft=17, Wfhin=1, Wfhpts=851, Decpoints=, Possiblepts=7000, NASGAsc= WHERE Results_ID=23207; Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /dbase/resultsentry.asp, line 2743 I have enter these scores 3x and get the same results. I notice craig smith ran home to enter his results ..so would that be an issue... I notice in the error it was his stats that in the error report.

Snider Members Profile Send Private Message Find Members Posts Add to Buddy List Postaholic Joined: 8/30/04 Location: United States Status: Offline Points: 2518	Post Options Post Reply Quote Snider Report Post Thanks(0) Quote Reply Posted: 5/28/07 at 2:01am
	it allowed me to enter the Notes and records but not anything to do with the athletes

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply Posted: 5/28/07 at 2:38pm
	Did you try this: "Until I can fix the problem with updating results in the database, please be sure to leave all the boxes checked for all the events (even if events in the results were not contested in) before going into the actual results entry form."

McBain1975 Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Postaholic Joined: 8/30/04 Location: United States Status: Offline Points: 1596	Post Options Post Reply Quote McBain1975 Report Post Thanks(0) Quote Reply Posted: 6/01/07 at 6:38am
	I am having the same problem, even with leaving all the boxes checked.
	N�l m� ag duine le daoine.

Lori Henderson Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Senior Member Joined: 9/22/04 Location: United States Status: Offline Points: 343	Post Options Post Reply Quote Lori Henderson Report Post Thanks(0) Quote Reply Posted: 6/14/07 at 12:58pm
	Kurt, I am getting some similar today when trying to correct a score in a class. I did great last night entering the whole game but today can't fix a mistake I made. Thank you, Lori