Just finished a document management system that allows you to upload files to a central store, fill in predefined keywords, do keyword searches or, if the file is text searchable, run a text search. It includes an admin section where users can create different document type templates that the user can create different keyword questions and answer types (text, select, or dates). It authenticates against active directory and includes security so that only the creators of documents, or creators of their parent types can edit the keywords.
And I didn't write one lick of sql :) I've fallen hard for you Ruby...... well, come to think of it, I did need to write a sql template for the full text search line. Something along the line of Document.find(:conditions=>[' contains (text_data, ?)',text_search] zB -- "Heavy...heavy water, won't wash away the sins of the father" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:240609 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
