I copied letter for letter Faisal's code and am getting the following error. Appears that a couple of others have as well, so I find little comfort in that others got stuck on this as well. When I run the insert.htm page, I get the following error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/testDB/Insert.asp, line 112
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Page:
POST 263150 bytes to /testDB/Insert.asp
POST Data:
error '80020009'
Exception occurred.
/iisHelp/common/500-100.asp, line 223