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

  1. ZohoCRM: ZDK Client Script to retrieve Contact Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zdk-client-script-to-retrieve-contact-email.html

    An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow on save of the record, but the client wants the...

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

  2. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    Pause Return ; Terminate script Exit: GuiClose: OverviewGUIGuiClose: CloseMe: ExitApp Return Source(s): Autohotkey Boards > Scripts and Functions > Hash from string, hex or file, HMAC, Salt

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

  3. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    has a limited number of use cases, but is useful to be aware of if you have not come across it before. Why? In many Deluge scripts, assignments are often more than a single value. At times, it can be useful to copy and paste or temporarily format logic...

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

  4. Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    display on the weblinks page. I could modify the page for categories (by default it's an ugly unordered list), but changing scripts gets overwritten in a joomla upgrade so too many changes is a hard process to keep track of. Joomla 1.6.x Responding to a...

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

  5. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    Why? I'm building a Joomla component which is to be compatible with Joomla versions 1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC...

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

  6. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    assets Third-party component: JComments: This will be a copy of two systems running JComments version 3.x The MySQL scripts will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be...

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

  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ using System; using System.Data;...

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

  8. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    the student ID number Agenda Outline Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute...

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

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

    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 entire database for a particular string of word(s). I've posted my own as well as...

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

  10. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

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

  11. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT( DAYOFMONTH(calendar.StartDate), '-',...

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

  12. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address, this is what I use. The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV...

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

  13. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven website. How? I'm first going to highlight 2 methods which I found on the web and can be applied...

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

  14. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they do not: Surround string (apostrophes) with red...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  15. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't...

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

  16. Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    on most LAMP setups. If not you can install it from here: http://curl.haxx.se/download.html I'm demonstrating this with 3 scripts on the intermediary server: 1. to display the HTML form (usually handled by the mobile app) 2. to send the values to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

  17. Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/component/content/article/format-numbers-in-autohotkey-with-commas.html?catid=48&Itemid=165

    a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

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

  18. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and seconds)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 21 - 38 of 38