How to make a HTML form post its variables to itselfhttps://joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

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

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up...

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

MS Excel - Sort pivottable column headings by datehttps://joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? Then it wouldn't be evaluated as an expression and...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 How? My data file had some empty rows amongst the data. The easy fix is by dealing with any empty rows. The best way I've seen that has worked in nearly all cases, is to use the "conditional split" task and test one of the columns for a length of...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with...

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

T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 with an ORDER BY which seems to work somewhat. But using the code above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /256 :: turn off very long path (> 256 characters) support. /MON:n :: MONitor source; run again when more than n changes seen. /MOT:m :: MOnitor source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies may be...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 [OPTIONAL] convert it to an array // $array = json_decode($json_result,TRUE); // yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 get removed on Save/Update of the page. The following uses the built-in functionality of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of capabilities that can be done without loading another framework considering...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator but have it as a blank form rather than a bidirectional form as in this example,...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 Notes" to your form. I'm going to call it CSS_Overrides. It is important that this field will never be hidden (it cannot be seen on the front-end of the application but it must not be removed by Creator). If you know the code to remove this field, then...

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