DB error on fishing report

[Jim Clevenger]

Tried to submit a fishing report...received the following:



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



Invalid column name 'bestpresentationID'.



/fishingreportdatabase/fishingreport.asp, line 91

 

[Rich Stern]

Sorry about that Jim. Made some changes today and didn't finish debugging. Should be ok now, so please try again.



I added four new fields to the fishing reports:



Best Depth

Best Lure

Best Presentation

Best Color



Hopefully, these will help folks key in on what, where and how to throw stuff at the fish.