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

  1. Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

    putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...

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

  2. Convert a delimited string to tablehttps://www.joellipman.com/articles/database/convert-a-delimited-string-to-table.html

    ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET...

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

  3. Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

    What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  4. A for loop within a for loop in MS-DOShttps://www.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

    DO FOR /F "tokens=1,2* delims=." %%I IN ('ECHO %%A') DO ECHO %%I -- yields: 123 456 So Job done. Chances are you need to use this variable a little more: @ECHO OFF FOR /F "tokens=2,3* delims=_" %%A IN ('DIR InitializingFile*') DO FOR /F "tokens=1,2*...

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

  5. MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

    Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need to be multiplied by 1 to convert to a number but what a palava!

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

  6. SSRS Border Problemhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-border-problem.html

    "Properties" pane, find the "BorderStyle" and type the word "None" next to it (as its value). Press the "Enter" key if you need to. You are now free to apply normal borders to each specific cell.

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

  7. CSV Chart Generatorhttps://www.joellipman.com/component/content/article/csv-chart-generator.html?catid=40

    as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself don't put any copyright information on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  8. MySQL Transactions in PHPhttps://www.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

    of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' =...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB

  9. Display a thumbnail of a Google Drive videohttps://www.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

    a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below but then this is a redirect to the actual thumbnail stored by Google...

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

  10. Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

    Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child tags of the table specifying the above CSS.

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

  11. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

    article. Though writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int...

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

  12. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients)...

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

  13. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search engine to also ignore permissions so that the article can still be indexed in global search engines...

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

  14. Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

    the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 261 - 274 of 274

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

Joes Word Cloud

Please publish modules in offcanvas position.