Assuming would is required, the following 210 results were found.
-
if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book rate post saving a record in Zoho Deluge would fail because it was making too many function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
when an end customer clicks on either the accept or decline button. Using ZohoFlow or other Zoho app for a webhook response, would result in the end customer suddenly downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
The official documentation says to use remove() to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Took us a while to find this and perhaps others would have a quicker way but here's the instructions on getting the records from the performance module in Zoho People API. Why? Cos it took us a while. The online forums seem to go back over a decade and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
a radar/spider/web chart based on the results from a survey. Apparently this will be done in Zoho Analytics. The Brief: We would like the survey data to be generated as a chart and embedded in a PDF brochure we send out to our customers... How? Well...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
EU Services Availability Permission Issue: Are we logged in to Zoho Books as the super admin? Most likely yes and the client would have already checked this. Did this ever work before? Kinda pointless question but needs to be asked just in case this was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
the phpbb3 ZIP file to your computer and then upload the resulting files to the http://www.mysite.com/phpBB3 folder you would create via your FTP client. When that's done, navigate to http://www.mysite.com/phpBB3/install/ and you get a web installation...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
website. They experiment on their customer-facing website and in most cases, they are paying for a hosting package which would allow them to have several copies of their website. Why? In my job, it is important that we have a development environment for...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Referencing: If this is a search system for a technical database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns that specific article. In the case of Joomla, we'll use the article...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
an article to document the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this is how I...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
can also mean "I don't know". I want the report to either return the correct value or say "No data found". My end-users would otherwise ask is the data value reliable if it's blank? The long way of doing this I would have called this article "Iteration...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a lot of rows, possibly all unrelated and won't work in my particular case. The solution to this issue of these solutions would be to add another AND clause where you state that the ID (DB.Table.StudentReference) can NOT be blank/null. End-users won't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution #2: Alternative image if file does not exist More of a workaround than a solution...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Unicode=true and my user is a specific read-only user. 3. Add an SSRS parameter Idem as in just specify a parameter as you would for any usual SSRS report. (Ignore my 2nd and 3rd SSRS parameters in my example as I didn't end up using them) 4. Add a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
what should display went behind my report and instead the whole report acted as a header on top of the scrolling content and would only ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
my colleagues installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified. So? Once installed, my BIDS install would continuously check-out files and store these in the...
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB