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

  1. Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html

    but it's not very international and narrow-minded to think only English speakers will use Joomla! CMS. The below is for reference only: Language Codes af Afrikaans sq Albanian ar-sa Arabic (Saudi Arabia) ar-iq Arabic (Iraq) ar-eg Arabic (Egypt) ar-ly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

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

    article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source: http://docs.joomla.org/ for v1.5.x and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  3. Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) SELECT a.`id`, ( SELECT x.`id` FROM `v34_db`.`v34_assets` x WHERE x.`name` LIKE 'com_content.article.%' AND x.`name`...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB

  4. 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

    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 myself but this displays an AlertDialog designed by an XML layout file ("res/layout/dialog_edititem_photo"). The...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *

  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

    proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  6. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    fields button Parameter name (oracle input sp variable) and Parameter value (ssrs input parameter) Fields (field name=ssrs reference, field source=oracle sp field name) 1. Create a stored procedure using a cursor for SSRS CREATE OR REPLACE PROCEDURE...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  7. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you need permission to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  8. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the function if it already...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  9. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe Tape-Monkey 8475 Table: DMExtractReferenceTable ------------------------------ ID MapIn MapOut 1 0011 71 2 8475 84 3 7749 63 4 B110 92 -- so we have 1 director, 2 managers,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  10. T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    EmployeeNo QualificationRef -------------------------------- 001 00101 001 00101 Almost useful... but the qualification reference has to be unique. We're going to add the ROW_NUMBER() to the employee number to create a unique identifier. Try this:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  11. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  12. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  13. List of Font Awesomehttps://www.joellipman.com/articles/cms/website-development/list-of-font-awesome.html

    want in a modern website design. How? To use this list, you can either: Copy the font files to your template folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  14. Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    is an input field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey....

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB

  15. Preg_Replace all strings between two tagshttps://www.joellipman.com/articles/cms/website-development/php/preg-replace-all-strings-between-two-tags.html

    understanding with regular expressions is shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to comment if they...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  16. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    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 $string = ' 2/13/2013 10:37:24 PM Failure Incorrect...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  17. 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

    a Short Name (unsure of how this is used) Enter a descriptive "Full Name" as it will automatically display alongside any reference to the Message Group in the remaining screens. Check/ensure the "In Use?" is ticked. Store/save your SMG Setting up the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  18. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY coordinates. Export the report to Excel and all the fields in the section appear...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *

  19. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *

  20. A for loop within a for loop in MS-DOShttps://www.joellipman.com/component/content/article/a-for-loop-within-a-for-loop-in-ms-dos.html?catid=51&Itemid=165

    with a double-percent rather than just the one: -- the following loops through directory for any file beginning with Reference FOR %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: InitializingFile_123.csv InitializingFile_456.csv -- the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
Results 61 - 80 of 83