Spectra UserProfiles are somewhat useful within Spectra. However we need to integrate the user data with our company's Access database from which mail brochures, etc. We don't want duplicate data anywhere, so when a user registers on the web we don't want to just plunk the data into Access. My plan is to create a "translation" table in SQL Server with one row for each userprofile. I'll attach a dateUpdated field to it. Whenever I do a cfa_userprofile I'll subsequently call a custom tag that updates this table with the data from the UserProfile. On the Access side I'll create some forms that allow a data entry person to see new and updated records in the "translation" table, and selectively add or update the Access table. To reverse the flow of updates I'd have to cfschedule a query of this table to look for updates from Access and stick them into UserProfiles. Any better ideas? What are others doing to make userprofiles useful outside Spectra? Thanks, Derek W ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
