[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Writing informaton to database
> 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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/