Has anyone ever using AS Perl to build an index for dtSearch? I need to index the contents of 4D databases located on a network, which are accessible via ODBC, without creating intermediate text files. David Thede, from the dtSearch Tech Support Department, told me that I needed to implement an IDispatch object. How do you do that in AS Perl? Many thanks. Philippe de Rochambeau ==================== Recommendations given by the dtSearch Tech Support Deparment ========= I would like to index several 4D databases which are accessible on a network via ODBC, using dtSearch Web. Do I need to create intermediate files and have dtSearch index them, or can I index the databases directly? If so, do I need ADO, Visual Basic, etc.? If I need ADO, Visual Basic, etc. can I use ActiveState Perl instead? Please see this article on our web site for information on indexing databases using the dtSearch Engine: How to index databases with the dtSearch Engine http://www.dtsearch2.com/faq/DTS0111.htm The easiest way to do this is with ADO, starting with the sample code included with the dtSearch Engine (in [dtsearch]\examples\vbasic\ado_demo). If you just need to index the data once (or occasionally), you might want to just use the ado_demo as is or with minor modifications, rather than going to the trouble of writing your own program to do this. You can still do searches in dtSearch Web of the index. The sample is in Visual Basic but you can use any language that works with COM and can implement an IDispatch object. In ASP and VBScript, you could use a Class object. If you are using the Microsoft implementation of Perl, I think it can also do this. VB is just easier because you have the ado_demo sample as a pre-built starting point. Once an index is built of the database, you can search that index using any of the dtSearch Engine APIs. After a search, you will get back a SearchResults object just as you would with any other list. However, you will need to some customization of the searching because the filenames returned after a search will not refer to disk files, so dtSearch Web will not know how to display a retrieved record. If you need to display the contents of a retrieved record when the user clicks on it in search results, you can start with the ASP sample (in [dtsearch]\examples\asp\dtsearch.asp) and modify the code to do this. (You would change the getdoc method to do a database lookup based on the filename to get the data to display.) David Thede dtSearch Corporation _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/activeperl
