[farcry-dev] getVisitorPath.cfm error (fixed)

[Jeff Coughlin]

If you had a visitor on a page for more than an hour before clicking 
through to another page this reporting page would crash Farcry.

Attached to this thread I have a fixed version of the file which 
accounts for hours (It also displays hours correctly rather than 
displaying 12 for hour zero).

This file hasn't pervious been updated in CVS since Sept 2003, so this 
patch will likely work fine in any Farcry 2.x installation.

path = farcry_core/packages/farcry/_stats/getVisitorPath.cfm
Regards,
Jeff Coughlin


	SELECT NavId, PageId, logDateTime
	FROM #application.dbowner#stats
	WHERE sessionId = '#arguments.sessionId#'
		AND navid <> pageId
	ORDER BY logDateTime desc






	
	
		
		
		
		
		
			
			
		
			
		
		
	
		
	
	
	
	
	
	
	
	
		
	
		
	
	
	
	
	
	
		SELECT *
		FROM qPathWrongOrder
		ORDER BY orderNum desc
	

---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Aussie Macromedia Developers: http://lists.daemon.com.au/