Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming solution is required, the following 139 results were found.

  1. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    order. I'm writing this article as it had gone through several partners before us and even Zoho themselves without a solution. This took my team the best part of two months to find a solution. How? Disclaimer! There may be many ways of doing this, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

    A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers on each row and then the campaigns as columns. What we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    It is possible. The article below documents it but as this is a fair bit of coding, you may want to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that you will need ZohoCRM. I've tried using the "Incoming Webhooks" feature of ZohoBooks but realised the word...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

    tag id","status":"error"} -> Error was due to trying to assign map with removed key to a new map. -> Solution was to remove the assignment and simply keep m_Tag.remove("id");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

    for foreach() in /home/.../components/com_content/helpers/route.php on line 106 After googling I found an unlikely solution which is becoming typical of Joomla. I hadn't switched the site to SEF friendly yet but I did this just to follow along with the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

    Suggestions by Wikipedia If you are having difficulty understanding a problem, try drawing a picture. If you can't find a solution, try assuming that you have a solution and seeing what you can derive from that ("working backward") If the problem is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  8. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

    on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  9. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the zoho.crm.getRelatedRecords() not retrieving related records which are clearly visible when using...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

    (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    this with you in case this your problem too. Source: Joomla Forum: http://forum.joomla.org/viewtopic.php?f=433&t=198257 My Solution I have over 20 joomla websites on my virtual server and I haven't had this problem. I setup a website with about 20...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

    Note that I am using the method of hiding the input button and putting an image over it. The code above is only really a solution to if you have one image that you are applying this mouseover effect to. With a bit more time, you could tidy up the code...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  13. Write a Calendar in Autohotkeyhttps://www.joellipman.com/articles/automation/autohotkey/write-a-calendar-in-autohotkey.html

    GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this year is a leap year Check1:=Mod(A_YYYY,4) Check2:=Mod(A_YYYY,100) Check3:=Mod(A_YYYY,400) if...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    include('index.php'); There is some more text but it's in /* lines */ which means these are comments. The quick solution is: $_REQUEST['tmpl'] = 'component'; $offensive_words=array("viagra","cialis","[url=","porn","pfizer"); if (is_array($_GET))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

    Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/ http://www.cleverdot.com/ Domain Registrars for domains already...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

    without installing anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  17. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

    shockproof BUT NOT joe-proof!... I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  18. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
Results 41 - 60 of 139

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.