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

  1. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well...

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

    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 entering it in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  3. Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    A quick article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  5. SITS: Export field code and namehttps://joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

    Using &G[COD.SRS:•|•] -- also yields: The code is not blank. Doing the above, we have no way of telling whether the lookup failed or if this student does not have this field populated. What if we want the system to say if the field was populated but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  6. Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

    article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zoho People as their new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

    I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  8. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error...

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

    Backup for Joomla > Control Panel > Configuration Wizard > Backup Now Adding articles in Administrator interface: Save failed with the following error: Invalid parent ID. Asset ID is incorrect... Categories > Clear Filter Options > Show All > Tick to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    Programs which I would NOT recommend I've put a list of programs which I installed and uninstalled just as quickly as they failed to properly reflect IE6 and IE8 features (& bugs?). IECollection v1.6.0.6 Multiple IE Installer v? (Old and unstable...)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Error during processing - Converting Date/Timehttps://joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

    An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  13. CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

    width as shown in the following picture: And I want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the div layer the same as the image and positioning the div. This causes a scrollbar at the bottom....

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  14. Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    of whether I have PHP mail or sendmail set as the Mailer. Notice Could not execute: /usr/sbin/sendmail Warning Registration failed: An error was encountered while sending the registration email. A message has been sent to the administrator of this site....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

    permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Can apparently be solved by adding this to the top of your web.config file. Searches that got me nowhere ssrs check if file...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

    SSRS process both the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). The Workaround I want to avoid the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

    IP address - Display flushdns errorlevel - Display registerdns errorlevel - Change color to green if successful, red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

    points for Directories. /XJF :: eXclude Junction points for Files. :: :: Retry Options : :: /R:n :: number of Retries on failed copies: default 1 million. /W:n :: Wait time between retries: default is 30 seconds. /REG :: Save /R:n and /W:n in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  19. SSIS Multiple Lookups in onehttps://joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

    "Lookup Match Output" as rows with neither sequence nor student reference will not come through the system. Lookups that failed will return as NULL. Selecting the fields to output into the data-flow: sequenceID student_reference student_title_code...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    Phoca Download text - Exclusion list is now case-sensitive (for International character support). - Fixed bug: compilation failed for servers not supporting international characters. - Fixed bug: replaced string formatting foreach statements with legacy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
Results 1 - 20 of 26

Please publish modules in offcanvas position.