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

  1. Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive/zoho-workdrive-getting-team-folder-id.html

    6 - View 5 - Edit 3 - Organize 7 - Upload Error(s) Encountered: When updating members to a workdrive, I was getting errors such as 2945 Invalid JSON 2945 Invalid JSON for each v_RecipientEmail in l_WorkdriveRecipients { m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Workdrive
    • Language: *
  2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    When the end customer clicks on either button in their email (at least in a web-based email client such as outlook or Gmail), they should get something like the following: Your staff will, of course, see the estimate status as accepted or declined in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    REST API with a custom app. Note that this is not for an app embedded in the Shopify instance but for a third-party app, such as a Zoho Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. RocketTheme's Affinity July 2009 Releasedhttps://www.joellipman.com/articles/cms/joomla/rocketthemes-affinity-july-2009-released.html

    July 2009 release from RocketTheme and features extensive third party support for powerful and popular community products, such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement of modular rows,...

    • Type: Article
    • Author: Webmaster
    • Category: Joomla
    • Language: *
  5. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    this mysql user has been granted all privileges (change this after a successful install and remove system privileges such as "drop table"). Upload the compressed file to your http://www.mysite.com/ web root folder and extract the zip to it (it should...

    • 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

    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 JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by Joomlaworks but if you did the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Could not instantiate mail functionhttps://www.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    be in the /etc/virtual/domainowners file. 4) The hostname must resolve. If not, add the required A records to the dns zone such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not contain...

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

    means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value 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)....

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

    applied: eg. "Andrew Lloyd-Webber", "Marketing Manager (Acting)", "Lipman***Test" or "R&D". As well as alphanumeric values such as "Flat 4B", "Suite 4899A", "123A Myhouse". Example #2: Using as a Custom Script Component The above will work as a SSIS...

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

    account to retrieve the image. So here's my checklist: Test adding an external image that doesn't need credentials (such as Google's logo @ http://www.google.co.uk/images/srpr/logo3w.png) Test disabling the "Unattended User Account" and seeing if...

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

    If this bugs you, you can always include a custom message which displays on top if all 4 parameters are equal to ""; such as the instructions on selecting a dropdown option. :c) Searches that didn't get me very far ssrs dropdown to allow null value ssrs...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images to be used in...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    Note that any data on the USB pen is automatically lost, and that if you use rescue programs, you may corrupt the pen in such that a way that you would need to return it to the manufacturer.

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  14. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Returned a data type that is not validhttps://www.joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    studio, you can specify in the report designer how to format the returned value to a more user-friendly date format (such as Month name then year - eg. November 2010). I have been told that data types are a nightmare in SQL Server Reporting Services and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    has to refresh the page, make a change, upload, etc. well it's beyond a joke and no one should waste their time with such companies.

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  20. Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    another database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 41 - 60 of 68