[ic] Writing informaton to database

[Kevin Walsh]

> I would like to write some of the users order information to a different
> table in the database for statistical use.  What is the best way to
> approch this?  I know I could do it with a [query sql=insert into ....]
> but that doesn't strike me as very secure.  What other methods would you
> suggest?  I searched the archives and didn't find anything, but if you
> know of a thread, point me there.
> 
Although I don't understand your security concern with [query] and SQL,
I would suggest you edit the catalogue's etc/log_transaction file.
Copy the existing method of writing to the transactions table, but use
your own table name and contents.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.uk.com
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/