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

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

    value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  2. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

    only have DVI and VGA inputs. The 3 Dell monitors can daisy chain with a combination of DisplayPorts and Mini-DisplayPort, which means that only 1 DisplayPort cable needs to go the PC. They also have 1 HDMI input. The NZXT Z490 Motherboard I have only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *

  3. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in ZohoCRM). For example "5a4bed37590588baa5fc272219e8e553_image001.jpg" for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    here we are. Code is our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a function which will simultaneously create a task with a reminder both on popup and email which repeats every day until an end date. We then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • 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

    phpBB3 installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the phpBB3 system. For installation purposes, this mysql user has been granted all privileges (change...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  6. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    If you need to remove files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  7. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

    just use Virtual PC with Windows7 but my customers are on XP and I have to emulate their environment as accurately as I can which I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  8. Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    (there will be some but this script has been reworked to potentially accommodate). Download my migration script Decide on which script to use: If you have a small site (less than 10'000 articles), then you will use the single script...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  9. SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which kinda defeats the purpose of having anything there. I want my end-users to have faith in my report. The report just returning...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  10. Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

    website. It was very plain and basic, needed tweaking to get rid of adverts and to integrate with a website's template which could be quite tiring. Following the crash, database performance was at an all time low and analysis revealed it be incorrectly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  11. SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  12. Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

    based for non-technical staff. Web-based for remote working.) JoelLipman.Com will create 2 development sites ("play" sites) which the project manager and his/her team can use to experiment and test. Once the production website is finalised, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *

  13. SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

    do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  14. MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

    A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes. Why? It's similar to javascript's message box or confirm box, only Android let's you redesign the dialog. For my purposes I have used an XML as...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *

  15. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

    This tells me the alias is "myexampleapp" for this keystore and the SHA1 to add to google which would be: B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD;com.mydomain.myappname * In the above, if you have specified the correct bin folder in...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *

  16. Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

    text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB

  17. CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before { opacity:0; content: ''; transition: all 1s ease; transition-property:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  18. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

    to set up a custom domain for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  19. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some clients have referred to this as the "spinning circle of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *

  20. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://www.joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

    helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? As mentioned, we're going to update several fields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 325

Joes Word Cloud

Please publish modules in offcanvas position.