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

  1. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste list ******************************************************************************* */ // init v_Output =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the title. \plugins\search\content\content.php:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to some popular LLMs: [Score: 7/10] I gave the transcript.txt file (all lowercase no punctuation) to Google's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  4. Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the...

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

    + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  6. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a memorable name (eg. "Print Directory Contents To File") Application: - Type the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  8. Apple Magic Trackpad with Windows 11 Intelhttps://www.joellipman.com/component/content/article/apple-magic-trackpad-with-windows-11-intel.html?catid=80&Itemid=165

    see a Magic Trackpad - but not connected. Try switching the trackpad on and off and pair it up again but bear in mind to give it a few seconds to reconnect. If it still doesn't work, I had to repeat the preivous step of installing the driver and wait a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    do I get the milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  10. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  11. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Development Studio (BIDS) Right-click on "Shared Data Sources" in the Solution Explorer > select "Add New Data Source" Give the DataSource1 a more memorable name Click on the "Edit..." button Click on the "Change..." button Select "ODBC" and click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    for most SQL forms). I found that to add further tables, simply start with another "UNION ALL" clause with a note to give the 3rd table a different alias to the 2nd (so "C" instead of "B"): SELECT title, intro FROM ( SELECT `title`, `introtext` intro...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have added a LIMIT to only return the top 50 words. Source(s): Counting...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  14. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  15. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to indicate to the user to enter their...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  16. Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  17. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  19. SharePoint 2007: Change profile picture with minimal permissionshttps://www.joellipman.com/component/content/article/sharepoint-2007-change-profile-picture-with-minimal-permissions.html?catid=77&Itemid=165

    without being allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg....

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
Results 61 - 79 of 79