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 124 results were found.

  1. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/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
  2. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-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
  3. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-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
  4. Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    (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: *
  5. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    $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: *
  6. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    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
  7. Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-current-user-id.html

    for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email == zoho.loginuserid) { idNode = user.executeXPath("/user/@id"); id = idNode.executeXPath("/id/text()"); } } } Method...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  8. Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://www.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

    table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the text there. Test by logging in as the forgotten user Done

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  9. Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

    at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  10. MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

    and the path. Remember that the paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/', SUBSTR(MD5(img_name), 1, 2)) AS img_path,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  11. Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

    is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE ( '1, 2, 3, 4, 5, 6' , ',', '') || '' ) AS xmlval FROM DUAL)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  12. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
  13. MySQL Commands to display all columnshttps://www.joellipman.com/articles/else/database/mysql/mysql-commands-to-display-all-columns.html

    The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text'...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Add default to a picture buttonhttps://www.joellipman.com/component/content/article/add-default-to-a-picture-button.html?catid=48&Itemid=165

    y70 w90 h90 vSearchButton gSearch, %A_ScriptDir%\images\program\search_button.png Add the input field where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput, Search... Add the submit button with a hidden attribute: Gui, Add, Button,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Mouseover Links in AutoHotkeyhttps://www.joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    ; CREATE GUI Gui, Color, FFFFFF Gui, +OwnDialogs +SysMenu +Caption +0x800000 Gui, Add, Text, gOpenDocumentation, Open the documentation Gui, Show, w600 h700, %ThisProgramName% WinSet, AlwaysOnTop, On, %ThisProgramName% OnMessage(0x200, "WM_MOUSEMOVE")...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  16. Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/component/content/article/fun-with-dllcall-in-autohotkey.html?catid=48&Itemid=165

    there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  17. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    and Pie). Note that AMCharts.com is free 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=53&Itemid=165

    and forth to network shares, user profiles, browsing data, etc. What does it look like? It's kinda transparent with it's text as white and sits behind other windows much like a gadget or widget. If you know your AutoHotkey, the download includes the AHK...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  19. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    interactive quick reference image - [1.7.0] Hangar: offline can view aircraft #1 - [1.7.0] Hangar: tap on specification text to edit - [1.7.0] Pilot: login, register, authenticate - [1.7.0] Pilot: map preferences/settings - [1.7.0] Help: details on what...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  20. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    to only search one area, but you can include multiple components by separating these with a comma. This parameter is a text field which uses the alias of the component (eg. "doc_indexer"), you would need to modify this to the component you want it to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 61 - 80 of 124