editing suggestion please

[thenotorious_flag]

I have created the edit module in which the some 4 categories are hard coded and other categories can be provided by the user in the text field. I mean if he does not choose from the select menu, he can add his/her own category.

But I am dumed there where i store all the images and the attachments to that very folder of the category like category IS : COPLES and the record inserted is 10, so itwill create a folder of COPLES and a folder of 10 inside COPLES to make it different from other records.

NOW I have to edit the record and i display the info as entered by the user when he first added the record,

If that changes the category from COPLES to HOPES, then what should i do?

delete the folder of 10 inside coples and then move the files to the HOPES folder or do something else?

I think the above will carry a lot of load to the server.

Is there some other way you can suggest me, or i should give the access of category at all.

Please provide your suggesstions, needed very much, i want to make a decision based on your calculations and mine too

Cheers/

[Newsgroup_User]

how about just renaming the folder COPLES to HOPES?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[thenotorious_flag]

Thanks Mate, But will this not effect other records, like coples have folders like 10, 20,30 and 41, so changing the folder name to HOPes will render them inuseable.

Any

[Newsgroup_User]

i guess i did not guess correctly what you wanted to do...
your description of your problem is far from clear, so i had to guess...

maybe you can try and explain again what you are trying to do? maybe add
some code from your form?


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[thenotorious_flag]

Okay i explain a bit detail. What exactly i am trying to do is:

Adding the record in the database with fields like add name, choose category from 4 hardcoded values in the form, like(schools, Families, Couples, Honeymoon) and if the user does not want to add the record in the above category, he can write his/her own category in the textbox provided.
Okay the record is added to the database and images and any attachment file will be added to the category that person will choose, like the category he choose is LOCATIONS (his own created category), so a folder with Name LOCATIONS wwill be created. If the inserted ID is 1st then the Folder of name 1 will be created and all his images/attachments wwill be stored over there.

Hope u understood till the time what i am trying to convey here?

Now when editing, let's say he choose another category for the record he is editing. Okay till now his category was LOCATIONS, he choosed his category now to FAMILIES.
My problem occurs there, where, Should i move the images.attachment to the new created folder and delete the old folder 1 under LOCATIONS and add a new Folder 1 under FAMILIES with the updated info.
So i was just curious this cause some load on the Cfusion server as there might be bit of good enough to be done by the sever. WELL ALSO I WILL BE PLACING MY COMPLETED WEBSITE ON SHRED HOST. sO THIS COULD CREATE A PROBLEM.

iN THIS REGARDS I NEED A SUGGESTIONS?

tHANKS