KonaKart Community Forum

Installation / Configuration => Programming of KonaKart => Topic started by: lolita on December 05, 2007, 07:40:04 pm

Title: Viewing queries
Post by: lolita on December 05, 2007, 07:40:04 pm
hi,

I would like to know how to view the queries for dependant products and new products.On what basis are these picked up?

Thanks,
Title: Re: Viewing queries
Post by: julie on December 05, 2007, 08:24:35 pm
New products are ordered by products_date_added and dependent products are set up in the merchandising tab after having clicked on a product in the Admin App.

Julie
Title: Re: Viewing queries
Post by: lolita on December 05, 2007, 09:17:55 pm
I would also need to view the query that is created and sent to the DB.Can you let me know where I can see the query that is formed.

Thanks,
Title: Re: Viewing queries
Post by: pete on December 06, 2007, 07:54:49 am
If you add log4j.logger.org.apache.torque = DEBUG to konakart-loggging.properties under WEB-INF/classes you should see the persistence layer logging which I believe includes the queries. You may have to reboot Tomcat in order to see the new logging.