Assuming against is required, the following 37 results were found.
-
variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
causes thread's to go off topic, and most importantly, it hurts the person being flamed. The victom may defend themselves against any accusations made to them, but may not make any additional accusations to the flamer (which also counts as flaming). No...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
to the covered work, and you disclaim any intention to limit operation or modification of the work as a means of enforcing, against the work's users, your or third parties' legal rights to forbid circumvention of technological measures. 4. Conveying...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices against a sales person. It adds to the effect on loading the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
an invoice on behalf of the account manager (person who manages the customer's account), so let's get the account manager against the customer and if that isn't populated then the first estimate, sales order, invoice created by someone in relation to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
has the real database names and all website content, so do not redistribute without taking security measures. Run the SQL against your new database Open your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Additionally, the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns the local variable ID...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3',...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will configure my server...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29, 30, 31)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I find it easier and it is a step we need for Zoho on their side. Important: You should now have at least 2 CNAME records against this domain/subdomain. I usually have 3: .joellipman.com (used in verification), .joellipman.com and www..joellipman.com...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
second section as per this article, even having customized the tax rates, when selecting a product that has no tax rates against it and clicking on the edit icon for Tax at the line item level (at header level is unaffected and all tax rates are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Output = r_Api.Access_Token; // // zoho.currentttime can be server time as this function will check expiry against the server time anyway if(zoho.currenttime >= r_Api.Access_Token_Expiry) { v_Base64Auth = zoho.encryption.base64encode(r_Api.Client_ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ v_XeroSignature = m_Payload.get("headers").get("x-xero-signature"); } } // // encrypt body to check against the signature v_WebhookBodyHMACSHA256 = "ENCRYPTION_FAIL"; v_ResponseCode = 401; if(!isnull(m_Payload.get("body"))) { v_WebhookBodyHMACSHA256 =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *