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

  1. Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

    and never manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a...

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

    programmed in. Apparently this problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing with any empty rows. The...

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

    to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    Anything not ending in ".html" will simply return a 404 error. I've included my error rules (they basically redirect to a branded error page). So I sanitize on the receiving index.php file: Check for possible Code Injection Do NOT allow the use of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  5. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://www.joellipman.com/articles/apple/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    Plug both phones into the computer. In iTunes, right-click on the old phone and select "Transfer Purchases". (you will need to know your Apple ID password) Under the "Summary" tab, in the "Backups" section, click on "This computer" and tick the "Encrypt...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  6. Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

    8:30 37:45 2013-12-07 Saturday - - - - 0:00 37:45 2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45 Some Requirements; StartTime will be the earliest someone starts work that day. EndTime will be the latest someone works that day. Time is recorded by tasks...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  7. Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

    with this one because if you copy the formula down, it may automatically modify the range. So the formula in the first row will be =COUNTIF(A2:A100, B2) but the formula in the second row will be =COUNTIF(A3:A101, B3): =COUNTIF(A2:A100, B2) -- Returns 1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  8. JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

    v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

    for the user registration form. I installed it but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

    and then click File > Unload Hive > Yes (prompt). Close the registry editor, then restart the computer. Notes: Guest account will not see the drive in Windows Explorer but can still access it using the command prompt. All users can access the drive...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  11. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

    for the user registration form. I installed it but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  12. SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

    name exist in the database, this works accordingly. If however, for some reason the code does not exist the code lookup will fail: -- If CODE=0000 and 0000 does not exist in table to lookup name, -- Using &G[COD.SRS:•|•] -- yields: -- But if CODE is not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  13. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

    search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find the value of the checkbox by viewing the HTML...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  14. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

    local images if they exist. (Note: This retrieves thumbnail from a service and stores this on your server) - Warning: Images will reset if you specify a different image type (default is PNG) (eg. PNG to JPG -> means module has to re-download thumbnails...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  15. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

    in your browser and note the last string in the URL. So in https://drive.google.com/drive/folders/, the value where "" sits will be your folder ID. $GAPIS = 'https://www.googleapis.com/'; function uploadFile($access_token, $file, $mime_type, $name,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  16. CSS Printing - Page Break Inside with Headers and Footershttps://www.joellipman.com/articles/web-development/css/css-printing-page-break-inside-with-headers-and-footers.html

    next page has a table which is of variable length. Fine when the table was short and didn't have many rows. But the client will pick up the phone to you when the table has too many rows to fit on one page, and this overlaps onto the next, covering the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  17. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    | \----------|-------------------|----------------------/ the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  18. Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

    if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  19. Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

    case, we needed to check on the expiry of an access token used in OAuth2.0 for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

    create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value. // What I have in CRM:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 161 - 180 of 354

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.