Search - Joel Lipman .Com

41. MySQL last year week month day trend periods: / MySQL /; Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...; Created on 31 October 2011
42. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; As you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it' ...; Created on 20 September 2011
43. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... select Data Source Specify SQL Query: > Add Tables (not really just "close" this) > click on SQL button > Type/Paste your SQL Query > OK > Click on "Return Data" button Report Type: Select PivotTable ...; Created on 24 August 2011
44. SSRS / MDX Date Queries: / SQL Server Reporting Services /; So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in ...; Created on 03 August 2011
45. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; Apologies for copying and pasting this but this is information that is worth NOT losing. Tutorial on how to use COM objects in AutoHotkey. Source: Jethrow @ Autohotkey Forums Basic Webpage Controls ...; Created on 05 July 2011
46. Win32 Constants: / AutoHotkey /; ... = $0301 Const WM_PASTE = $0302 Const WM_CLEAR = $0303 Const WM_UNDO = $0304 Const WM_RENDERFORMAT = $0305 Const WM_RENDERALLFORMATS ...; Created on 05 July 2011
47. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... forum available but this has not helped me in the past and I have found it easier to answer comments on the website (rather than managing moderators, posts/topics, and opening any other can of worms, etc). ...; Created on 28 June 2011
48. Difference between two dates - the midnight hour: / Web-Development /; ... that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious ...; Created on 06 April 2011
49. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile ...; Created on 29 March 2011
50. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the left and the time along the top. We select a matrix ...; Created on 23 March 2011