... to an empty folder of its own
With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11)
Go to Insert > Module and paste the below code
Sub SplitData()
Dim WorkRng ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... Failed
Due to invalid expressions insert statement is terminated Line:(102)
Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132)
It's not in the documentation ...
What?
A quick article on how I displayed feeds from the company's social network pages in one page.
Why?
There are 3rd-party apps that let you do this, some paid, some not. This was for a staff ...
... characters and Western languages):
// insert after database connection and prior to database query (where $db_conn is your mysqli connection)
mysqli_set_charset($db_conn,"utf8");
// decode and display ...
... settings will be enabled and the ID is in the URL.
We will insert assets as new ones but associate these to the v25 assets.
Categories will be associated by comparing both databases' content tables. ...
What?
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document.
How?
Open up a new workbook.
Get into VBA (Press Alt+F11)
Insert ...
Applies To:
MS SQL Server 2008 R2
MS Windows 7 Enterprise (Client)
MS Excel 2010
What?
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...
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 ...
... first column to display an image based on the status result.
If I simply insert an image, the report would use the background color of the report.
How?
The issue exists if your image has transparent ...
...
INSERT
2014-03-27
Extracting the Gender:
We're going to extract the value in between the opening and closing XML tags:
-- Using .query()
SELECT
CAST(CAST(Event_XML ...
... This method blocks the addition of new output column from Advanced Editor as none are permitted. Called during Design Time
public override IDTSOutputColumn100 InsertOutputColumnAt(int outputID, ...
What?
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this.
How?
Taken from the best forum for programming Qs&As:
http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
... in the title.
\plugins\search\content\content.php: Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a');
// Add "Relevance" column
// ...
... for the blank rows and inserted in the next line) and creating discrepancies that would error the flow.
Solution Found!!!
Taking the idea that the Carriage Return (CR) or Line Feeds (LF) are ...
... inserting blank rows to act as dividers.
Microsoft Certified Responses:
"In the Excel connection you cannot skip Nth rows."
"It is not possible."
I am shocked at how responses to this and opinions ...
... on line 344
INSERT using JDatabaseQuery
Note: for Joomla v3.x, use db->execute() instead of db->query()
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->insert($db->quoteName('#__my_users'))
...
... 26 (Control+Z).
\\ A backslash (“\”) character.
\% A “%” character.
\_ A “_” character.
Additional
An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so:
INSERT ...
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.