Nasgaweb Homepage
Forum Home Forum Home » Nasgaweb Forums » Database
  New Posts New Posts RSS Feed - DB Issue 3/12/07
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Database

scottishheavyphotographs.com Old Celt Equipment

DB Issue 3/12/07

 Post Reply Post Reply
Author
Message
KTDupuis View Drop Down
Senior Member
Senior Member
Avatar

Joined: 8/29/04
Location: United States
Status: Offline
Points: 761
Post Options Post Options   Thanks (0) Thanks(0)   Quote KTDupuis Quote  Post ReplyReply Direct Link To This Post Topic: DB Issue 3/12/07
    Posted: 3/12/07 at 6:15am
Kurt,

Using the online entry form, I tried to enter some addtional scores to the Zephyrhills A Division. 2 guys entered their scores already (Brent and Brian). I tried adding my scores last week and could not. I tried adding my scores in a new division (Amateur), and it worked.

I just tried again to add scores for another thrower under the A division, and got the following error:

DIAG:Result was previously entered
DIAG:UPDATE Results SET Athletes_ID=3643, Class_ID=8369, Place=2, Points=22, Opstoneft=42, Opstonein=10, Opstonepts=679, Hwgtft=33, Hwgtin=6, Hwgtpts=674, Lwgtft=59, Lwgtin=3, Lwgtpts=637, Hhamft=83, Hhamin=8, Hhampts=680, Lhamft=111, Lhamin=2, Lhampts=737, Cabersc='80(4)', Caberpts=720, Sheafft=30, Sheafin=0, Sheafpts=851, Wfhft=13, Wfhin=0, Wfhpts=647, Decpoints=, Possiblepts=8000, NASGAsc= WHERE Results_ID=21913;

Microsoft JET Database Engine error '80040e14'

Syntax error in UPDATE statement.

/dbase/resultsentry.asp, line 2709

It seems to be complaining about the scores already entered.

Thanks,
Kevin D
"I have a right to my opinion, and my opinion is that you have no right to your opinion" - G. Carlin
Back to Top
admin View Drop Down
Admin Group
Admin Group
Avatar

Joined: 10/01/03
Location: United States
Status: Offline
Points: 301
Post Options Post Options   Thanks (0) Thanks(0)   Quote admin Quote  Post ReplyReply Direct Link To This Post Posted: 3/13/07 at 6:19am

I entered your scores under the A class.  There seems to be a problem with entering new results when not selecting all the events in the beginning.  I had them all selected and could enter them just fine.

I'll check into the problem though.

 

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.11
Copyright ©2001-2012 Web Wiz Ltd.

This page was generated in 0.047 seconds.