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

  1. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    and _thmbs when you supply a client key in the request. You do not need to pre-create those. Secure Access via GET All calls must include: name — the output file name without the extension url — the source image URL auth — your daily MD5 API key client...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  2. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    method to modify a record in a table in Joomla: // Create and populate an object. $user_record = new stdClass(); // Must be a valid primary key value. $user_record->id = 42; $user_record->name = 'Joel'; $user_record->username = 'jlipman'; // Update...

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

  3. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    seems to refer to it as) has most of the ever-changing data. Note how the impersonator is only added if it is not blank. It must not be included in the claim set if you have not yet had the service account authorized by a G-Suite Administrator (see 2b)....

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

  4. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    as a Flat File with fixed columns (Ragged Right). -- "Date" is the last column and can be blank in the source. -- "Date" must default to current date if blank for the target database (cannot be NULL). -- PROBLEM: -- assuming date could be blank (has...

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

  5. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    component. There may be error messages posted before this with more information about the failure. Why? So the solution must be obvious to you by now. At least that's what Microsoft people think to themselves every time they see the error they...

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

  6. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    Report 001 5 2 Report 002 11 47 Report 003 7 61 Multiple Datasets? Again NO that's what I have at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  7. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    is what improved our performance. -- If you can't find the person in your database in the top 100 of your search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob,...

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

  8. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  9. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    value FROM my_table WHERE my_id IN ('1, 2, 3') SELECT value FROM my_table WHERE my_id IN ('1', '2', '3') The Solution I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN...

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

  10. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    every day of the week and divide all the days activities into the morning and afternoon slots. All days and time slots must be listed irrespective of whether any time has been associated to them. We need to be able to specify any date, and the system...

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

  11. Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key (posted variables must be key1=value1&key2=value2...) Script #3: process returned data

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

  12. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...

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

  13. Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take effect. To set them, do this in your...

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

  14. SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/component/content/article/ssrs-report-builder-20-error-during-processing.html?catid=75&Itemid=165

    Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...

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

  15. SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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

  16. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  17. F_ck You. Pay Me.https://www.joellipman.com/articles/cms/website-development/fck-you-pay-me.html

    To be honest I saw this on some Joomlaworks Blog who appropriately title it "A must see for professional webdesigners". If you're a developer relying on clients for your income, then at least watch some of this. March 2011 San Francisco,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  18. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    (4) */ =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) /* Count the number of unique text and number values in cells B2:B10 (which must not contain blank cells) (7) */ =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) /* Count the number of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 21 - 38 of 38