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

  1. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was getting the error INVALID_DATA with the details being api_name:'data'... But this is shortcode, not an invokeURL. {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    */ Considering that neither the color code nor ID were necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's...

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

    Took us a while to find this and perhaps others would have a quicker way but here's 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...

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

    url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat fixed;} Click on the 'Save' button. The theme is getting it from a generated php file. Look in the CSS folder of the template. You should find a PHP file in this folder with the...

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

    Are you getting a lot of spam, or junk messages sent via your Joomla site? I know certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    rather than the other intelligent solutions on the web. The issue was that I was building my first Joomla 1.5 component and getting the below error if I put in a menu: Warning: implode() [function.implode]: Invalid arguments passed in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep getting complaints that my server wants to upgrade my PHP v7.x to PHP v8.x. I also get complaints (from my server not from humans)...

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

    as gotten your OAuth 2.0 access/refresh tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  10. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    Just in case: AndroidManifest.xml The example above should have populated this correctly but if you are still getting problems, I have the following fields that I also use related to Google Maps v2: Last Additional Ensure that when Google asks for your...

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

    a cheat/workaround: Click on the list to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  12. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    parameters were not resetting to blank after the report was run. End-Users were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares against the...

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

    uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are provided over an authenticated URL (You shouldn't be having any issues with this...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  14. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    program launcher StackOverflow: Need to elevate permissions without UAC pop ups How to Run Programs Elevated Without Getting the UAC Prompt Vista setuid – How to elevate without prompting Further Notes Location of Windows 7 Taskbar shortcuts (Pinned):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    asked it to return the full date of the parameter, this is because I will format it via the text-box properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...). You will need this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    FROM [dbo].[XML_EVENTS] Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let $j:= $i where ($j/@ID)

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. FTP on Mac: Failed to retrieve directory listinghttps://www.joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    note to remind me how to enable FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: Failed to retrieve directory listing though I could access the folders if I browsed the existing folders by...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  20. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    of DOT, EOT and TOT Your target database table should now be populated... » Read the below "Testing" steps if you aren't getting a result :) Testing: Manual export of XET Run the relevant screen (in our demo this is Application Clearance Decision (ACD))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 41 - 60 of 69