By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,294 Members | 1,564 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,294 IT Pros & Developers. It's quick & easy.

HELP: Product Database - adding images!

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a

"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
Jul 19 '05 #3

P: n/a
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.