468,780 Members | 2,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,780 developers. It's quick & easy.

HowTo Send Uploaded File with INPUT Type file to Sql Server Image Data Type

I have the following problem:

I have the following form client side:

<FORM.......>

<FORM action="./WZUpload.asp" method="Post" enctype="multipart/form-data"
WIDTH=100%>
<INPUT Type="file" name="UpFileName" STYLE="{Width:400px}"><BR>

I have the following ASP code server side ....

AllDataB = Request.BinaryRead()

AllData = ConvertToStringFromByte(AllDataB)

AllDataFile = pGetRequestItem(AllData....) ' THIS INSTRUCTION FIND FILE
BINARY DATA.....

I need to transform SAFE ARRAY AllDataB in a Vb string because it's
necessary for me to find Header info and because AllDataB doesn't contain
only FILE BINARY DATA but other informations.

Now I want to insert DIRECTLY File Binary Data (in the variable AllDataFile)
in a Sql Server Image field without writing AllDataFile to a local file
using the FileSysteObject.

If I write:

Rs("ImageField").AppendChunk AllDataFile

IT DOESN'T WORK: the data format is UNICODE. And If I open the file the
format is UNRECOGNIZED.

Is There a Mode to insert directly data from BinaryRead to Sql Server Image
data type ?

If I write data from binaryread to a local file with FILESYSTEMOBJECT and I
read it with ADODB.STREAM and I write ADODB.STREAM content to SQL SERVER
IMAGE DATA TYPE it works but it's VERY VERY slow with large files.

Thanks Rob
Jul 19 '05 #1
3 5949
Hi Rob,

You may try following code to see if it will help:

Set objADO = CreateObject("ADODB.Stream")
objADO.Open
objADO.Type = 1
objADO.Write Request.BinaryRead(Request.TotalBytes)

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Jul 19 '05 #2
Ok. But Request.BinaryRead doesn't contain only binary data of FILE but
other information : for example
CONTENT - TYPE
CONTENT - DISPOSITION....

etc etc.....
Now I must position at the begin of Binary Data.....I have tried with INSTRB
and MIDB but if I call INSTRB with Binary Data it goes in crash.

Rob.

""台灣微軟技術處支援部"" <lu******@online.microsoft.com> wrote in message
news:Va**************@cpmsftngxa06.phx.gbl...
Hi Rob,

You may try following code to see if it will help:

Set objADO = CreateObject("ADODB.Stream")
objADO.Open
objADO.Type = 1
objADO.Write Request.BinaryRead(Request.TotalBytes)

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Jul 19 '05 #3
Hi Rob,

To remove the redundant data, you may refer to following article for third
party solution or pure script solution:

http://www.aspfaq.com/show.asp?id=2189

Addtionally, there is also a way with MSXML:

http://www.15seconds.com/issue/010522.htm

Hope this help,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by CSN | last post: by
9 posts views Thread by eswanson | last post: by
5 posts views Thread by IkBenHet | last post: by
reply views Thread by IkBenHet | last post: by
6 posts views Thread by Ian Boyd | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.