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

  1. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    FROM information_schema.COLUMNS WHERE TABLE_SCHEMA IN ('network_detail'); DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1; #Truncating table for refill the data for new search. PREPARE trunc_cmd FROM "TRUNCATE TABLE temp_details;"; EXECUTE trunc_cmd ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  2. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. T-SQL: Parse an XML valuehttps://joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    FROM [dbo].[XML_EVENTS] Issues: XQuery [value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' This is because more than one record was returned so you need to surround with brackets and append a [1] as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. Data Randomization Function in Oracle PL/SQLhttps://joellipman.com/articles/else/database/oracle-pl-sql/data-randomization-function-in-oracle-plsql.html

    := TO_DATE(TRUNC(DBMS_RANDOM.VALUE(v_rand_param1,v_rand_param2)),'J'); END IF; RETURN v_returnedval; EXCEPTION WHEN no_data_found THEN RETURN ('Error in submitted value'); WHEN others THEN RETURN ('Unable to generate random value'); END...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  5. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    then check your logs to see if anyone has been trying to hack your website. There are a number of components I have found that even with captcha features, still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  6. Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    well for our SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC Driver for MySQL (Connector/J) connector from...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    virtual host running PHP and MySQL. There was no documentation, logs, notes, and any code comments were in Hungarian (later found out it was slang or a dialect not understood by most Hungarians). Fellow students and system administrators could not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  8. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    and conditions in quote/invoice templates and want the HTML to be indented neatly. Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  9. Sort an associative array by values in Javascripthttps://joellipman.com/articles/cms/website-development/js/sort-an-associative-array-by-values-in-javascript.html

    doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an excuse. I also found that examples across the web were only partial and thought I'd write a full example here. No jQuery and using the Google...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  10. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere......

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  11. SITS: Export field code and namehttps://joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    -- But if CODE is not populated, -- Using &G[COD.SRS:•|•]&ABLANK="*LookupFailed*" -- yields: A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  12. Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

    Background) do not load if not enabled. - Added Joomla! Admin Option: Module width. - Corrected division by zero if no words found (?) sets to 1. - Now includes absolute path for word link (JURL::base()). - Date Uploaded: Sat, 14th May 2011 1.6.2 -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  13. Import Excel CSV file as JavaScript arrayhttps://joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    is blank (allows for blank excel lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes = column_values[1].split('"').join(''); // populate my array with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  15. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    Sfumato Sgraffito Synesthesia Tenebrism Ukiyo-e Unsplash Vaporwave Voronoi Wabi-sabi Warli And a few more These were found from searching the web for other art styles: Anamorphic Aquatint Avant-Garde Batik Caricature Collage Composite Concentric...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  16. On Gui Resize Eventhttps://joellipman.com/component/content/article/on-gui-resize-event.html?catid=48&Itemid=165

    Thought I'd put this down as it took me ages to search the Internet for this solution. In the end, I found it hidden away in the Autohotkey help file and not under the gui events... The issue here is if you want to do something when a user resizes your...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  17. CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  19. Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  20. After installing rokstories, get invalid argument 106https://joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

    Invalid argument supplied for foreach() in /home/.../components/com_content/helpers/route.php on line 106 After googling I found an unlikely solution which is becoming typical of Joomla. I hadn't switched the site to SEF friendly yet but I did this just...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 101 - 120 of 132