Just have one table, do not worry about the size of the table, it's negligible. If it's a site that requires a login, save their login id, the search term and the date (it does not matter if you intend on using it now, you might later). You do not need a counter, you can count using the SQL query. Good grief.
On 8/24/07, stylo stylo <[EMAIL PROTECTED]> wrote: > >Actually, I wrote an article about this for CFDJ, which includes code for a > >cfc that reports on search terms, auto-mails a weekly (or other period) > >report, etc.: > > > >http://cfdj.sys-con.com/read/48234.htm > > > I'll take a look, thanks for the tip! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
