Re: Best way to add a pic and a thumbnail pic when creating a content management system
From: McKirahan (News_at_McKirahan.com)
Date: 03/11/04
- Next message: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Previous message: Laphan: "Best way to add a pic and a thumbnail pic when creating a content management system"
- In reply to: Laphan: "Best way to add a pic and a thumbnail pic when creating a content management system"
- Next in thread: Jeff Cochran: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 21:13:53 GMT
"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:ejIrns6BEHA.2800@tk2msftngp13.phx.gbl...
> Hi Guys
>
> Yet again its just a 'best laid plans' method rather than the actual
> physical coding for this.
>
> I've created a content management system that allows the admin user to
> create products with various bits of information (eg desc, price,
category,
> etc) and also attribute picture that they have uploaded via a combo of
their
> web browser and ASPUpload (the standard component I believe for this sort
of
> thing).
>
> I'm sure that there are various methods on how to link the pics to the
> products, but mine is as follows:
>
> 1) I have a web page 'section' that allows the admin user to upload, view
> and delete product pictures. At this stage the pics aren't related to any
> products they are simply a library of pics.
>
> 2) I have a web page 'section' that allows the admin user to create,
update
> and delete products. At this stage, when the admin user goes to create or
> update a product, I dynamically create a drop down list of all of the
> uploaded pics using the FileSysObj. The user then selects the relevant
pic
> and I store this reference in the DB.
>
> The above method seems to work OK apart from the following flaws:
>
> a) Because the pics and products aren't really created or deleted at the
> same time, the admin user is having to go into 2 different web page
> 'sections' to make sure that they have uploaded and linked the pictures is
> in. Its basically a 2 step process that isn't really as fluid as being
able
> to upload the picture in the same page as they enter their product info.
>
> b) The admin user deletes pics from one section which are actually used
for
> products. I suppose I could get round this by checking to make sure that
a
> product isn't using this pic first, but its a flaw all the same.
>
> c) The biggest bug bear is that if the user has 100 products with a 200
> uploaded pics (eg, 1 for the normal pic and 1 for the thumbnail) it means
> that my FileSysOb rouutine creates a huge drop-down list that they have to
> scroll through just to get to the 1 pic that they want.
>
> I suppose what I'm saying in a rambling sort of way is that do you know of
a
> better way of creating a product record whilst at the same time allowing
> them to upload a pic (or pics) to this product record as well. Note I
don't
> want to blob the pic. I want to put it in a folder and just store the
> filename as a ref.
>
> Any ideas/examples you can give would be very much appreciated.
>
> Rgds
>
> Laphan
Perhaps pictures could be stored in folders by Category;
for example, "images/Hosiery/", "images/Garters/", etc.
(per http://www.henrykaye.co.uk/)
Then the drop-down list would only contain images for the Category.
- Next message: Aaron Bertrand [MVP]: "Re: Best method of saving data between the normal and SSL stuff"
- Previous message: Laphan: "Best way to add a pic and a thumbnail pic when creating a content management system"
- In reply to: Laphan: "Best way to add a pic and a thumbnail pic when creating a content management system"
- Next in thread: Jeff Cochran: "Re: Best way to add a pic and a thumbnail pic when creating a content management system"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|