DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE @RandHour int; DECLARE...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 ' - ', r.ResourceName) AS Resource, s.StaffActivity AS Activity, s.AdditionalNotes AS Notes, CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Write a Calendar in Autohotkeyhttps://joellipman.com/component/content/article/write-a-calendar-in-autohotkey.html?catid=48&Itemid=165

27 January 2010 ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year Check1:=Mod(A_YYYY,4) Check2:=Mod(A_YYYY,100) Check3:=Mod(A_YYYY,400) if (Check1=0) AND...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 JOELLIPMAN_BOOLEANNO="No" JOELLIPMAN_ALLERGYTIMEOPTION0="Less than 6 months" JOELLIPMAN_ALLERGYTIMEOPTION1="Less than a year" JOELLIPMAN_ALLERGYTIMEOPTION2="1 year" JOELLIPMAN_ALLERGYTIMEOPTION3="5 years" JOELLIPMAN_ALLERGYTIMEOPTION4="10 years+"...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update. I suspected...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Google Event Ilustrations aka Flairshttps://joellipman.com/component/content/article/google-event-ilustrations-aka-flairs.html?catid=61&Itemid=165

05 December 2024 bookclub: book club, reading bowling: bowling breakfast: breakfast, breakfasts, brunch, brunches camping: camping chinesenewyear: chinese new year, chinese new years, chinese new year's cinema: cinema, movies clean: cleaning, clean the house, clean the...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: *

MySQL Data Type Reference Tablehttps://joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

15 February 2010 HH:MM:SS' 8 bytes "0000-01-01 00:00:00" to "9999-12-31 23:59:59" Date/Time TimeStamp 19700101000000 to sometime in the year 2037 4 bytes Date/Time Year 'YYYY', 'YY' Range "1901" to "2155" 1 byte

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

01 March 2011 describe what the system was for and what it does. The developer had created the system to only last during one academic year, and the system itself only just about understood academic years (required tweaking twice a year). Then there were the error...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

05 September 2011 If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list will be in the...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

07 April 2022 A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

AutoHotkey Format Date and Format Secondshttps://joellipman.com/component/content/article/autohotkey-format-date-and-format-seconds.html?catid=48&Itemid=165

20 September 2011 60) IfInString, ThisSecs, . ThisSecs:=SubStr(ThisSecs, 1, InStr(ThisSecs, ".")-1) If ThisDays>0 { If ThisDays>365 { ThisYears:=ThisDays/365 IfInString, ThisYears, . ThisYears:=SubStr(ThisYears, 1, InStr(ThisYears, ".")-1) Grammar:=(ThisYears=1) ? "" :...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Client Services: Website Development Agreementhttps://joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

15 November 2013 until these add up to 1 hour. Housing the production and 2 development websites and email system as permanent host is £120/year (or £10/mo). This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

12 July 2010 Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

28 June 2011 I then upload the images to my server and this Joomla! CMS uses them. Maybe I'll run this program again in a month, maybe a year. My websites don't depend on real-time screenshots and the sites I link to don't generally change their website design...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

07 July 2011 I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately hacked on more...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

03 April 2013 Infographic for Joomla (JIJ) need? Summary Period Report (details on your awstats report) Monthly History (per month per year) Days of Month (per day this month) Days of Week (per day this month) Hours (per hour this month) Countries (Top 25 this month)...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime = r_Event.get("Event_Time"); v_ThisEventNote = r_Event.get("Event_Details"); // //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Deluge
• Language: *

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 ID") AS "Invoice ID", MAX(inv."Invoice Date") AS "Invoice Date", MAX(abs_month(inv."Invoice Date")) AS "Invoice Month Year", MAX(inv."Invoice Number") AS "Invoice Ref", MAX(inv."Invoice Status") AS "Invoice Status", MAX(invitm."Buy Price") AS "Invoice...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Analytics
• Language: *

ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

16 January 2023 v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *