Assuming scripts is required, the following 38 results were found.
-
-- TABLE OF CONTENTS -- I. Help on using the queries below -- -- 1. replace all database names in the scripts below -- -- 2. checking before you commit changes -- II. Copy content from the old database to the new database and tweak: -- -- 1. setting...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html
out of such use of the website is subject to the laws of England, Scotland and Wales. DOWNLOAD USAGE Nearly all of the scripts/programs downloadable from Joel Lipman .Com are released under the GNU/GPL License v3. These are free software: you can...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
yes no Ajax Response Ready, Willing and Able Big Note: UPDATE 2012 It is important to refer to the correct mootools scripts in order for this to work. Unfortunately, clients who sign up to template providers who disallow access to their support forums...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
So this is an article to note an oddity when I was working with a Yootheme template called "yoo_sync". Some clever scripts (both mootools and jquery) using the equalize method to make div layers the same height, and in this case, the same width. It...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
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
- Language: *
-
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: *
-
; Recommended for performance and compatibility with future AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ; SET TOOLTIP...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
TESTED ON: - Windows XP, Windows Server 2003, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
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: *
-
process and read your emails at the same time on the same monitor). Download Details: JoelLipman.Com is my repository for scripts, programs and extensions to existing web-development systems. I use it to store notes that other websites either do not...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
You don't need to have much programming experience, but I will assume you feel comfortable writing and executing AHK scripts. We will be covering the following three topics: The HTML DOM - (Document Object Model) A basic understanding of the HTML DOM is...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
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
-
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
-
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
-
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
-
Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html
source code needed to generate, install, and (for an executable work) run the object code and to modify the work, including scripts to control those activities. However, it does not include the work's System Libraries, or general-purpose tools or...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
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: *