Search - Joel Lipman .Com

1. Joomla WHERE clause with OR: / Joomla /; What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT ...; Created on 16 July 2014
2. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
3. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
4. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have ...; Created on 02 October 2023
5. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... about 4 months until I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, ...; Created on 03 July 2023
6. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... multi-line field called "Content" and change the properties on creation to allow 32000 characters. Keep the email field called "Email" Return to the Context Handler Function IDE (page where you ente ...; Created on 06 March 2023
7. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename ...; Created on 01 March 2023
8. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords ...; Created on 13 February 2023
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom paramete ...; Created on 11 February 2023
10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
11. ZohoCRM: Import Attachments: / Zoho /; ... into the penultimate step of the migration where you watch another but different progress animation which is possibly all your data being mapped, associated, and imported... I personally had to refres ...; Created on 16 January 2023
12. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... se Order ID" WHERE poi2."Item Name" IN ( 'delivery' , 'Delivery' ) GROUP BY po2."Purchase Order ID" ) pshipping ON pshipping."PO ID" = po."Purchase Order ID" LEFT OUTER JOIN( SELECT po3."Purc ...; Created on 03 November 2022
13. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where ...; Created on 18 August 2022
14. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers ...; Created on 17 August 2022
15. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and content > Manage Devices. You will get to see the list ...; Created on 29 June 2022
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... it and click on the ellipsis/3 dots Select the REST API Enable REST API Note the REST API function and you can now call it from wherever. Done Additional Caveat(s) This currently does ...; Created on 31 March 2022
17. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... on the O11 Dynamic Mini and air flow isn't perfectly balanced. I'd opt for the O11 Air Mini (newer one) where fans can be mounted to the front and it supports an ATX Power supply. I bought 9 Coolmoon ...; Created on 12 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
19. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today: { productVariants( first: 10 reverse: true query: "updated_at:>'2022-02-14T00:00:00+0000'" ...; Created on 14 February 2022
20. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022