Hello Guys,
I've done some work in the past with digital contact and calendar cards, such as vCard/Cal and iCard/Cal and I'm now looking to expand on this a little bit. The first thing I'm after is some ideas on the best way to implement a database model for dealing with them, has anyone has any experience with this? If you've worked with this kind of thing before you'll know that something like a vCard can have quite a bit of information attached to it, with several different phone and fax numbers for home, work, preferred and all kinds of stuff, should I be placing this in a single table? Or across several and making these telephone numbers relational to keep my table width down? To start with I'll be offering my users a very trimmed down version of the cards, so they will only have access to certain fields, but I figure that it makes good business logic to prepare for the future and make the database model as extensive and stable as possible, then I can grow the features quite simply by amending my cf code to allow access to the additional elements. Next I'm after a bit of help and input toward the parsing of the cards into their files, should I be using something like cfsavecontent? The only problems I've come across with this before have been spaces before and at the end of lines and things like this, often the parser for the vCard the other end (such as outlook or a mobile phone) get a bit fussy and deem the file corrupt if they have any whitespace. I'd love to hear from anyone that's done any work with this in the past and might have some hint and tips on working with it. Thanks guys, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
