Problem inseting multiple records
I am trying to create a page where a user can upload multiple images and have the records insert in to a table all in one go. I have followed the solution recipe to the letter but no matter what I do (and I have tried it countless times) I just keep getting this error.
Cannot use Request.Form
/newwebsite/cms_files/_cms_admin_image_add_multiple_upload.asp, line 100
Cannot use Request.Form collection after calling BinaryRead.
This refers to code on the page which looks like this
' WA DataAssist Multiple Inserts
THIS IS LINE 100 if (cStr(Request.Form("Submit")) <> "") then
WA_loopedFields = Array("MainCategoryID", "CategoryID", "ImageFilename")
WA_connection = MM_connContent_STRING
WA_table = "Images"
WA_redirectURL = "_cms_admin_image.asp"
WA_keepQueryString = false
WA_fieldNamesStr = "MainCategoryID|CategoryID|ImageFilename"
WA_columnTypesStr = "none,none,NULL|none,none,NULL|',none,''"
WA_insertIfNotBlank = "ImageFilename"
WA_fieldNames = Split(WA_fieldNamesStr,"|")
WA_columns = Split(WA_columnTypesStr,"|")
WA_multipleInsertCounter = 0
and so on...
This is the code that insert multiple records puts in so not clear what needs changing?
Or else am I trying to do something that is not going to be possible?