| Upload - Simple upload to database | |
|---|---|
<%
'Sample file db-bytearay.asp
'Simple upload to database.
'Suitable for small files - up to 20% of physical server memory
'This sample works with any connection - MDB (JetOLEDB, ODBC)
' MS SQL (MSDASQL/ODBC) etc.
Server.ScriptTimeout = 240
'Simple upload to database
Dim Form: Set Form = Server.CreateObject("ScriptUtils.ASPForm")
'was the Form successfully received?
If Form.State = 0 Then
Dim Conn, RS
'Open connection to database
Set Conn = GetConnection
Set RS = Server.CreateObject("ADODB.Recordset")
'Open dynamic recordset, table Upload
RS.Open "Upload", Conn, 2, 2
RS.AddNew
'Store extra form info.
RS("Description") = Form("Description")
RS("Title") = Form("Title")
'Add file from source field 'DBFile' to table field 'Data'
RS("Data") = Form("DBFile").ByteArray
'Store technical informations
RS("ContentType") = Form("DBFile").ContentType
RS("SouceFileName") = Form("DBFile").FileName
RS("DataSize") = Form("DBFile").Length
RS("UploadDT") = Now()
RS.Update
RS.Close
Conn.Close
End If'Form.State = 0 then
Function GetConnection()
Dim Conn: Set Conn = CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.Open "Data Source=" & Server.MapPath("upload.mdb")
Set GetConnection = Conn
End Function
Function CreateUploadTable(Conn)
'This function creates upload table for MSSQL 6.5/7.0/2000
Dim SQL
SQL = SQL & "CREATE TABLE Upload ("
SQL = SQL & " UploadID int IDENTITY (1, 1) NOT NULL ,"
SQL = SQL & " UploadDT datetime NULL ,"
SQL = SQL & " RemoteIP char (15) NULL ,"
SQL = SQL & " ContentType char (64) NULL ,"
SQL = SQL & " SouceFileName varchar (255) NULL ,"
SQL = SQL & " Title varchar (255) NULL ,"
SQL = SQL & " Description text NULL ,"
SQL = SQL & " Data image NULL "
SQL = SQL & ")"
Conn.Execute SQL
End Function
%>
Simple upload To database, sample For <A Href=http://www.motobit.com>HugeASP upload</A>.<br>
Suitable For small files - up To 20% of physical server memory<br>
<Table><form method=post ENCTYPE="multipart/form-data">
<TR>
<TD></TD>
<TD Align=Right><input type="submit" Name="Action" value="Upload the file >>"></TD>
</TR>
<TR>
<TD>File To upload</TD>
<TD><input type="file" name="DBFile"></TD>
</TR>
<TR>
<TD>Title</TD>
<TD><input size="60" name="Title" value="Title of the file."></TD>
</TR>
<TR>
<TD>Description</TD>
<TD><textarea cols="60" rows="8" name="Description">Type description of the file.</textarea></TD>
</TR>
</form></Table> | |
One form field. Member of FormFields collection.
Huge ASP upload is easy to use, hi-performance ASP file upload component with progress bar indicator. This component lets you upload multiple files with size up to 4GB to a disk or a database along with another form fields. Huge ASP file upload is a most featured upload component on a market with competitive price and a great performance . The software has also a free version of asp upload with progress, called Pure asp upload , written in plain VBS, without components (so you do not need to install anything on server). This installation package contains also ScriptUtilities library. Script Utilities lets you create hi-performance log files , works with binary data , you can download multiple files with zip/arj compression, work with INI files and much more with the ASP utility.
© 1996 - 2011 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz