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

  1. Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-your-statement-execution-limit.html

    of the limit or an upgrade to the subscription will likely to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    m_ZCrm_ZSDoc.put("zohosign__Module_Record_ID",p_ContactID.toString()); m_ZCrm_ZSDoc.put("zohosign__Document_Deadline",zoho.currentdate.addDay(15)); m_ZCrm_ZSDoc.put("zohosign__Document_Status","Out for Signature"); // Request_ID is a custom field added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    Null is FALSE ---------------------- Value of TEST is NULL isBlank Preceding is TRUE isBlank Succeeding is FALSE: Error at line : 57, Value is empty and 'isBlank' function cannot be applied isNull Preceding is TRUE isNull Succeeding is TRUE Equals Blank...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    the credit information about a company. Unfortunately, if you do this simply using Zoho Deluge in a button, there are no new lines/carriage returns or styling that you can apply, which pops up as a message box to the sales person; but all on one line...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and the documentation seems to have gaps; or simply modules are so custom/bespoke the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  6. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    Open Banking connection that replaces the old Yodlee and Plaid labels. Follow the prompts to log in securely via your online banking and authorise Zoho Books. Once redirected back, link the feed to the existing account (rather than creating a new one)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  7. Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

    for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Using K2 with jezReCaptcha plugin causing errorshttps://www.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

    ) in /public_html/components/com_k2/lib/recaptchalib.php on line 67 I've managed to fix this in my site. Because you already force the recaptcha feature in your registration form and contact form (on this website I just went recaptcha-happy), then there...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    work but if not click on "Rebuild" Issues I ran into joomla Fatal error: Call to a member function getPath categories.php on line 435 I haven't found a way to automate this yet but you can fix all of these in one go by logging into your Joomla! 1.6.0...

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

    have never seen in any other system. I've googled and binged but could not find anything that documents how to bring it into line with other search systems. So here we go, hope this helps you. Why? I've created search systems for a plethora of other...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

    the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php file in the root folder of your component (ie. same as the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    and table prefix of database you are WRITING to (eg. `myuser_joellipmancom_mysitedb`.`ejf1r_content`) How? Here's a brief outline of the whole process: Backups Install Users Categories -- unstable Content Weblinks 3rd-party: JComments Here's a less...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  13. 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

    install ffmpeg Extract audio: ffmpeg -i your_video.mp4 -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI Whisper] Split audio into segments: ffmpeg -i output_audio.mp3 -f segment -segment_time 600 -c copy...

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

    Known Issues [Convert Date [4228]] Error: An error occurred while attempting to perform a type cast. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Convert Date" (4228) failed with error code...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  15. Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    Add a condition to the WHERE clause Specify that the field name in the series fields is not blank So I've added the AND line to the above statement yielding: SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    ExecutionLogStorage.TimeStart), DATEPART(year, ExecutionLogStorage.TimeStart), Catalog.Name Chart-wise: create a line chart [Sum(Counter)] will be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  17. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/convert-to-proper-case-in-t-sql.html

    Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this. Original Proper-Cased JOHN SMITH-JONES John Smith-Jones HEAD OF IT SERVICES Head of IT Services...

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

    Limitations of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT the sum 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:...

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

    with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later....

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

    display function search_return_keywords($str) { $search = array ( '@ @si', // Strip out javascript '@ @si', // Strip out Inline Stylesheets '@[{].*?[}]@si', // Strip out Internal Joomla Curly Brackets commands? '@@si', // Strip out HTML tags...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 101 - 120 of 130