uploading files

[Motty]

Hi
I'm trying to create a page that I can upload multiple files to the
server and log the meta-data into the Sql database.
I have two parts working find but I'm missing one part.
To start I'm using SoftArtisans upload program to grab all the
elements I need.
I have the first page/form that has a DRW retrieving records from the
database and an input field within the DRW that allows the user to add
data to each line.
Form two loops : for i = 1 to request.form("v1").count and posts the
values to the database.
All works fine.
Now I want to replace the input field V1 (text box) with a file upload
box and browse and I call it V1 too (removing the text box).
It does not behave the same once a post to the second form and try
looping:


for i = 1 to request.form("v1").count
if request.form("v1")(i) <> "" then
rsq = "Update ir_inspect set value=" & "'" & request.form("v1")(i) &
"'" & " where mainkey=" & request("mainkey")(i)
response.write rsq
Conn.execute(rsq)
end if
next



I get nothing.

Is there a way I can grab the file upload (i) the same way I can the
text box?


Thanks

Motty

 

[Jim Buyens]

-----Original Message-----

Hi
Howdy.

I'm trying to create a page that I can upload multiple
files to the server and log the meta-data into the Sql
database.

...

I get nothing.

I wish these kinds of results were that easy to get, but
sadly they're not. It takes special ASP or ASP.NET code to
receive the uploaded file information, and then more ASP
or ASP.NET code to save the file and update the database.

For starters, review the doc at
http://support.softartisans.com/docs/FileUpV4/
If you have no background on ASP or ASP.NET, you should
probbly buy a book or two, or look around
http://msdn.microsoft.com/library

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[chris leeds]

http://www.aurigma.com/Products/MediaGallery/
I bought it and deployed it. it's very impressive especially the upload
multiple features and image manipulation copyright watermarking and so on.
I can't wait till I get some time to "understand it"

if you don't need .net or the gallery display you can probably find
something "open source".

why are you trying to do this anyway?