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

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

    Module Manager > RokAjaxSearch > Basic Options > Advanced Search > Ordering (no functionality to add if you followed Stage 1 above) Lastly and optionally I add the following to the core joomla search module PHP template so that the first search is based...

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

  2. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the above example, the dates are wrong for subsequent days off sick: SELECT...

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

  3. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing...

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

  4. Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    me a while to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to change. Note that I am...

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

  5. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    DATEPART(MONTH,d.[Date]), -- used to get the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS...

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

  6. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells. 2. Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  7. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    Sean & fincs for helping with Native COM Support Sean for creating the COM Standard Library tank for the tutorial listed above, & daonlyfreez tank, sinkfaze, & jaco0646 for reviewing this tutorial Terms - The following terms will be used throughout this...

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

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

    Z 33554432 2000000 All Drives 67108863 3ffffff Log off and log on, or restart the computer to apply changes. Important! The above only applies to the user you are running Regedit as! (So if logged in as Admin, this hides it from the Admin, but not from...

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

  9. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

    type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an endpoint of https://www.zohoapis.com/crm/v7/Quotes. Showing...

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

  10. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    0 and it will search. Samples : 1. To search data in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The above sample searches in table T1 with string containing TEST. 2. To search in a multiple table EXEC SearchTables @Tablenames =...

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

  11. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    2 You now have a big SELECT query which you can copy, paste and run against your SQL database. Simply run the query that the above outputted and you should get something like the following: Value Source Count ------- ------------------------- --------...

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

  12. Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

    terms, permissive or non-permissive, may be stated in the form of a separately written license, or stated as exceptions; the above requirements apply either way. 8. Termination. You may not propagate or modify a covered work except as expressly provided...

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

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

    My solution so far: The following script will convert to lowercase and then capitalize the first letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script...

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

  14. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

    to add to google which would be: B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD;com.mydomain.myappname * In the above, if you have specified the correct bin folder in your PATH environment variable, then you can use the keytool from any...

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

  15. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    m_DataRecord); How? So this is more of an annoyance then an impossible task... because it is possible, the technique above is simply wrong. The trick and solution is a lot simpler than you might think... Doing the above, I would get a really messy...

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

  16. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    Re-run GetNotificationPreferences Just as a double-tap, let's run my GetNotificationPreferences function above specifying the "PreferenceLevel" to "User" to see the user notifications I just created. I get the following response:...

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

  17. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    [], "admin_graphql_api_id": "gid://shopify/ProductImage/23456789012345" } } This next version is a more generic form of the above function uploading the photo to Shopify: void API.fn_ShopifyQuery_UploadPhoto(int p_ProductID, int p_Position, string...

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

  18. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    the tabs group) and then a negative margin on another notes field called Note_Title which contains my header to place it above the tabs group: v_Css = ""; v_Css = v_Css + ".zc-Tabs-group .choice-table-row{display:inline-block !important;padding:0;}";...

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

  19. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    in the left sidebar menu Tick "Contacts" and "Invoices" and enter the Delivery URL as the REST API Function you noted above: Copy the Webhooks key on the Xero page into your CRM function replacing the value in Line 2 of my code snippet above. > Save the...

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

  20. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    Click on "Create" First thing I do is browse to the API Credentials tab: Store the API Key in your creator form you created above in the "Client ID" field. Store the API Secret (click on the copy icon or the eye icon to copy & paste) into the "Client...

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

Joes Word Cloud

Please publish modules in offcanvas position.