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 ...
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)", ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
What?
A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this).
Why? ...
... replacements
m_HtmlEntity = Map();
m_HtmlEntity.put("&","&");
m_HtmlEntity.put(" "," ");
//
// loop through each of the above replacing where found
for each v_HtmlKey in m_HtmlEntity.keys()
{
v_StringToDecode ...
What?
A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge.
Why?
The use-case here is that we want local sense dialing where specific numbers are used both ...
...
The Solution/Cause
So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names:
// select a bunch of creator records ...
What?
An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record.
Why?
Our use-case is that we have a client who has ...
What?
This article demonstrates how to return a list of unique values in a particular field in a CRM module.
Why?
My use-case is a data-migration where the records exist in a staging module in ...
...
Auth'n'auth (Authentication and Authorization) Process
Not getting notification via the URL but you are getting them via email? Well I read somewhere you need to use Auth'n'auth to enable these notifications ...
... and from a developers understanding: field1 is told to update field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive or endless loop where each field ...
... might want to consider that not all new lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different ...
... been checked.
Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have ...
... to Shopify
m_Response = Map();
//
// enter webhook key featured in the "settings > notifications > webhooks" section beneath the webhooks where it says
// "All your webhooks will be signed with .... ...
... a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be done all in one ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.