Assuming will is required, the following 354 results were found.
-
but here's the bits that I need: Updating a record with PUT (note that id needs passed for each row otherwise you will end up with duplicate line items): /* ******************************************************************************* Function: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html
you to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
documentation and changelog under each project. This means you only update one documentation/changelog page which will be a Joomla! article. The Joomla! article will support whatever content based on however your Joomla! website is configured. My day...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
but the more basic the receiving data the better. In my example, I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
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 PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString VARCHAR(max),...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
+ "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: ....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably manage it in Zoho Books leaving it to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF