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 wanted is required, the following 78 results were found.

  1. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    message :"See attached" Attachments :file:f_ChartExport ] */ // return "The function executed. Doesn't mean it did what we wanted to do. Just that it executed."; } Additional: The exported image will have a Zoho Analytics Logo on it. This is a setting....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  2. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    Survey & Zoho Analytics: Query to generate individual responses and grouped pages which may have grown a little but just wanted to record how to receive a Zoho Survey response in a Zoho CRM REST API function. Why? As above, didn't want to overload a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a template function I could use in future when I get this request again. The additional benefit of having this template is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    wondering how to get the default contact form in Joomla 1.5 to redirect you to another page after you submit it, or if you wanted to change the default text that is displayed "Thank you for your e-mail" to something else I will explain how in this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

    it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot more to do than just that. Instructions Open the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

    for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I wanted to make it bit more in-depth for this specific use. I'd love to hear if this helps you. Let me know if you find any mistakes...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    felt I had followed the instructions to the letter. I then played about, deleting the other templates other than the one I wanted (affinity) using the Styles tab in phpBB3's Administration Control Panel (eg. http://www.mysite.com/phpBB3/adm/). It would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  8. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    use the mentioned token based authentication. I find myself going through the motion and designing on a per-app basis so I wanted a standard way of doing it and I'll update this article as I improve on the code. How? So the plan is: Declare the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  9. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    to: Android Studio (Beta) 0.8.6 Google Android Maps API What? I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location....

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an ImageView. How? More as a reference for...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  11. Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    sub-activity; returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the starting page) will simply display a button to the map...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  12. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will add that if you wanted to put a message instead of hiding the table then following the below will also let you do this (requirements: common...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of time (all MORNING!) so I went with solution #2 (above) and added the OR clause to all my dataset queries and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is this doing what I wanted? Well NO. I have a table with the same report mentioned several times but just in a different week. I want a returned...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  15. SSRS Zero Paddinghttps://www.joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    Unfortunately Oracle also returns errors of less than 10000 so ORA-00201 would actually be returned as "-201". As I wanted a link so that the user can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    on the key on the right-hand side for SpecialPollInterval The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    base and match their setups as closely as possible. Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  19. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a page which has all of them in one place. So here you go, I hope it's of some use. If it's wrong then just post a comment at the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 41 - 60 of 78