upload a jpg file to an access database...???

[AWZ]

I think I heard that you can't have a jpg in an access database, however you
could point to where the jpg was from within the database. What I need to know
is how can I create an upload form that will put the path of where the picture
is on the server into the access database. Or possibly there is a much easier
way to do this and someone could help. Thanks.

The result of what I'm trying to do is have a user upload a jpg and it display
on a page in the site. Thanks again for any feedback.

[mpwoodward *TMM*]

On 2005-05-19 18:31:04 -0500, "AWZ" <webforumsuser@macromedia.com> said:

> I think I heard that you can't have a jpg in an access database,
> however you could point to where the jpg was from within the database.
> What I need to know is how can I create an upload form that will put
> the path of where the picture is on the server into the access
> database. Or possibly there is a much easier way to do this and someone
> could help. Thanks.
>
> The result of what I'm trying to do is have a user upload a jpg and it
> display on a page in the site. Thanks again for any feedback.

Yep, uploading the file using CFFILE and just storing the path to the
image in the database is a tried-and-true method of accomplishing this.
Basically you just have a form that allows for a file upload, and
after CF has uploaded the file (using CFFILE) you can get the name of
the file as it was saved on the server by using FILE.SERVERFILE after
the upload. Then you grab that value and insert it into your database.

You can see an example of the upload process here:
[url]http://tinyurl.com/3w82w[/url]

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion