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

  1. 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
  2. Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/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
  3. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

    (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
  4. SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    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/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

    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. Generate a Timesheet in MySQL https://www.joellipman.com/articles/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: *
  7. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    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. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to country) rules are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

    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: *
  10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    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
  11. Excel - Check a column for values found in another columnhttps://www.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    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
  12. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

    records. As I'm listing errors encountered, I'm adding it to this list. If submitting the headers as an array, note that it must NOT be an associative array: // this won't work $a_Header['Authorization'] = "Zoho-oauthtoken " . $v_AccessToken;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  13. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    // // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email == v_ResultEmail && File_Ref == v_ThisFileCrmID]; if(r_CreatorFile.count()>0) { if(!isnull(r_CreatorFile.File_Download)) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    It is important that this field will never be hidden (it cannot be seen on the front-end of the application but it must not be removed by Creator). If you know the code to remove this field, then you know what I mean. In Workflow mode: add a workflow to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

    CSV file and then having it emailed to anyone is an easy task but here we cannot have that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify...

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

    to trigger the reminder. Example: 2020-05-01T12:28:00+05:30. TRIGGER=TIME (hh:mm): 24-hour time format at which the system must trigger the reminder. Example: 23:45 Triggers can be given based on due date. For instance, if you want the reminder to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/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: Zoho
    • Language: *
Results 21 - 38 of 38

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.