Assuming because is required, the following 158 results were found.
-
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 shady and varies from language to language, I've written this article as a...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
yields......... Without cURL You'll have seen this all over the Internet as the accepted solution... Doesn't work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a place where you won't do harm--yes, choose a place where you won't do very much harm, and...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send about 7 at a time (as in schedule...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
third-party service/server/api Script #1: The HTML form: Sender: Receiver: Script #2: Send to third-party in XML format: (because that's the format they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because the next time this happens, I would have to repeat this, I would advise the above steps to remove parentheses.
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
following screenshot. A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the formula down, it may automatically modify the range. So the formula in the first row will be...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
you may have noticed that the range of words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
What? A quick article on making an "upload file" field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on how to disable user registration in Joomla! CMS version 1.5.x without using the Joomla! CMS back-end panel. Why? Because we're having some corruption issues and simply using the Joomla! administrator panel to navigate to global configuration, does...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
"Read More" to "Register to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
(BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
allowed to upload images or edit other profiles, each user has to do this with the permissions they've been given. Why? Because I can How? Setup an account with gravatar.com and they’ll give you a link to that picture (eg....
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB