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
