What can MAGA’s do to stop Biden from cheating again?https://www.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 "167." The robot proceeds to chat with him about subatomic physics, black holes, and game theory. Curious, the guy comes back a second night. "What'll you have?" says the robot and the guy again receives the best martini of his life. "What's your IQ?"...

• Type: Article
• Author: Joel Lipman
• Category: Jokes
• 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 profile(s) that will have access to this button and click on Save Go to a CRM account record and test the button works. Go back to your Zoho CRM function and simply include HTML and CSS in the output of the function... done. What we're here for The...

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

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

25 September 2025 CASE p."Title" WHEN 'DEMOGRAPHICS' THEN 2 WHEN 'AWARENESS' THEN 3 WHEN 'ENGAGEMENT' THEN 4 WHEN 'SATISFACTION & FEEDBACK' THEN 5 WHEN 'USABILITY' THEN 6 WHEN 'FEATURES' THEN 7 WHEN 'PRICING' THEN 8 WHEN 'SUPPORT' THEN 9 WHEN 'TRUST' THEN 10 WHEN...

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

404: Page Not Foundhttps://www.joellipman.com/static-items/404.html

11 February 2015 be found on our new website at www.joellipman.com. The Page you are looking for doesn't exist or an other error occurred. Go back, or head over to Joel Lipman .Com to choose a new direction.

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 component then there is no need for AEC anymore. For this we're basically going to follow the AEC installation instructions backwards. 1. Go to your admin panel (back-end) 2. Extensions > Plugin Manager 3. Go to the bottom and change the display #...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 modify a file containing 2 lines of code by default. The file is index2.php in your Joomla root folder. Make a copy of it, back it up or do whatever you usually do when you modify a server-side file... ahem... The code by to look for (joomla default)...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 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 for updates/fixes. If you want more support/work done to it, you could consider a donation :c)...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 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 for updates/fixes. If you want more support/work done to it, you could consider a donation :c)...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount you passed on as...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins. db_backupoperator Members of the db_backupoperator fixed database role can back up the database. db_datareader Members of the...

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

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

05 January 2011 using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a local report...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 as each thumbnail is one entitlement of the first 100,000 for free. After that there may be a charge or images may come back watermarked/unavailable). The module only generates website thumbnail preview images for the weblinks that are currently...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const SWP_ASYNCWINDOWPOS = $4000 ;#End Region ;#Region Virtual Keys Const VK_LBUTTON = $01 Const VK_CANCEL = $03 Const VK_BACK = $08 Const VK_TAB = $09 Const VK_CLEAR = $0C Const VK_RETURN = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU...

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 to blank after the report was run. End-Users were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares against the same parameter. So for example:...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 me to test websites for example and compare page loads. It's more fun on a networked computer which is constantly writing back and forth to network shares, user profiles, browsing data, etc. What does it look like? It's kinda transparent with it's text...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 user would be taken to a report which says either "Stored Procedure was successful" or "No sorry you're going to have to go back to the beginning and try that again."... This isn't a solution that sounded good enough for our customers. The Workaround we...

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

Ubuntu as a media serverhttps://www.joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 this? Right now LinuxMCE has it's own method for doing this so the LMCE UI is never cropped off, but when the user switches back to Ubuntu's gnome desktop, the top nav bar is cut off if he's using a normal tv and not a pc monitor. I'd like to have 1...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on the workstation, they error incessantly and never manage...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 : (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") Date back into String -- Converting yyyy-mm-dd hh:ii:ss to ddmmyyyy RIGHT("00" + (DT_STR,2,1252)DATEPART("dd",DateVerified), 2) + RIGHT("00" +...

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