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

  1. SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

    text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing zeros -- "00000" because we don't expect strings to exceed 5 characters. The Oracle Error Value Returning just the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  2. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

    of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    query will return data using the student ID number found in the first query. The stored procedure compiles successfully and without any warnings. So What? The problem is that if the student does not have a username but has an ID number, then the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  4. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an entire database for a particular string of word(s)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  5. Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

    rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000'); or The Unique ID code would be "3sv7MUqXeMI" (without the double-quotes) How to do this without using this extension: Visit the website http://revolvermaps.com/?target=setup...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    problem? How? Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the possibility to cancel (link not working!?) and eventually would display circa 3000 matching results. If I attempted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

    from api.joellipman.com (my own personal website). This allows me to continually add data to the api of my own website without needing to redistribute or update this app. {youtube}fQD0xVEYDks{/youtube} Location: For location, type a city name, post...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

    0,0 (might be different on your setup)... Note that removing the width and height parameters should simply load the app without resizing it to the maximum width/height of the screen. Windows 10 Mail Lastly: Want to start a built-in app in Windows 10...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

    of Zoho Creator and could be seen as a 'Pure CSS' feature. I'm aiming to make a list of capabilities that can be done without loading another framework considering that Zoho Creator has their own version of Bootstrap and jQuery. This is the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    a webhook) to my CRM REST API function. The following includes UserDeliveryPreferenceArray but I've successfully subscribed without this. I'm just including it because I want to be notified if feedback is left: OAuth Method (requires contacting eBay to...

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

    downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without using any other apps or software. How? Here's how to use it: Staff member clicks on button File downloads to their...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    the client comes back and says things like "can we add this?", "can it say this instead?", "can it be in a bigger font?"... without pushing back too much, it can end up looking like those old websites with HTML tables. We're going to use a HTML table...

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

    There was nothing wrong with the date time format here. Just that I was submitting a TRIGGER=DATE-TIME but without the correct additional parameters omitted/needed (in my case the UNTIL given a CRM/Atom date time format)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

    in the Zoho Analytics image library but you would need images either uploaded in Analytics or a publicly accessible image without a user wall. Pre-amble Have all the images you want to use ready for uploading into the system stored on your device. A URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

    so a contact email OR phone number is required. Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo purposes: If I enter a phone number: If I enter...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    for me or for whoever dares to upgrade their Joomla CMS from version 3 to version 5. Disclaimer: I'm used to doing this without any third-party extensions. I strongly recommend you do a backup beforehand of the database and of all your files Why? I keep...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

    already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to try it without a canvas to see if we can have this functionality using the out-of-the-box ZohoCRM. Client Script Configuration: Login to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

    on such information is therefore strictly at your own risk. In no event will we be liable for any loss or damage including without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from loss of data or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  19. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    is setup to do this:...... The form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  20. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I wanted to make it bit more in-depth for this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 21 - 40 of 123

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.