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

  1. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    $CLIENT_SECRET = ''; // expecting alphanumeric string $STORE_PATH = ''; // expecting *.json - needs to be writeable by system account $SCOPES = array($GAPIS_AUTH . 'userinfo.email', $GAPIS_AUTH . 'userinfo.profile'); // add in your other scopes as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  2. Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    Right-click on the "Computer" icon/label (desktop / start menu) Select Properties Click on Change settings or Advanced system settings Select the Advanced tab Click on the Environment Variables... button Under "System variables" find the PATH variable...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  3. SSIS Multiple Lookups in onehttps://www.joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment and features found inside the...

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

    to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  6. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Connectors from dev.MySQL.com .NET Framework Data Provider for OLE DB Type: .NET Framework Wrapper Class Library Usage: System.Data.OleDb.OleDbConnection Manufacturer: Microsoft Bridging to MySQL OLEDB This is just one connection string sample for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  7. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    PC 2007 SP1 (http://www.microsoft.com/downloads/details.aspx?FamilyId=28C97D22-6EB8-4A09-A7F7-F6C7A1F000B5&displaylang=en). System Requirements: Virtual PC 2007 requires a 400 MHz Pentium-compatible processor (1.0 GHz or faster recommended), and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  8. Print Directory Contents to a Filehttps://www.joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    "Command prompt from here" option (now built-in to Windows 7). I added this option for him in Windows 7 Ultimate using the system registry (see "How: for Windows 7" below). -- yield a_subfolder_in_this_folder a_file_in_this_folder.txt...

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

    Eye tracker ms-settings:privacy-eyetracker Feedback & Diagnostics ms-settings:privacy-feedback File system ms-settings:privacy-broadfilesystemaccess General ms-settings:privacy-general Inking & Typing ms-settings:privacy-speechtyping Location...

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

    ( SELECT '[' + SC.name + ']' + ' LIKE ''' + @SearchStr + ''' OR ' + CHAR(10) FROM SYS.columns SC JOIN SYS.types STy ON STy.system_type_id = SC.system_type_id AND STy.user_type_id =SC.user_type_id WHERE STY.name in ('varchar','char','nvarchar','nchar')...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the performance and database load. Before: StudentID StudentName DateOfBirth -----------...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  12. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Delete related records from multiple tableshttps://www.joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause...

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

    your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  16. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/component/content/article/is-it-a-scam-gumtreecoms-warning-signs.html?catid=116&Itemid=165

    that claims to be from «CompanyName», eBay, PayPal or another company and offers buyer protection or an online payment system. This could be directly in connection with a transaction through someone you’ve met online. Or perhaps the buyer or seller...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  17. Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and CPU speeds Reduce visual effects for increased performance during troubleshooting Note background and visual...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  18. Proposed Budget i3 PC under £200https://www.joellipman.com/component/content/article/proposed-budget-i3-pc-under-200.html?catid=116&Itemid=165

    but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  19. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  20. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
Results 61 - 80 of 169