What?
This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them.
Why?
We found ...
... If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly?
How?
It may be that when obtaining a date string ...
... in PHP with the function simplexml_load_string(). The error I get is something similar to:
PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ...
... start with a function that just converts a string of words delimited by spaces to a table:
CREATE FUNCTION dbo.[ufn_StringToTable]
(
@StringInput VARCHAR(MAX)
)
RETURNS @OutputTable TABL ...
... on to the new phone (not fun).
The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. ...
... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...
What?
For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string.
Why?
Because my understanding with regular expressions is ...
What?
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author.
Why?
I used to have a third-party plugin ...
What?
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code.
Why?
I ...
What?
This is a quick note to show you how to convert a given comma delimited string into a database table:
Given: "Title,Forenames,Surname"
Return:
ID Value
------ ----------------
...
... SQL scripts that can simply be used to search an entire database for a particular string of word(s).
I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, ...
... this is interpreted as a string and when converted to a number only retrieves the first value before the first comma. Consider the following, the first query is how MySQL interprets the query and the ...
... 2013, 2012.
The Solution
Bring up the field list of the report (so you see the fields panel)
Untick the filter that is not in alphabetical order
Click on the Refresh button
Re-Tick the filter ...
... command timeout for the connection. Please note that the property in the connection string does not supercede the individual command timeout property on an individual command object.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;default ...
In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and ...
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick ...
... reports though.
The error I'd get was
An error occurred during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the dataset DataSet1. ...
The Issue
After modifying a report and on running it, Report Builder 2.0 returns the following error:
An error occurred during local report processing.
An error has occurred ...
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.