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

  1. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    } } } Source(s): Zoho Books Documentation / Update Billing Address Zoho Community / Zoho Inventory / General / Error: Please ensure that the billing_address has less than 100 characters

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    for myself' }], subject: 'Greetings from the Joel Lipman team!', body: 'Hi there! I\'m the very model of a modern major general. Bye. the Team.' }); } } } catch (e) { // return error (don't display it, just show it in the logs) console.log(e);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    Survey)" r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" WHERE p."Title" 'GENERAL' ORDER BY "Response Date" DESC, "Attempt ID", "Page Number", "Question Number" You can take out the order by clause. I just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  4. Language Codeshttps://joellipman.com/articles/cms/joomla/language-codes.html

    started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English speakers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    User - Profile - JoelLipman.Com Joel Lipman April 2011 (C) 2011 JoelLipman.Com. All rights reserved. GNU General Public License version 2 or later; see LICENSE.txt info@joellipman.com www.joellipman.com 1.6.0 PLG_USER_PROFILE5_XML_DESCRIPTION...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that...

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

    User Group Mappings from old DB to new DB: Other than new admin (here new admin ID is 111, previous admin ID is 222, and general information desk account is 333), remove other super admins (optional) I also noted the previous admin's ID and returned...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    your old phone's iOS is fully updated. (I did this while the phone was NOT connected to the computer, ie via the Settings > General > Software > Update option) Right-click on your iTunes shortcut and select "Run as Administrator". Plug both phones into...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  9. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    Check: The problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not understanding the last two characters...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    container (or drag into the container if it already exists) Edit the ForEach Loop Container (or double-click on it) Under General, give it a reasonable name of your choice Under Collection, select as Enumerator the "Foreach File Enumerator" Select the...

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

    AS ItemID FROM ExecutionLogStorage ) AS d1 ORDER BY d1.Name ASC Additional Modifications: For all Parameters: » General - Untick "allow blank value" and "allow null value" (so these checkboxes are empty). » Available Values - "Get values from a query" =...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  12. How to change local folder for TFShttps://joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    So? Once installed, my BIDS install would continuously check-out files and store these in the home directory. I tried the general settings (Tools > Options) but to no avail. How? The way to change this was: Connect to your Team Foundation Server (for me...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *
  13. Windows 10: Shortcut Apps to Settingshttps://joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Feedback & Diagnostics ms-settings:privacy-feedback File system ms-settings:privacy-broadfilesystemaccess General ms-settings:privacy-general Inking & Typing ms-settings:privacy-speechtyping Location ms-settings:privacy-location Messaging...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  15. Returned a data type that is not validhttps://joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

    I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  16. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE Latin1_General_CS_AS FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail...

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

    in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    // add the following to your header This does nothing: // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  19. Is it a scam? Gumtree.com's warning signshttps://joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    to get you to pay money upfront. Remember, be wary of overseas sellers. Source: http://gumtree.force.com/Help/articles/General_Information/Warning-signs

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  20. Changing the yourdomain.com for phpBB3https://joellipman.com/articles/cms/joomla/changing-the-yourdomaincom-for-phpbb3.html

    of renaming yourdomain.com as your title page in phpBB3. You need to login to the phpBB admin control panel (ACP). On the General tab, look under Board Configuration and click on 'Board Settings'. The Site name is the first field in the right panel.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 21 - 40 of 41