Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming method is required, the following 94 results were found.

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

    [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public class ScriptMain : UserComponent { // Method that will be started for each record in your dataflow public override void Input0_ProcessInputRow(Input0Buffer Row) { // C#...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

    == "23") { English_Ordinal = "rd "; } // display info My_Date.toString("d") + English_Ordinal; How? I'm exploring various methods, so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    SELECT `user_id`, `group_id` FROM `v25_db`.`v25_user_usergroup_map` WHERE `user_id` @v25_admin_id; Joomla Categories Use method #1 if you already have third-party demo content in the database (eg. Quickstarts), use method #2 if you don't have any...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    This can get more complex when there are a lot of fields in the mix. How? I'm using this article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer and the problem happened in that the workflow would simply not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Alternative method of displaying Unicode in Autohotkey GUIhttps://joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

    Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25)...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. How to Install AlertPay Payment Method for Virtuemarthttps://joellipman.com/articles/ecommerce/virtuemart/how-to-install-alertpay-payment-method-for-virtuemart.html

    As the instructions to installing a new payment module in Virtuemart for Joomla! I've done this video showing how I apply it to my demo site. {youtube}g8YE26hA-UY{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: en-GB
  8. Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

    So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

    cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  10. Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

    WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  11. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

    https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile How? I've listed below 3 methods, the first follows the manual (or the logic thereof as I don't use the client library) and is a function sending two...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  12. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack of cards, I came up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the field: -- Note the alias for the field SELECT COUNT( DISTINCT `my_field`) AS myCount FROM my_table;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

    details report for that student automatically. How? So there are various solutions out there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

    A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  16. ReCaptcha disappears from Joomla 2.5 Registrationhttps://joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    topic - Cannot get recaptcha to display on registration form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

    differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    m_Params = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

    first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date = today; Day_Name =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Deluge - Get Current User IDhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

    This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
Results 1 - 20 of 94

Please publish modules in offcanvas position.