Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 into a ladle so it can be poured into the hot pan in one go. As soon as the batter hits the hot pan, tip it around from side to side to get the base evenly coated with batter. It should take only half a minute or so to cook; you can lift the edge with a...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 newly copied metamod and rename it to metamod_pubmenu, set "Access Level" to 'public' and "Menu Items" to 'All'. 5. On right side in "Module Parameters" "Show Quick Modules To" choose - 'non-logged in users only' then scroll down to the list of...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 up to the top of the screen it will automatically maximise itself. If you have two windows open, and want to view them side by side. Click and drag one to the right edge of the screen and the other to the left. They will both resize automatically to fit...

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

CSS keeping the footer at the bottomhttps://www.joellipman.com/articles/web-development/css/css-keeping-the-footer-at-the-bottom.html

25 April 2011 of the Page Aim: Header Left Right Footer Situation The header displayed fine. The left and right columns finally got them side by side. But the footer that has a background image was under the left and right columns... The main content layer was...

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

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 just in case you didn't pick up on this. If no type is specified (type=2) then datasources and folders will also show. The Side-by-Side Table As you know, most datasets will return the rows as... rows. My pic above shows my 4 reports results side by...

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

SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

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

Compare two databases using T-SQLhttps://www.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 Method #3 And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], t1.TABLE_NAME AS [DB1_Table],...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 portal, or you have the customer on a remote assist who has access to do this, click on the red "Verify Now" link. The sidebar for "Domain Verification" will poup on the right. Note the small code and prefix it to your parent domain (eg....

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

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

11 February 2023 // returns 4 pictures of a flower in a landscape orientation with an aspect ratio of 16:9 (a bit like an A4 paper on it's side) /prefer option set This will create custom parameters/argument suffixes you can add which represent a whole string of words...

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

Cranberry flapjackhttps://www.joellipman.com/articles/_other-misc/cranberry-flapjack.html

07 July 2009 Melt the butter in a thick based non-stick frying pan. Spoon the mixture into small rounds. 3. Fry for 2-3 minutes on each side until golden. 4. For the caramel sauce, in a hot pan, add the butter and sugar and cook for 3-4 minutes. Then add the cream...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• 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 is now a commercial package and it is somewhat limited in terms of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options for your website members. If...

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

Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

27 January 2010 between HTML and autohotkey syntax (note we're making a table with 9 columns and 6 rows - there's a spacing column on either side): htmlText:="" htmlText:=htmlText " " htmlText:=htmlText "" htmlText:=htmlText " " htmlText:=htmlText " M "...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 Double-click on the key on the right-hand side for SpecialPollInterval The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Use this one to instruct the provider to ignore any command prepare statements and prevent corruption issues with server side prepared statements. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Ignore Prepare=true; The option...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer Time...

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

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the wall? Ok could you please follow the cable from the computer to the printer and tell me.". "Hang on its on the other side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 time. Why? I have an Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Oauth2 connection in Zoho Books. In Zoho Creator, go to Setup (3 horizontal lines in top left if in edit mode » pops up the side bar to go to Home or Setup) Under "Extensions", click on "Connections" Click on "Add Connection" Click on "Zoho Oauth" Give...

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