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

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

    l_RecordsToSend.add(m_UpdateQuote); m_Data = Map(); m_Data.put("data",l_RecordsToSend); // // this is REST API so by default all triggers run. Use an empty list to stop or prevent these from triggering. m_Data.put("trigger",List()); v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    this solved the problem of redirecting the user after they complete the contact form: If you were wondering how to get the default contact form in Joomla 1.5 to redirect you to another page after you submit it, or if you wanted to change the default...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    of your pages submitting content containing your banned words. We're going to modify a file containing 2 lines of code by default. The file is index2.php in your Joomla root folder. Make a copy of it, back it up or do whatever you usually do when you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    “Search” button. What displays in the search results should be the text that the system emails out on password change. The default if you’ve lost it is as below (exclude the double-quotes): “Hello,\n\nA request has been made to reset your %s account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    Use the following shortcuts in the address bar: Type a search term, then press Enter. Performs a search using your default search engine. Type a search engine keyword, pressSpace, then Tab when prompted, type a search term, and press Enter. Performs a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  6. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio). How? Note that the restore can be done when the new phone prompts...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  7. 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

    in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't work)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  9. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    is an excerpt from http://www.howtogeek.com/howto/windows-vista/dealing-with-windows-vista-time-sync-problems/ Change the Default Update Interval If your clock is constantly out of sync even though it says the sync was successful, the problem could be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  10. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    Select Win32 > standalone > ie6eolas_nt.zip Download the ZIP file Scan for threats Decompress/Extract to a folder (by default it will create one separate to the default C:\Program Files\Internet Explorer). Scan for threats Run "C:\Program Files\Internet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)". If there isn't create a New "String Value", name it "(Default)" Double-click this string value and type the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    X @GenerateSQLOnly -- Provide 1 if you only want to generate the SQL statements without seraching the database. By default it is 0 and it will search. Samples : 1. To search data in a table EXEC SearchTables @Tablenames = 'T1' ,@SearchStr = '%TEST%' The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  13. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....

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

    of a expanded node. (despite no line separator or the totalled value in the corresponding row) Show this week date range by default Use a WHERE clause: YEARWEEK(s.DateTimeCreated,1)=(YEARWEEK(NOW(),1)) Note the ,1 parameter is because our weeks start on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  15. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    2.1 Personal Edition - Fixed Bug: Order By Date - Fixed Bug: Order in descending/ascending order - Enhancement: Changed default settings (matches personal site) - IMPORTANT: Cannot use "Public" usergroup to generate images!!! - Date Uploaded: Fri, 21st...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  16. Passwords: Did-you-knowhttps://www.joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    computers on earth, recently reached a speed of 76.1 billion passwords per second! (source: Lockdown.co.uk 01/2007) By default, the Mozilla Firefox browser lists your stored passwords in plain text to anyone with access to your browser through the tools...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  17. Zoho CRM: Update Opportunity Type as New or Existing Businesshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-opportunity-type-as-new-or-existing-business.html

    Customization > Modules and Fields > Accounts > Layout (Standard) Add a checkbox field called "Has Won a Deal" (unticked by default) Go to Setup > Customization > Modules and Fields > Sales Orders > Layout (Standard) Add a checkbox field called "Account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    Choose Menu > Main Menu from the pulldown menus. Click on the Home item's name (or whatever item happens to be your default frontpage item, can't be an article). Click on the menu Parameters - Advanced on the right. Set the Category Order to No. Order...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    v_FromTime = zoho.currenttime.subMinutes(v_MinutesAgo).toLong(); v_TillTime = zoho.currenttime.toLong() / 1000; // // by default gets last 100 messages (doesn't return anything if no parameters specified) v_Endpoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  20. 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: *
Results 41 - 60 of 124