Assuming else is required, the following 121 results were found.
-
= "Thank you for accepting your quote! We'll be in touch soon to finalize the next steps and get everything ready."; } else if(v_Intent == "Decline") { b_ValidResponse = true; // // Mark the estimate as declined r_Decline = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
v_OrgId, r_UpdateBooksInvoice.get("invoice").get("invoice_id"), m_ZB_Update, "zbooks"); } } else if(!isNull(r_UpdateBooksInvoice.get("message"))) { v_OutputResponse = "FAILED: " + r_UpdateBooksInvoice.get("message"); } It's a cop-out I know, but it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"Response from function was unparseable"; parsedOutput = " Error: " + errorOutput + " "; document.writeln(parsedOutput); } else { // If parsedOutput is an object, you can now use normal dot notation: if (parsedOutput && typeof parsedOutput === "object")...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
which accesses a Google Drive using a Service Account (unattended). Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
CASE WHEN emp.ContributionValue=1 THEN 5010 WHEN emp.ContributionValue=2 THEN 5011 WHEN emp.ContributionValue=3 THEN 5012 ELSE 9999 END FROM [dbo].[DMExtractEmployeeTable] emp INNER JOIN [dbo].[DMExtractReferenceTable] ref ON RIGHT(emp.[PayCode],3) =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
'Macintosh') THEN 'Mac' WHEN INSTR(a.VisitorUAgent, 'X11') THEN 'Linux' WHEN INSTR(a.VisitorUAgent, 'Linux') THEN 'Linux' ELSE 'Other' END VisitorOS, COUNT(a.VisitorUAgent) 'Total' FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) AS ActivityDate, MIN(s.DateTimeCreated) AS DataFrom,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
on how to use ternary operators in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
> match_lowest_y) { $('jdo_actions').style.position = 'absolute'; $('jdo_actions').style.top = match_lowest_y + 'px'; } else { $('jdo_actions').style.position = 'fixed'; $('jdo_actions').style.top = '5px'; } } else { $('jdo_actions').style.position =...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
function formatSizeUnits($bytes) { if ($bytes >= 1073741824) { $bytes = number_format($bytes / 1073741824, 2) . ' GB'; } elseif ($bytes >= 1048576) { $bytes = number_format($bytes / 1048576, 2) . ' MB'; } elseif ($bytes >= 1024) { $bytes =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
// add the answer text to the response map m_Response.put("text",m_Choice.get("message").get("content")); //break; } } } } else if(r_ChatGPTResponse.get("responseCode") == 429) { // store in response text m_Response = {"text":"I dont have any knowledge...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
if (Check1=0) AND (((Check2=0)and(Check3=0)) OR (Check20)) DaysInMonth=31,29,31,30,31,30,31,31,30,31,30,31 else DaysInMonth=31,28,31,30,31,30,31,31,30,31,30,31 ThisMonthNum:=A_MM * 1 ; because we want 01 to equal 1 ThisDateNum:=A_DD * 1 ; because we...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
ThisDays:=ThisDays - (ThisYears*365) Grammar:=(ThisDays=1) ? "" : "s" strVal=%strVal% %ThisDays% day%Grammar%, } else { Grammar:=(ThisDays=1) ? "" : "s" strVal=%ThisDays% day%Grammar%, } } If ThisHours>0 { Grammar:=(ThisHours=1) ? "" : "s"...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
it and it works perfectly for me. And I guess I'll just keep testing but there is the issue that you can't do anything else while it's sitting there taking pictures; unless you have more than one screen. It's automation. The situation is that the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details. • By default,...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
v_MathPi = 3.1415926535897932384626433832795028841971693993751; if ((p_Lat1 == p_Lat2) && (p_Lng1 == p_Lng2)) { return 0; } else { v_RadLat1 = v_MathPi * p_Lat1 / 180; v_RadLat2 = v_MathPi * p_Lat2 / 180; v_Theta = p_Lng1 - p_Lng2; v_RadTheta = v_MathPi...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
r_ProductCreate = insert into Product [ Product_Name=v_Name Added_User=zoho.loginuser ]; v_ProductID = r_ProductCreate.ID; } else { // DON'T insert into Product table v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *