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

11 February 2023 1/125 second shutter speed, ISO 100, Adobe Photoshop, award-winning, experimental techniques, unusual perspectives, attention to detail::3 blurry, dim, uninspired::-2 painting: ::5 Beautiful painting with artistic symbolism::4 brushstrokes, expressive,...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include these in her estimate template... But I'm sending them anyway. Note(s)...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Here's an example of the query for a timetabling solution with spacing rows between days. This worked ok but pay special attention to Stage #3 afterwards otherwise if you stop in Stage #2 you'll be missing data: --Create CTE WITH tblDifference AS (...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 of the dropdown options. » Default Values - "Get values from a query" = Select the dataset of dropdown options, pay attention to the value in "Value field" (as I kept putting the label rather than the value field) to make this all work. Notes: My...

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

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 on Header Scroll down and click on Shipping Address Format (Custom) Enter the following placeholders: ${CONTACT.CONTACT_ATTENTION} ${CONTACT.CONTACT_ADDRESS} ${CONTACT.CONTACT_CITY} ${CONTACT.CONTACT_CODE} ${CONTACT.CONTACT_STATE}...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 "$1", false); // yields 12.000 So this isn't quite right, so let's get a regex that rounds numbers up but pays attention to where the decimal point is: v_Test3 = 12.000; info v_Test3.toString().replaceAll("^(^-?\\d+\\.\\d*[1-9])(0+$)|(\\.0+$)", "$1",...

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

About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

21 November 2012 Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL this will show you the domain and username of this accountname in Active Directory. I know the AD domain and username, show me the person!...

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