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

  1. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

    As documented in an earlier article, put the URL of the image, then change it's format to show the image and not the URL text. In this example, we are using images uploaded in the Zoho Analytics image library but you would need images either uploaded in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Outputting PHP files into different file formatshttps://joellipman.com/articles/web-development/php/outputting-php-files-into-different-file-formats.html

    I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  3. MS Excel - Open CSV with Long Numbershttps://joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

    1.4571E+18 Stanley 1709123456 1.4571E+18 1.4571E+18 David 3.31235E+11 1.4571E+18 How? Firstly, save the CSV file as text file (*.TXT). This will stop MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

    time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Windows Live Messenger: Error 80048820https://joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

    time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a different server from the dropdown If you get the text The clock...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  6. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE temp_str text DEFAULT ''; -- temporary string holder DECLARE temp_val VARCHAR(255)...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Print Directory Contents to a Filehttps://joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

    A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

    events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input field for single line of text. name="name" - attribute that...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  10. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select('...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  11. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table with this data. Note that this only works if all the text files to be used...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  13. MessageBox or AlertDialog in Android Javahttps://joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

    out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML layout Set the hint text of a specific user input field (EditText) Store the input in a TextView (invisible or visible) held in the calling XML /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  14. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type: text/javascript'); header('Access-Control-Allow-Origin: http://api.joellipman.com/'); header('Access-Control-Max-Age: 3628800');...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

    (for Cyrillic support). - Date Uploaded: Tue, 11th Jan 2011 1.4.2- Added Joomla! Admin Option: Include Phoca Download text - Exclusion list is now case-sensitive (for International character support). - Fixed bug: compilation failed for servers not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  16. Accessing Apimo WebService APIhttps://joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

    $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header header("Content-Type:text/xml"); // print result to page echo $output; } Advanced Example Here's a complete PHP script of a more complex example of 1)...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  17. Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    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 true if the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  18. Zoho Creator: Populate a Multi-Lookuphttps://joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

    This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    module Job Opening: Lookup to the Job Opening module (called "Vacancies" in client's system) Candidate Ref: A single line text field Vacancy Ref: Another single line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

    given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename this to 'Staff...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 41 - 60 of 121

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.