What?
A very quick note in case I forget this one. 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 ...
...
Conversion failed when converting date and/or time from character string.
Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query.
Once ...
The Issue
If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to ...
What?
A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB).
Why?
It's likely that Zoho will avail their color picker at some ...
What?
There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks.
Why?
This use-case is ...
...
How?
So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem ...
... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...
What?
A really quick article for anyone experiencing the same issue: As a super admin in CRM, I am denied permission to access the Quote Conversion Mapping page...
Why?
I wanted to map a billing ...
What?
A very quick article on converting a Map string into a HTML table without using a for each loop.
Why?
I have quite a big response from our CRM that hits a statement execution limit if I ...
... What Creator understands: FAILS
How?
So the way to push this value over to Creator is by converting the list to a string... notably comma delimited:
// Reading CRM:
l_MyMultiPicklist = List:String();
l_MyMultiPicklist.add("Option1");
l_MyMultiPicklist.add("Options ...
What?
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters.
How?
Let's first define a map:
m_Payload = Map();
m_Payload.put("client_id","my-unique-client-id");
m_Payload.put("redirect_uri","https://www.joellipman.com");
m_Payload.put("response_type","code");
m_Payload.put("scope","my_api_scopes");
m_Payload.put("prompt","login");
Great! ...
What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).
My Data:
Account ...
What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
What?
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
... referring to converting strings to dates and incorrect data types.
How?
The fix is to simply get the field and both results to be of the same data type:
=IIF(CStr(Fields!MyCompletionTime.Value)"", ...
... + " 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) ...
... =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss
-- yields 1:00:00
Note that the first formula is converting person days into minutes and then dividing by 1440 (resulting in the decimal ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.