Reading content to insert into a database for file content searches
I have a new challenge that has been brought to me.
There is and existing application that has files being inserted into the database and the customer is having great difficulty in being able to have a search capability against those files. I was thinking that I could do a secondary lookup before the file is actually uploaded and there would be use of the cffile to read the file then insert that data from the read and insert that data into a column of that database the equiled that record. The most important part of this is that the file's content is read from cffile and inserted into a column that actually get's that data into the RBDMS system that will allow for a full text search that would point to that system.
Any other ideas of how to insert document content into a data record other than using the cffile tag would be most appreciated.
Thanks in advance.
Gene
