You are going to need some sort of Upload software.
For this example, we are going to use Persits.Upload for the upload manager.
<!-- BEGIN SNIPPET -->
<%
Set Upload = Server.CreateObject("Persits.Upload") 'need to
download ASPUpload to use this.
Upload.IgnoreNoPost = true
'ASPUpload Specific
Upload.Save ""
'ASPUpload Specific
Set File = Upload.Files("fld_2")
'ASPUpload Specific
'
if Upload.form("button")="Upload!" then
'
If Upload.form("fld_2") <> "" then
If Not File Is Nothing Then
'
SQL = "INSERT INTO table_name
(fld_0,fld_1,fld_2,File_Type,File_Size) VALUES ('"
SQL = SQL & value_0 & "','" & value_1 & "',?,'" &
right(File.FileName,3) & "','" & File.Size & "')"
'Here the ? Is the uploaded file from your web page.
File.ToDatabase "DSN=<yourDSN>", SQL 'The Connection to
the Database.
Response.Write "File saved."
Else
Response.Write "File not selected." 'If INPUT
TYPE="FILE" IS Empty then bail
End If
else
response.write "There is an Error... Check this out" 'Other type
of error message
end if
Set Upload = nothing 'Clean Up
Set File = nothing 'Clean up
end if
%>
<form method="post" action="your_page_goes_here.asp"
enctype="multipart/form-data">
<input type="file" name="fld_1" size="20">
<input type="submit" value="submit" name="button">
</form>
<!-- END SNIPPET -->
What you will notice is that if the form is OK (not missing any req.
fields), then it sends the file to the database. The ? is the value of the
uploaded file. It is recommended that you send the file type in case you
want to pull them later without having to worry about putting in specific
Response.ContentType for every page. You can use the File_Type in the db to
use the right ContentType.
The File.ToDatabase object pushes the SQL string (including the Uploaded
BLOB string) to the database.
That's it. Of course, you will have to tailor this to your upload software
and to your database.
J.R.
-----Original Message-----
From: Brian E Boothe [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 13, 2005 10:50 PM
To: mysql@lists.mysql.com
Subject: BLOB Source
Can someone please post some asp or php working with BLOB Files, and how to
Get files into a Mysql Database,, in working woth PDF Files thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
