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

  1. Cheat Sheet for mySQL vs t-SQLhttp://mail.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

    DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  2. Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) - LENGTH(REPLACE(LOWER(TRIM(a.title)), '.$sql_keyword.',\'\'))) /...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. SSRS Stop Scrolling Behindhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

    Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttp://mail.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    function send_request($url, $header, $data, $method="GET") { $ch = curl_init(); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    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 boolean. Returns false if a cell value has been formatted to a text type. Returns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Update 2025 A few more years and a few more systems...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    Sales Order Ref Name it whatever: eg. OnUserInput_ZBSoRef Put the following Deluge code: input.Attached_Files_in_CRM = false; Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    // // regex change dd/MM/yyyy to yyyy-MM-dd v_RegexdDate = v_TestDate.replaceAll("(\\d{2})/(\\d{2})/(\\d{4})","$3-$2-$1", false); info v_RegexdDate; info v_RegexdDate.toDate(); info v_RegexdDate.toString("E, d MMM yyyy"); info "*********************";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Creator / eBay: Get all Active Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    m_Params.put("ActiveList",m_ActiveList); // // exclude sold items m_SoldList = Map(); m_SoldList.put("Include","false"); m_Params.put("SoldList",m_SoldList); // // exclude unsold items (ended before purchase) m_UnsoldList = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Copy Subform to other Subformshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

    input.Fridays.insert(c_Friday); input.Saturdays.insert(c_Saturday); // // [OPTIONAL] Reset the decision box to false input.Copy_Monday_to_the_Other_Days = false; } The Result So now when I tick this decision box, I get something like the following:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD b_KeepOpen := false v_RunFolder := A_ScriptDir "\Run_" v_YourDate "_" A_Hour "-" A_Min ;...

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

    webhook topic/trigger if(m_ThisWebhook.get("topic").equalsIgnoreCase("orders/updated")) { b_RestoreOrderUpdateWebhook = false; } // // my app is the only one using the inventory_levels/update webhook topic/trigger...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    = r_DealDetails._details.output; // set all tabs to hidden ZDK.UI.getElementByID("Tab_SalesPipeline").setVisibility(false); ZDK.UI.getElementByID("Tab_HirePipeline").setVisibility(false); // depending on pipeline, show the tab if (v_DealPipeline ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Deluge - Get User Timezone, Country and Locationhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

    of Birmingham", "org": "The University of Birmingham", "as": "AS786 Jisc Services Limited", "asname": "JANET", "mobile": false, "proxy": false } List of Free APIs with GeoLocation services: Just append the IP address to the end of these to test....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  15. How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    your e-mail'); $link = JRoute::_('index.php?option=com_contact&view=contact&id='.$contact->slug.'&catid='.$contact->catslug, false); $this->setRedirect($link, $msg);

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. This file contains HTML or script code that may be erroneously interpreted by a web browserhttp://mail.joellipman.com/articles/web-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    file and add the following line shortly after the declaration of detectScript function: if ($extension === 'swf') return false; I put it straight after: function detectScript($file, $mime, $extension) { global $wgAllowTitlesInSVG;... That's all I do....

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  17. SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    the expression for visibility on the textbox should be something like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    Design Time when the component is added to the data flow public override DTSValidationStatus Validate() { bool pbCancel = false; IDTSInput100 input = ComponentMetaData.InputCollection[0]; string errorMsg1 = "Invalid datatype for {0}. Inputs must be...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  19. Android: Replace return key with done, go, send...http://mail.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

    { @Override public boolean onEditorAction(TextView v, int actionId, KeyEvent event) { boolean handled = false; if (actionId == EditorInfo.IME_ACTION_GO) { openMap(v); // do function on pressing the word GO handled = true; } return handled; } }); Other...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  20. Android OS: Add GoogleMap as fragmenthttp://mail.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

    savedInstanceState) { // inflate and return the layout View v = inflater.inflate(R.layout.activity_map_fragment, container, false); mMapView = (MapView) v.findViewById(R.id.mapView); mMapView.onCreate(savedInstanceState); mMapView.onResume();// needed...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
Results 21 - 40 of 63

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.