Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 (eg. Looking/Facing down made the subject look up???) Arms Up Contrapposto Cross-Legged (or Meditation Pose) Crossed Arms Dynamic Pose Facing the Camera Hand on Chin Hands on Hips K-Shape Pose Leaning Back Odalisque Pose S-Shape Pose Sitting With their...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 Arms Suptek Hex Clamp Monitor Arm Stand For 13"-27" 1 ~@£151.00 (at time of purchase) New components Case Lian-Li 011 Dynamic Mini Snow Edition 1 £114.88 Motherboard NZXT N7 Z490 White ATX Motherboard (Intel) 1 £195.21 CPU Intel Core i9-10900 (LGA1200...

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

Zoho Books: System Values Mapshttps://www.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://www.joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 RocketTheme Great graphics and their templates come across as commercial flashy sites. Their own website is glossy and dynamic. Very nice! Installing everything can cause a mess but otherwise nice solid and robust code.

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 the Search for Author Input Box, which is the 4th element on the webpage with an INPUT Tag: (Note - the item number may be dynamic) Code: javascript: alert(document.getElementsByTagName('input')[3].value) MsgBox %...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox, FunctionToDo, DLL File, Enter the name of the DLL...

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

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

17 August 2012 2.5.x 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...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and compatible with smartphones.(Like Flash back in the...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 search my site for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the Flat File Source. Done.

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or listed building. Dynamic Zones are created using data fed for extreme weather conditions, earthquakes (by earthquake.usgs.gov) and at some point...

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

Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Divhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-page-toggle-on-off-switch-hide-display-a-div.html

22 October 2020 that Zoho Creator has their own version of Bootstrap and jQuery. This is the first example I have where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some screenshots to preview what...

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

Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-a-list-of-any-size.html

21 October 2022 will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page);...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page);...

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

Zoho Creator: Sendmail a list of attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred to me that perhaps this isn't clearly documented. But there are...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy logic. I thought I could simply...

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