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

11 February 2023 the MidJourney Bot Type the word /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other commands Stealth...

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

Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

26 July 2021 random fields were being returned, all pretty much useless to me. Well the "for some reason" turned out to be because my detail view on the report was displaying a report/document template. How? The quick answer is: Add the fields you want to the detail...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 "Add Script" grey one) Give the client script a name, I'm calling mine "Extra Confidential" Keep Category=Module, set Page=Detail Page (Standard), set Module=Contacts and set the layout if you want. Under Event Details, set Type=Page Event; Event=onLoad...

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

Community Builder in Joomla Vulnerabilityhttps://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 computer or otherwise operate without your consent. Just viisting a site that hosts malware can infect your computer. For detailed information about the problems with this site, visit the Google Safe Browsing diagnostic page for this address I...

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

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

19 January 2012 source=oracle sp field name) 1. Create a stored procedure using a cursor for SSRS CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( p_STUDENT_ADNAME IN varchar2, l_CURSOR OUT sys_refcursor ) IS BEGIN -- going to declare variables that are to...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the least amount of code (or near enough) you will need to get this...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. Each version is given a distinguishing version number. If the Program specifies that a...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 it's time for that gentle reminder..." Message1:="In total...`nYou have " ThisManyWeeksMessage " left at BU.`n`nIn more detail:`n • " ThisManyDaysMessage "`n • " ThisManyHoursMessage "`n • " ThisManyMinutesMessage Message2:="You have "...

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

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

24 October 2014 can be added to really easily. It works by reading the weather data from api.openweathermap.org and the flight restriction details from api.joellipman.com (my own personal website). This allows me to continually add data to the api of my own website...

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

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

10 March 2020 I needed a way to programmatically link the sales order to the invoice. Why? The documentation around the API does not detail how to do this. I also couldn't find any search result via Google or DuckDuckGo (can't say for Bing, I never get around to...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into detail on how to set up your own connection as I have elsewhere on my website, but to use in an invokeUrl here's a quick overview:...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 do this, you may find other ways but this is one that works for me. How? So here's an overview and then we'll go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 page number and the number of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles on eBay webhooks). Instead, all we want is the URL of an image...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the client script which will manage...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 ??? - ??? ******************************************************************************* */ v_Pipeline = ""; r_RecordDetails = invokeurl [ url :"https://www.zohoapis.com/crm/v8/Deals/" + p_DealID + "?fields=Pipeline" type :GET connection:"zcrm" ];...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 the Zoho CRM which displays a more clear HTML & CSS styled message box. How? There are links to how to create a widget in detail which I'll link to at the bottom of this page. What follows are the quick steps to create a widget.html file and how to get...

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

Documentation Introductionhttps://www.joellipman.com/component/content/article/documentation-introduction.html?catid=36

12 September 2010 the articles which document my downloadable products. Please bear with me as I collate all your questions and go into more detail.

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