What is this?

[shipper50]

I try and post new scores and I get this?


Microsoft OLE DB Provider for SQL Server error '80040e07'

Error converting data type varchar to datetime.

/includes/clsData.asp, line 186

[BowlingTracker]

hmm.. I need to put more error checking in there. What are you putting for Lane? just put the lane you were assigned to, not the pair. ie.. put either 7 or 8 but not 7&8. The system will automatically display the pair with the lane your assigned to being bolded.

If that wasn't the problem, post here to tell me what values your putting in each field so i can see if i can duplicate the problem.

Thanks,
James

[shipper50]

Posting scores

I posted other scores and had no problems,

date 13-09-05
lane 7
game 200
game 257
game 169


When I hit total it gives me an error?

Shipper

[BowlingTracker]

I posted other scores and had no problems,

date 13-09-05
lane 7
game 200
game 257
game 169


When I hit total it gives me an error?

Shipper

ah.. the date format needs to be mm/dd/yyyy

[shipper50]

What is this?

I put the year like you said. I still get the error. Am I the only one on here that posts scores that get this error? I posted other scores and had no trouble. I tried to post a new house and cant get it or my old one to work?

Shipper

Ps, Quicks lanes in Laporte Indiana, is now CASEYS LANES.

[BowlingTracker]

it wasn't so much the year that was out of whack, but the order of the day and month.

The date should be "9/13/2005". for Sept 13, 2005.

[shipper50]

what is this?

It works fine now. Thanks for putting something like this up for us bowlers and we can keep track of the good and bad days.


Shipper

[BowlingTracker]

Please spread the word to other bowlers in your bowling center.. you can always print out and take the sheet with you to show others

Glad ya like it..

James