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

11 February 2023 puts a massive eye on the picture???) Cinematic Still Shot Full-Body shot Headshot from chest up Portrait Knolling Satellite View Subject «This is the actual subject that you want an image of» Subject Attriutes This is just a list of ones where it...

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

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

06 May 2025 Attachments, Emails, and Timeline should remain. Code will be needed as a layout rule couldn't control the tabs on a canvas view page. An additional function is needed as the pipeline was not displayed on the canvas view of the deal record but it was on...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 ID", "Page Number", "Question Number" You can take out the order by clause. I just have it here to preserve my sanity when viewing the output. Note that "Page Number" is my custom sorting mechanism so you would have to refer to the output without this...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 - Outputs: - Date Created: 2025-01-30 (Joel Lipman) - Initial release Date Modified: ??? ??? More Information: Custom View ID: 123456000012345678 ******************************************************************************* */ // // initialize...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 connection is successful TEST > OK Open the data connection Open Business Intelligence Development Studio (BIDS) Click on "View" > "Server Explorer" Right-click on "Data Connections" > select "Add Connection" Click on "Change..." Select "Microsoft ODBC...

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

Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 file example" below) TEXT file example http://www.joellipman.com http://www.joellipman.com/index.php?option=com_content&view=article&id=509 http://www.joellipman.com/support/documentation/509-joes-free-website-thumbnailer.html...

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

Basic Oracle Stored Procedure Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a bit of a bugger as you need to do a few other things to see the results of this stored procedure....

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 3 onrUest ehAr 1968-05-05 4 otentre AhYe Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as...

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

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

20 August 2012 file, if you have this enabled in Joomla then you already have this and don't need to include it again (just view the source of your webpage that this form will be on). Does not use JQuery - Although most of the sites I work for use JQuery as well as...

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

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

07 May 2013 the files I have listed here (the ones we will be modifying): \plugins\search\content\content.php \components\com_search\views\search\tmpl\default.xml \components\com_search\views\search\view.html.php \language\en-GB\en-GB.com_search.ini [IfExists]...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttp://mail.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel the following screenshot when...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; Language:...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as a "Save & Close" button. The "Save" button would submit the form but keep...

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

GoDaddy Apache cPanel: Install SSL Certificatehttp://mail.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 the search to filter by icons relevant on your cPanel dashboard and then click on the "SSL/TLS" icon Click on the "Generate, view, upload, or delete SSL certificates" link in the right sidebar Scroll down and click on "Choose File" button under the...

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

Link to a Joomla article from within another articlehttp://mail.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 a Joomla article even when you have Search-engine-friendly website addresses enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL...

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

Live WebCam feed of Bournemouthhttp://mail.joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Display a thumbnail of a Google Drive videohttp://mail.joellipman.com/articles/google/display-a-thumbnail-of-a-google-drive-video.html

13 November 2018 // where is the file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing // to link/display in apps: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // redirects to something like:...

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

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

20 July 2022 is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user clicked on field in view mode and edited just one field). The only other event you can use this in inline editing mode in is the Canvas mode. Error(s)...

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

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 reference to the uploaded movie. */ class FlvPlayer { /* Generate final code */ function render() { $this->url = $this->getViewPath($this->file); $this->code = ' The Camtasia Studio video content presented here requires JavaScript to be enabled and the...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 The issue is that suppose a menuitem links to a category of weblinks, the default sort order (as in the first time you view the page) is the order in the admin panel (not even by most recent). I'm going to show you how to do this by title in ascending...

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