Recent content by edwardod

Hi group, I'm looking for a way to represent the following data: Customers fall into one of 4 groups: * registered not shopped * placed < 5 orders * placed > 5 orders * lapsed (not placed an order for 1 month) Each week we are interested in the movement of customers between these...

I'm using modjk2&Apache2 to load balance requests between my two tomcat4.0.5 application servers. Each session is assigned a sessionID, and generally, this ID is held throughout a users session. About 10% of all sessions are failing to be sticky - meaning a user is assigned multiple sessionIDs...

Thanks for the reply Tony. This is a scaled down version of a much larger table. I need to find a way of doing it without explicitly stating each action in a sum. Any ideas?

I hope the formatting works on this post!! (question at bottom!) Thanks in advance, Edward Table structure: mysql> desc Log; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra |...