PHP & MySQL Search Enginehttp://mail.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql =...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joes Quicklist Weblinks (JQW)http://mail.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 which only the authorized "service group" has access to (Special?). Free Website Thumbnail Services Thumbnail Services will give you a limited number of free thumbnail generations. About 100,000 on average which is more than enough for our Joomla!...

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

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 Settings Select Create View Select Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 do I get the milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then is it slower? Not necessarily. Like...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM...

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

Print Directory Contents to a Filehttp://mail.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 Select the "(NONE) Folder" option Click on "Advanced" Click on "New..." Enter the New Action as per the following: Action: - Give the action name a memorable name (eg. "Print Directory Contents To File") Application: - Type the following...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Inline Labels in Form Fields using Javascripthttp://mail.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" - give this field a default value. In this specific case, we are giving it the label value to indicate to the user to enter their...

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

Joes Revolver Map (JRM)http://mail.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the entire javascript code they give you. Login to your Joomla website admin panel Create a new Custom HTML Module In the "Custom HTML", either disable rich-text...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://mail.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

SSIS Convert a string into a datehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833)...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 want to order by more than just popularity and/or date, but also by our own relevance heuristics. The following change would give radically high relevance to articles where the search term is found in the title. \plugins\search\content\content.php:...

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

Joes Password Analyzer (JPA)http://mail.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 to use. Comments/Suggestions Please use the comment section below to suggest changes, corrections, improvements or just to give an opinion. Use it! It's absolutely FREE! The password analyzer URL is: www.joellipman.com/services/password-analyzer.html....

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Sort an associative array by values in Javascripthttp://mail.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...

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

Zoho CRM/Creator - Common Errors & Gotchashttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 Sounds rather straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some scopes and test. The likely...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time. How? Through...

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

MySQL: Count occurrences of words in a columnhttp://mail.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have added a LIMIT to only return the top 50 words. Source(s): Counting...

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

Zoho Deluge: Duplicate/Clone a Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 Developer Space click on "Connections" Under Pick your Service click on "Zoho OAuth" (NOT "Zoho" - there are 2 Zoho options) Give the connection a name such as "myZohoConnector" Tick the applicable Scope(s): for example: "ZohoCRM.settings.fields.READ"...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 return the version of the Zoho Extension Toolkit (eg. 0.23.6) Create a project In the terminal, type zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 connections (in creator this is icon in top-left > Setup > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ):...

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