<%@ Language=VBScript %> <% Dim objUpload Dim strFileName Dim objConn Dim objRs Dim lngFileID strTable = Request.QueryString("pictable") strField = Request.QueryString("picfield") sWhere = Request.QueryString("where") strPK = Request.QueryString("PK") strBack = Request.QueryString("Back") if strBack="" then strBack=1 else strBack = CStr(CLng(strBack)+1) end if if Request.TotalBytes>0 then ' Instantiate Upload Class Set objUpload = New clsUpload ' Grab the file name strFileName = objUpload.Fields("File1").FileName Set objConn = Server.CreateObject("ADODB.Connection") Set objRs = Server.CreateObject("ADODB.Recordset") objConn.Open strConnection objRs.Open "SELECT " & strPK & ", " & AddWrappers(strField) & " FROM " & AddWrappers(strTable) & " WHERE " & sWhere, objConn, adOpenKeyset, adLockOptimistic objRs.Fields(strField).AppendChunk objUpload("File1").BLOB & ChrB(0) objRs.Update objRs.Close Set objRs = Nothing Set objConn = Nothing Set objUpload = Nothing Response.Write "File has been saved in database

" end if %> Back to editing