Assuming data is required, the following 218 results were found.
-
type :GET connection:"zcrm" ]; // l_ContactDetails = ifnull(r_ContactDetails.get("data"), List()); for each m_ContactDetails in l_ContactDetails { if(!isNull(m_ContactDetails.get("Tag"))) { for each m_Tag in m_ContactDetails.get("Tag") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the API calls to go through a few thousand records and to update the related records. I was getting the error INVALID_DATA with the details being api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
General Data Protection Regulation (GDPR) On May 25, 2018, the European Union's General Data Protection Regulation (GDPR) went into effect across all European Union markets. We believe this presents a new opportunity for marketers to strengthen their...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Outline Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
with how the file was downloaded with cURL. The XML node should be baños. The initial command using cURL was: function get_data($url) { $ch = curl_init(); $timeout = 5; curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
null)); b.create().show(); } @Override protected void onActivityResult(int requestCode, int resultCode, Intent data) { // if taking if (requestCode == REQUEST_IMAGE_CAPTURE && resultCode == RESULT_OK && null != data && TAKE_OR_PICK == 1) { Bundle extras...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid installing Sample Data if possible (there will be some but this script has been reworked to potentially accommodate). Download my migration script...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
with loading UTF16 content into SimpleXMLElement or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL result but I get the above error with using either "SimpleXMLElement" or "simplexml_load_string". Returning the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB