Hi,

I have an upload page with author, gallery, file1, file2, file3, caption and keywords fields that uploads images (Pure ASP Upload & Smart ImageProcessor) and inserts file1 correctly with author, gallery,... into the SQL Server database table. I have a redirect to a next page which has to insert the two remaining records (file2 and file3 with author, gallery,...). This with 2 Command behaviours. With static VALUES this works fine, but when I trie to use variables to add data (both Request.Form and Request.Querystring doesn't work), I'm getting following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/image-belle/asp/images/upload_6_ok.asp, line 24

Line 24 is the .execute line of the Command to insert file2 into the DB.

So, the second page seems not to be able to retrieve the form field values of the first upload page.

Any ideas ?
Any help much appreciated !!

Danny Brison

When you use the Upload Server Behaviour from DMXZone you cannot do request.form or request.querystring.

This should help:

www.dmxzone.com/showDetail.asp?TypeId=7&NewsId=3798