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

  1. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    == 'install') { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->update($db->quoteName('#__extensions')); $defaults = '{"param1":"value1","param2":"value2"}'; // JSON format for the parameters $query->set($db->quoteName('params') . ' = '...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rc:Parameters=False To change the Rendering modes (defaults to HTML4.0) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Format=XML Where XML can be any of the following: HTML3.2, HTML4.0,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  4. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Database=myDataBase; User=myUsername;Password=myPassword; The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL. MySQL Connector/ODBC 3.51 Type: ODBC Driver Usage: Driver={MySQL ODBC...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  5. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    GMT_Date_Time_End, System_Date_Time_Start, System_Date_Time_End, Agent_Date_Time_Start, and Agent_Date_Time_End: // defaults v_AppointmentDuration = 30; // // get customer's requested time v_CustomersRequestedTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    - gives the client an exit strategy) Can the developer be contacted? No! Security Check Usernames/Passwords (formats, defaults and vulnerability) Technical Review Examine all functions: what goes in, what comes out? (accepts/returns, data types...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  7. AutoHotkey: Check Windows Folder Sizeshttps://www.joellipman.com/component/content/article/autohotkey-check-windows-folder-sizes.html?catid=48&Itemid=165

    force ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title := "Joes Folder Sizes" Desc := "This...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  8. Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/component/content/article/autohotkey-chrome-profiles-in-alphabetical-order.html?catid=48&Itemid=165

    force ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title := "Joes Chrome Profile Opener" Desc :=...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    MySQL which doesn't need to and in my opinion is the best SQL). Additional Note(s): select can specify up to 50 fields. Defaults to 200 but can return up to 10000 records (NB: use endpoint https://www.zohoapis.com/crm/v7/coql). where can contain up to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    The quick answer is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not converted" records: =zoho.crm.searchRecords(,,,,,); The solution: The long answer/investigation is getting a JSON...

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

    v_Css2 + ""; input.Note_TabCSS = v_Css2; And I'd also have to add some code to the OnLoad workflow I created earlier which defaults this to perhaps the first tab: // // by default highlight first tab v_Css2 = ""; v_Css2 = v_Css2 + ".zc-Tabs-group...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can be searched for with the "State" field on the Lead...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    ??? - Issue: ) ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- #NoEnv #Warn SendMode Input...

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

    atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment endings: eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  15. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    operation failed. -- SOLUTION: -- a) create a first derived columns task that checks if the column is blank and defaults a value (Replace current column if you like) (TRIM(Date)=="") ? "00000000" : TRIM(Date) -- b) then a second derived columns task...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    Created On: 26 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts] 'myDB.dbo.myTable',...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This defaults certain arguments to any prompt you submit. I don't really recommend this unless you're doing a batch of images which need to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 1 - 17 of 17