Thanks Pascal, i don't know why i was making it so complicated for myself. I'll put that into action.
If anyone wants to see my new site so they know what i'm talking about when asking questions (as there will be many!) it is at: http://www.020.com/ (that's the London telephone area code). Thanks again! Saturday ---------- Original Message ---------------------------------- From: "Pascal Peters" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 25 Nov 2004 12:51:15 +0100 >I would create a table for it (or maybe even two) > >Table 1: slideshow >(not really necessary if you have no other fields except the PK) > slideshowId (PK) > any other fields related to the slideshow (owner, title, ...) >Table 2: photo > photoId (PK) > slideshowId (FK) > photoFile > photoDesc > photoOrder > >Pascal > >> -----Original Message----- >> From: Stuart Kidd [mailto:[EMAIL PROTECTED] >> Sent: 25 November 2004 12:34 >> To: CF-Talk >> Subject: Photo slideshow. >> >> Hi guys, >> >> On my CMS i want to be able to add a photo slideshow whereby you can >> upload as many photographs as you like with a bit of accompanying text >for >> each. >> >> I was thinking of having 2 columns; PhotoDescriptionList and >> PhotoLocationList. >> >> The first, PhotoDescriptionList would be a comma-separated list of the >> descriptions, the PhotoLocationList would be the corresponding list of >> locations of the photographs eg. >> >/images/photoslides/24_233.jpg,/images/photoslides/24_233.jpg,/images/ph >ot >> oslides/24_233.jpg,/images/photoslides/24_234.jpg >> >> Do you think that this is the best way to do it? >> >> Also, should the column type be varchar and how many characters? I am >new >> to using SQL as before I was using Access and would use the 'TEXT' >> attribute. >> >> Thanks for your help, >> >> Saturday > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
