First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was last. This is incredibly useful for pagination. The Situation I want the script to start writing a...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 Click the address bar, then pressCtrl+Backspace. Deletes the key term that precedes your cursor in the address bar Select an entry in the address bar drop-down menu with your keyboard arrows, then press Shift+Delete. Deletes the entry from your browsing...

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

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

07 July 2011 had to include features I've used all along but in their most basic form. OPTIONS/FEATURES All versions combined under one entry (project). Links to Joomla articles for documentation and changelog. Share/Like/Review/Feedback by JComments or Facebook....

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I was reading up on the MSDN page for the closest solution but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 0007 Test Product 1 TEST001 test2@joellipman.com The code is a for loop which iterates through each row, assigning an entry for a new product or account, and specifying the quantity for each. How? So depending on the number of levels, the count will be...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 the list view LV_Add("", A_LoopFileName, v_NewNameWithExt ) ; update for the status bar v_RowCount++ SB_SetText("Generating entry #" v_RowCount ".") } ; auto fit columns LV_Modifycol(1, "AutoHdr") LV_Modifycol(2, "AutoHdr") ; update status bar v_Grammar...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 Method #1: Display and access without login So the quickest is to have a form that has an image upload field. Create an entry with one image. Then... Go to Settings Publish Publish Component > Select your report Copy the embed code it pops up with to...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): 2. Code to push Time Log entry to Zoho Projects: Example #1: Pushing a time log with a specified start date/time (requires end time field if using): // //...

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

Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 purposes - eg. so 10 is not before 2) Store both the formatted count and the value of column1.table in the next array entry Reverse this array Display the first 10 rows of this array (if we are doing a top ten) My new method is: SELECT column1, COUNT(*)...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

24 August 2011 EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit of...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 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 following order: 2010, 2011, 2013, 2012. The Solution Bring up the...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you right-click on an object). The following is a method of adding this as a single command similar...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 your SQL Developer program Open SQL Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 want this applied to the current logged-in user (delete the NoDrives DWORD). The concept of creating the NoDrives registry entry is what you need to remember. In the example below, we are applying the same principle to a specific user account (the Guest...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 Find the screen you know contains the field to monitor, in this example, it will be the Application Clearance and Decision Entry (ACD) screen. Put the cursor in the field and press F1, this will give you the name of the field, its entity and dictionary....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Flight Regulations API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 l_StrLength = {0,1,2,3,4}; // assign a letter to a list entry for each index v_Index in l_StrLength { l_Output.add( l_Alphabet.get(randomNumber(0, 25)) ); } // output v_Output= l_Output.toString(""); return v_Output; } Additional Notes: As this was for...

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

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

21 November 2019 > "Error details: Execution Failed Due to invalid expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This indicates that the search to see if the product exists is case-sensitive, but...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 the user to download just by clicking it. Additional: Why not set a scheduled task on the expiry date/time to delete this entry for both house-keeping and security? with the following deluge if(!isnull(input.ID)) { delete from Download_File[ID ==...

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