Image Data Type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John316 - 01 Mar 2005 11:03 GMT

I building a form in an .adp that needs to
display an image and also allow the end user
to add an image when generating a new record.

I've been able to use the GetChunk method to
roll through and display the image but how do I
allow the user to add an image when creating
a new record?

thanks in advance,
Bob McClellan

Reply to this Message

Sylvain Lafontaine - 01 Mar 2005 15:40 GMT

In my opinion, you can't do it directly from the ADP page and only the
regular HTML file upload control can be used to upload a file from the
client to the server. This is a security feature of IE.

Of course, you can install a special program on the client's machine or use
an authenticated Java Applet and things like that but those can be used only
for the intranet and the extranet cases; not the ordinary internet.

S. L.

>I building a form in an .adp that needs to
> display an image and also allow the end user
[quoted text clipped - 7 lines]
> thanks in advance,
> Bob McClellan

Reply to this Message

J. Clay - 01 Mar 2005 16:20 GMT

Being in an .ADP, I would use the ADODB.Stream method. This will allow you
to stream a binary file into an SQL image type field.

http://support.microsoft.com/?kbid=258038

HTH,
Jim

> I building a form in an .adp that needs to
> display an image and also allow the end user
[quoted text clipped - 7 lines]
> thanks in advance,
> Bob McClellan

Reply to this Message

John316 - 07 Mar 2005 21:09 GMT

Thanks J.
This is awesome. Looks like it will do just what I need.
Can this be used to feed image files to an .asp or .aspx page as well?

thanks in advance,
Bob McClellan.

> Being in an .ADP, I would use the ADODB.Stream method. This will allow
> you
[quoted text clipped - 16 lines]
>> thanks in advance,
>> Bob McClellan

Reply to this Message

J. Clay - 07 Mar 2005 21:36 GMT

Yes. What I do in our situation is to stream it back into a temporary file
and open that file. Then when done, I delete the file.

In ASP.NET, you probably don't need to save it as a temp file, you can just
create an ASPX page that outputs the file as its Response.OutputStream. I
use something like this in a custom graphics generator on a couple of my
sites. You need to create an aspx page that creates an OutputStream and
refer to this page from you main page.

HTH,
Jim

> Thanks J.
> This is awesome. Looks like it will do just what I need.
[quoted text clipped - 23 lines]
> >> thanks in advance,
> >> Bob McClellan

Reply to this Message

John316 - 08 Mar 2005 00:09 GMT

Thanks J.
That sounds like exactly what I need.
I am slowly working my way up the curve on this.
I've never used streaming. The example from the
site you referenced was perfect and easy to follow.
(for the .adp)
Is there anything similiar you can point me towards
to try and work with an .aspx file like what you mentioned.

Thanks in advance,
Bob McClellan

> Yes. What I do in our situation is to stream it back into a temporary
> file
[quoted text clipped - 37 lines]
>> >> thanks in advance,
>> >> Bob McClellan

Reply to this Message