I just wanted to mention one other thing. Statements like the below dont fly. You either need to have the customer define the requirements or you come up with a list of solutions and have them pick the best option or a combo of the options, but if you do not get buy-off on the customer expectations of what they will be receiving your setting yourself up for many headaches. For the customer to say do it and make it work leaves the door wide open for them to come back and say they dont like what you gave them and do it all over, or as they see you heading down a path they can change directions on you.
""whatever it needs to do or however it needs to work, I just wanna be able to do that..." Thanks, CC x56927 ---------------------------------------------------------------------------------------- This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ---------------------------------------------------------------------------------------- "Jeff Small" <jsmall @lhwh.com> 01/20/2005 08:47 AM Please respond to cf-talk To: CF-Talk <cf-talk@houseoffusion.com> cc: Subject: Okay, I've never quite run into this before... It's not an odd request, just something that seems probably a little more complex than it initially appears, and I just want to make sure I'm heading in the right direction, design-wise. Client has an events calendar, dates, events, details (text), possibly an image all kept in the appropriate tables in the database. Client also has a table that keeps track of artists (It's a little local pro-bono arts council) with information about the artist, their gallery, contact info, etc...point being, VERY different data than the events. Client wants an area on the home page for featured events OR artist. In other words, when there's nothing important going on, swap an artist's info there, with links to some images of their work, etc. I've got the isFeatured flags in each table, one in the artists table, and one in the events table, so an event or an artist could be flagged, but it brings up a lot of questions. Like, where does the integrity reside for making sure that there can only be one event OR one artist that's flagged as currently active? Do you want to have to UNflag an event or artist before you can flag another one? Does the flagging of an event as "featured" automatically unflag an artist? The client says, "whatever it needs to do or however it needs to work, I just wanna be able to do that..." I'm doing this whole thing with CFCs, so the solution is obviously to write a CFC or series of CFCs to handle it all, but I was wondering what my pitfalls were and what was a good way to handle different types of results coming back for what's essentially a query that says, "give me this, if it's an event and it's active, or give me this if it's an artist and it's active, and it'll be different data depending on which one it is"? I was thinking, "return a struct from the CFC, and use a variable in the struct that's set in the CFC to determine what kind of data the struct is returning"...something along the lines of (pseudo): <cfif getFeature.isArtist EQ 1> "It's an artist, display their info" <cfelseif getFeature.isArtist EQ 0> "It's not an artist, it's an event, display that info" </cfif> And have all the checking done in the CFC by querying the tables to see which one contains an active "featured" event or artist. Does this make sense? Is it a lot easier than I'm thinking? I've just never run into the "only one set of data from a possible query of two different places" scenario... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191219 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54