Assuming yields is required, the following 93 results were found.
-
+ f_MyImages.ID + "/MyImage/image-download/" + v_PublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; // yields something like...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
m_Data.put("Last_Name","Person"); m_Data.put("id","2"); l_Data.add(m_Data); v_Data = l_Data.toString(); info v_Data; // yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
== $v_Key && $v_PostedSecret == $v_Secret) { mail("info@joellipman.com","Post to AscentCloud","Successful Auth"); } } // yields: Successful Auth Caveat Unfortunately, I've titled this article as multi-dimensional but I found that this code doesn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
\ -H "X-Shopify-Access-Token: {access_token}" Yields something like the following response: { "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, "product_id": 9876543210987, "created_at":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska Time (GMT-7:00) Pacific Time (GMT-6:00) Mountain Time (GMT-7:00)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
[ url: "https://zohoapis.com/writer/api/v1/templates" type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
[ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; return r_GetProduct.toMap(); } Job done! Yields something like: { "data": { "productVariants": { "edges": [ { "node": { "id":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
option includes some HTML, specifically a SPAN tag surrounding the date number (eg. "Wednesday9March"), which yields the following: Then I get rid of the label with the following CSS: label.zc-Calendar_Day_Select-label{display:none !important;} Then get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); // yields //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Response = Map(); v_Answer = "";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
= v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not cater for the Mac prefix;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to: "info@joellipman.com" subject: "Test File: List" message: "This is just a test" attachments: file: l_Downloads ] } Yields
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
for the road..."; info v_Test4.toLong(); } catch(e) { info "Couldn't convert 'Another...' to an integer"; } } } } // yields: // "Couldn't convert 'Foo' to an integer" // "Couldn't convert 'Bar' to an integer" // "Couldn't convert 'Everyday...' to an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in that if you try to assign this to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE user_id= ORDER BY name...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
: (DT_DBTIMESTAMP)(SUBSTRING(Date,5,4) + "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") -- Yields: -- [MyDerivedColumnTask1 [4228]] Error: The conditional operation failed. -- SOLUTION: -- a) create a first derived columns task...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference student_title_code student_name student_gender_code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and "DataSet1" is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName // yields something like ItemName DayOfYear YearRun Counter --------------------- -------------- ------- ------- Report 001 181 2010 134...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
FROM student_accounts WHERE student_accounts.studentID = trim(:p_myparameter) , '???') FROM DUAL; --> Yields error ORA-00936 -- Not Erroring: SELECT NVL( (SELECT student_accounts.student_username FROM student_accounts WHERE student_accounts.studentID =...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB