On Thu, 9 Oct 2003 13:09:14 +0100, "mark | r" <mark@nmd.freeuk.com>
wrote:
[color=blue]
>
>"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:3f9d4b0f.252584206@msnews.microsoft.com...[color=green]
>> On Thu, 9 Oct 2003 10:24:18 +0100, "mark | r" <mark@nmd.freeuk.com>
>> wrote:
>>[color=darkred]
>> >ok, so i now know how to add, edit, delete and search for products[/color][/color]
>(havent[color=green][color=darkred]
>> >figured out categorisation out yet tho) - how do i upload an image and[/color][/color]
>save[color=green][color=darkred]
>> >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?)[/color]
>>
>> 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[/color]
>
>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.[/color]
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