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

  1. Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

    note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  2. 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

    I have a PHP script which behaves like PhpMyAdmin, 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  3. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

    list of all the IP ranges and their allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love Advanced Web...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  4. Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

    other scripts but do I really need a complex solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  6. Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of "Academic Week" and instead expands to the width of the word "Academic". What I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  8. Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    This doesn't have much affect on point-to-point conversions and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of...

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  9. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

    116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  10. Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

    A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

    So this is supposed to be a quick article detailing how I used a PHP function to upload a video file to Google Drive. Note that this example does not involve installing the Google Client Library for PHP. So no classes or built-in functions that you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  12. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

    » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  13. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number... well it's not really random, it involves getting the milliseconds from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

    Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice templates and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  16. Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

    This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales order to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  18. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary CRM modules called a "LinkingModule" (as opposed to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    backend code, Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of this article for you which we tried to use but only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 201 - 220 of 491

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.