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

  1. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    use both databases, reading from the old Joomla database and writing to the new one. To run this script, your user needs SELECT, INSERT and UPDATE privileges on the new database (only SELECT on the old database will do). Special care has been made to...

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

  2. Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

    to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling Creator: Zoho Creator: Change Radio into...

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

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

    `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) SELECT `id`, `name`, `username`, `email`, `password`, 1, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`,...

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

  4. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate)...

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

  5. Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

    date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates and days: SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate, DAYNAME( DATE_ADD( NOW( ) , INTERVAL 0 -...

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

  6. T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

    Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using .query() SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender FROM [dbo].[XML_EVENTS] -- Returns column...

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

  7. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

    that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any...

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

  8. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS `total_count`,...

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

  9. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    day to display on calendar SET @EndDate = DATEADD(DAY,6-DATEPART(WEEKDAY,@EndDate),@EndDate) ; WITH Dates([Date]) AS ( --Select First day in range SELECT CONVERT(DATETIME,@StartDate) AS [Date] UNION ALL --Add a record for every day in the range SELECT...

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

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

    $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p'));...

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

  11. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    @SqlToExecute nvarchar(max); DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE...

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

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

    I can refer to it later for shipping charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT po."Purchase Order Date" AS "PO Date", po."Purchase Order Number" AS "PO Ref", poi."Product ID" AS "PO Product ID",...

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

  13. SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it....

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

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

    it Setup the ODBC Connection Start > Programs > Administrative Tools > Data Sources (ODBC) Click on the System DSN tab Select "MySQL ODBC 5.1 Driver" > Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description...

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

  15. Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET @GivenCampus = 'Lansdowne Campus' SET @specifiedDate = (SELECT @GivenDate) SET @specifiedCampus = (SELECT @GivenCampus) -- Get columns SetId and WeekNumber from the weekstructure table...

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

  16. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of the workspace name that your ZohoDesk will sync with. Select Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that...

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

  17. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    and to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN...

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

  18. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    --Last slot of the day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  19. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

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

  20. SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 1 - 20 of 229

Joes Word Cloud

Please publish modules in offcanvas position.