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

  1. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    to be more vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member to access these and I tend to piggyback on my client's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  3. JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

    to: Joomla CMS v2.5.11 (Joomla.org) jComments v2.3.0 (JoomlaTune.com) What? Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $method); curl_setopt($ch, CURLOPT_HTTPHEADER, $header); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); curl_close($ch);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  5. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    that got me nowhere: ssrs process parameter after report execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect based on a dataset value

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  7. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    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 bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  8. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  9. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    17 1144 2010-06-18 12:25:22 The How And here is the dilemma. The 3 below SELECT statements were derived from a post to the Stack Overflow website about the best way to check for rows in one table which don't exist in another. -- STATEMENT2 SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed support period post production - fees and estimates) Behind the scenes (code comments, user-defined function headers - incl. author, name,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  11. Slideshow div layer through a windowhttps://www.joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  12. Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    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 importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  13. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    ? new ActiveXObject('Microsoft.XMLHTTP') : new XMLHttpRequest(); // open the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  14. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    ground so will have to watch those landings and thats with thicker than stock pads Done. Here's a video and I will try to post some more: {youtube}tG6Yg0H11U8{/youtube} Noticed a problem with jello. This problem was due to the new propellers I was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  15. Zoho Deluge - Regex to Strip all non-numeric charactershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

    A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    =dateadd("d",-1, CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  17. Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the File Types tab Scroll down and select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  18. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa: $posted_datetime=$_POST['this_datetime']; $posted_datetime_array=explode(" ", trim($posted_datetime));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  19. Leap Motion and AR Dronehttps://www.joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

    with major platforms. The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
Results 81 - 99 of 99