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

  1. 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

    obviously I can't give you the real Zoho Deluge function here as it would use my credentials but what you need to know is that it is passed the crmAPIRequest (string) variable and that the function itself had to have API Key and OAuth enabled (hover...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    to it the fields "Response ID", "Survey ID", "Scheduled Report Generation Time" Save and close the CRM function You should know how to set up a CRM function as a REST API function but here goes a quick recap: Login to ZohoCRM as a user who has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    Thought I already had an article on this and I know my article Zoho Deluge - Connect to Xero API covered a quick query to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a...

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

    an article and a contact page, but it should work for most other page redirects as well. Step Two: Next if you don't already know the URL of the page you want to redirect to, you will create a menu item in the Joomla 1.5 admin interface that points...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    are very vague so I wanted to make it bit more in-depth for this specific use. I'd love to hear if this helps you. Let me know if you find any mistakes and I'll be sure to fix asap. To hide buttons on your site for users that are logged in do the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    display or not on the front page so again not any use to sort by this) checked_out_time => just cos this value exists, don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor...

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

    to them. Prepare for Go Live This migration script is not a silver bullet. It was created to take away the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    Row Result - loadRow() This type of query is for when you want any of the values from one resulting row. You will need to know the column order the results are returned in. $db = JFactory::getDbo(); $query = $db->getQuery(true);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    to satisfaction... not bad for an hours work. So I've heard it mentioned before, never thought much of it, but now I know. The lesson here is simply to Update the Joomla Core separately and prior to any 3rd-party extensions If you didn't have a backup,...

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

    completion and if paragraph 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  11. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you didn't write or know what they're doing. Why? The objective here is to upload a video file to my Google Drive. This assumes you have already...

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

    iOS: Transferring information from your current iPhone, iPad, or 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)....

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

    open (eg. "http://your_sharepoint_server_name/Lists/your_list_name/Allitemsg.aspx") Select the name of your list (I know I thought we already did this but hey ho) Select the fields of this list you want to use (only really need ID and Name or just the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  14. SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    will be returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  15. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know of other ways to resolve this, I would be the first to be interested in how...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  16. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    - Value Before: {1} - Value After: {2}", x, inputValue, outputValue); debugString = ""; // blanking because I only need to know when it fails // set input value to transformed value buffer.SetString(inputBufferColumnIdx[x], outputValue); } // Log Debug...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  17. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks of trying to find a solution, I would definitely recommend seeing if you can't check at the database...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  18. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports results side by side. To do this, I had to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. 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

    without working out how to use these in SSRS and then resorted to my old methods of debugging. For those of you who don't know what a cursor is, you can find this info on another site as this article focuses on getting an Oracle stored procedure to work...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 41 - 60 of 80