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

  1. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    of a row $a_user_email = $rows[2]->email; Get a Row Count - getNumRows() Note that in Joomla, you have to run the count before using the data! $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select(array('name', 'email', 'username'))...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  2. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there is a chance one of your date...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  3. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    calendar showing 1 day with the hours on the top. Working hours only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  4. Include a carriage return in a column headinghttps://www.joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    and press Return/Enter. This has to be a label to the name of the column enclosed between square brackets or double-quotes: Before: SELECT calendar.WeekNumber AS [Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  5. 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

    for Windows 7 releases at Microsoft's Windows Update The Long Fix Now below are the notes I've had to try and fix this before (personally it was because Microsoft released an optional windows update that fixed my issue. check that this issue isn't being...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  6. DataTumble - Randomize Data Rowshttps://www.joellipman.com/articles/else/database/t-sql/datatumble-randomize-data-rows.html

    is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    ' ', u.LastName) "; Activity Query $w_value = $number_of_weeks_from_now; // usually 0 for this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li { counter-increment: myCounter; display: table-row; } ol > li:before { content: counters(myCounter, ".") ". "; display: table-cell; position: relative; left:-12px; } li ol > li:before {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  9. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related SMG Run SMG from the menu system...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  10. Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    as the AHK script. It took me a while to get the tooltip to show until I realised you have to specify the tooltip text BEFORE the gui,show command. The above example is used in a search form where "SearchButton" is the name of the variable (picture) to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  11. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    to built-in functions for AHK) alert(), getElementById(), getElementsByName(), getElementsByTagName(), focus(), click() Before we begin, this tutorial will be using examples that start with javascript: - which you will feed through the URL Address bar....

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  12. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    you see words in your post being replaced with ****, you have done something wrong. Please edit your post and tone it down before your timer runs out. To edit a post, click the "Edit" button right below it. Cheating the censor system is against the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  13. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg Image00002.jpg How? Before I continue, the undo may work in MS Windows (Control key + Z) but don't count on it. I'm going to use a short batch process but...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  14. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert media files before they can be transferred to the device, then this will list all the originals you no longer need and send them to the "Recycle...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=53&Itemid=165

    Studio - BIDS) along with Microsoft's Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=53&Itemid=165

    Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery and MooTools) conflicting with other scripts but do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  17. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    • A private key to use JoelLipman.com data Note: You should delete/uninstall this app or clear its data before giving your device to someone else as it can login to your online account automatically. Sharing: • Do not share security or personal details....

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    Zoho Deluge. Why? The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each one for the new month. How? First you have to get all the applicable fields from the settings API. In...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    screen has interrupted the connection. Your information is still secure because Google Chrome stopped the connection before any data was exchanged. You cannot visit 127.0.0.1 at the moment because the website sent scrambled credentials that Google...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    right of the modal */ .popupClose{position:relative !important;z-index:1000;top:28px;right:46px !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 21 - 40 of 109