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 along is required, the following 46 results were found.

  1. Trim values along with the tabhttps://www.joellipman.com/articles/else/database/mysql/trim-values-along-with-the-tab.html

    A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    7 apply to the code; keep intact all notices of the absence of any warranty; and give all recipients a copy of this License along with the Program. You may charge any price or no price for each copy that you convey, and you may offer support or warranty...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  3. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    be for you. In my environment, I am working with a Visual Studio 2008 IDE (Business Intelligence Development Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  4. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    the toolkit cd joels_awesome_app zet run The terminal response will advise that it is running zet at https://127.0.0.1:5000 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to display each section. How? The way we do this is by applying our own stylesheet and overriding certain CSS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    use access_token stored in file. It is assumed that you have already registered the app with the Google developers console along with the redirect URI being this script. Complete the global variables at the beginning of the code specific to your app and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  8. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. Thank You for your donation!https://www.joellipman.com/component/content/article/thank-you-for-your-donation.html?catid=45&Itemid=165

    (CMS) commercial equivalents. I use any donations to justify working on Joomla! specifically; but like to add things I learn along the way :c) Kind Regards, Joel Lipman

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  10. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    a road map - AHK is the car" ~tank Disclaimers For this tutorial, I will show you how to control webpages using JavaScript, along with the AHK COM "translations" (AutoHotkey_L in Black, AHK Basic in Green) - also, note Sean's post below. (Using COM...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  11. Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/component/content/article/fun-with-dllcall-in-autohotkey.html?catid=48&Itemid=165

    pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox, FunctionToDo, DLL File, Enter the name of the DLL file you want to (suffix...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  12. Client Services: Website Development Agreementhttps://www.joellipman.com/component/content/article/client-services-website-development-agreement.html?catid=50&Itemid=165

    joellipman.com and you: Once I have the domain names, I will configure my server to receive requests for those domains (along with webspace and emails). Please wait up to 3 hours for these changes to cascade across my servers (average wait is 1 hour)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    and even a bespoke project management system I wrote; so the brief for this component 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...

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

    to add a comparing if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code triggered when one of the fields is changed Add an eTag...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    How? We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today = thisDate; v_Tomorrow = v_Today.addDay(1); v_NextDay = v_Today.addDay(2);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    click on Settings > API Tokens > then API token - deployment > Get Started Fill out the client ID and client secret along with the Grant Code Click the button and you will get a refresh token which you can copy for the next step. STEP 4: THE REST A Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  17. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    asked here and on the forums as well for the full query that includes making ChatGPT keep the context of the conversation along with new cliqs: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  18. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-enable-tracking-using-the-api.html

    "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory enabled. But to flesh that out a little more along with setting the other options under "Advanced Tracking" // // get chart of accounts to use r_ChartOfAccounts = invokeurl [...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  19. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include these in her estimate template... But I'm sending them anyway. Note(s) The following code accesses...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 1 - 20 of 46