| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello,
I am currently working on tutes so I can upload and display images from an Access database. I am getting errors to no end again. Can someone please pin point the error in these places: insert.asp - ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. In this chunk of code: ' Recordset object Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "Files", connStr, 2, 2 ' Adding data rs.AddNew rs("File Name") = fileName rs("File Size") = fileSize rs("File Data").AppendChunk fileData rs("Content Type") = contentType rs("First Name") = fnameInput <<< This line is specified. rs("Last Name") = lnameInput rs("Profession") = profession rs.Update rs.Close Set rs = Nothing Show.asp - Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. on this line ' opening connection rs.Open "select [ID],[File Name],[File Size],[Content Type]," & _ "[First Name],[Last Name],[Profession] from Files " & _ "order by [ID] desc", connStr, 3, 4 Where on earth am I going wrong on tutorial code? I just want to be able to update, view and delete images from a database, how hard can that be?? Regards, Nicole |
![]() |
| Viewing: ASP Free Forums > Programming > Code Bank > Uploading and Viewing Images from Access DB |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|