Viewing queries

[lolita]

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,

[julie]

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

[lolita]

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,

[pete]

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.