HELP: Product Database - adding images!

[mark | r]

ok, so i now know how to add, edit, delete and search for products (havent
figured out categorisation out yet tho) - how do i upload an image and save
the file name to the database as part of the admin? something dummies can
follow that doesnt use a component (can i throw in a chunk of code and
specify the table fieldname and directory the file needs to go into?)

cheerz

mark

[Jeff Cochran]

On Thu, 9 Oct 2003 10:24:18 +0100, "mark | r" <ma**@nmd.freeuk.com>
wrote:

ok, so i now know how to add, edit, delete and search for products (havent
figured out categorisation out yet tho) - how do i upload an image and save
the file name to the database as part of the admin? something dummies can
follow that doesnt use a component (can i throw in a chunk of code and
specify the table fieldname and directory the file needs to go into?)

Well, you do it that same way you send other data to a record. :)

You need to provide more info if you want specifics, such as what
database, what ASP code you're using and so on.

Jeff

[mark | r]

"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:3f****************@msnews.microsoft.com...

On Thu, 9 Oct 2003 10:24:18 +0100, "mark | r" <ma**@nmd.freeuk.com>
wrote:

ok, so i now know how to add, edit, delete and search for products (haventfigured out categorisation out yet tho) - how do i upload an image and savethe file name to the database as part of the admin? something dummies can
follow that doesnt use a component (can i throw in a chunk of code and
specify the table fieldname and directory the file needs to go into?)

Well, you do it that same way you send other data to a record. :)

You need to provide more info if you want specifics, such as what
database, what ASP code you're using and so on.

Jeff

using msaccess and a standard insert sql? i already have the product name,
description etc working in an administratable format, i plan on adding
session based security which looks simple enough, i plan on having thumbs
and enlargements uploaded to the web server in a particular folder.

im really looking for a lump of script that will take form fields and upload
a file to the server, adding the filename into the database.

mark

[Jeff Cochran]

On Thu, 9 Oct 2003 13:09:14 +0100, "mark | r" <ma**@nmd.freeuk.com>
wrote:

"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:3f****************@msnews.microsoft.com...

On Thu, 9 Oct 2003 10:24:18 +0100, "mark | r" <ma**@nmd.freeuk.com>
wrote:

>ok, so i now know how to add, edit, delete and search for products(havent >figured out categorisation out yet tho) - how do i upload an image andsave >the file name to the database as part of the admin? something dummies can
>follow that doesnt use a component (can i throw in a chunk of code and
>specify the table fieldname and directory the file needs to go into?)

Well, you do it that same way you send other data to a record. :)

You need to provide more info if you want specifics, such as what
database, what ASP code you're using and so on.

Jeff

using msaccess and a standard insert sql? i already have the product name,
description etc working in an administratable format, i plan on adding
session based security which looks simple enough, i plan on having thumbs
and enlargements uploaded to the web server in a particular folder.

im really looking for a lump of script that will take form fields and upload
a file to the server, adding the filename into the database.

Google "ASP Upload" and you'll find quite a few options. Also take a
look at:

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

You have the option of how you'll store the images to think about, for
example, will they all be the same size? Will they be at that size
when you upload or will they need to be resized? Are you storing all
image files in a single directory or in separate directories? If
separate, how are the directories structured?

For example, if all images are stored with the part number as the name
and in the same folder, say \images, then you don't even need to worry
about storing the info in a database. You'd just provide them with
code similar to:

Response.Write "<IMG SRC='/images/" & PartNumber & ".jpg'>"

Jeff