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

  1. Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    your joomla database. Note that your database user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key,...

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

  2. Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/component/content/article/keyboard-and-mouse-shortcuts-in-google-chrome.html?catid=61&Itemid=165

    content, then press Ctrl+C. Copies content to the clipboard. Place your cursor in a text field, then press Ctrl+V or Shift+Insert. Pastes content from the clipboard. Place your cursor in a text field, then press Ctrl+Shift+V. Paste content from the...

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

  3. List all cron jobs for all usershttps://www.joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    cron directory. cat "${CRONDIR}"/* | clean_cron_lines >>"${temp}" # */ # Add each user's crontab (if it exists). Insert the user's name between the # five time fields and the command. while read user ; do crontab -l -u "${user}" 2>/dev/null |...

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

  4. SSRS Hide results table if emptyhttps://www.joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    moves to fill up the space... There are some suggestions on the net but they didn't work or didn't apply for me. I had to insert a rectangle that separates the textboxes (so fills up the empty space with an object)... The visibility expressions for both...

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

  5. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We...

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

  6. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/else/database/search-a-database-for-a-value-and-count-matching-rows.html

    FROM ' + @TableToProcess + ' WHERE ' + @p_Column + ' = ''' + CAST(@p_Value AS VARCHAR) + ''' GROUP BY ' + @p_Column + ''; INSERT #CountRecordsPerTablePerCol EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE...

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

  7. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; Make sure you have the INSERT INTO commands if this includes website data!!! Drop the table Reload the script you just modified.

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • 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

    ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ' FROM ' + @SchemaTableName; -- Copy given table data into temporary table INSERT INTO #myScrambledTable EXEC(@SqlToExecute); -- Drop dummy column from table declaration ALTER TABLE #myScrambledTable DROP...

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

  9. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    + ''', COUNT(*) AS Count FROM ' + @p_SearchTable + ' GROUP BY ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation; INSERT #ListDistinctValuesAndCounts EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @ColToProcess END CLOSE Cursor1; DEALLOCATE...

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

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

    value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27 Extracting the Gender: We're going to extract the value in between the opening and closing XML tags: -- Using...

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

  11. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    ENT_COMPAT, 'ISO-8859-15', true), ENT_COMPAT, 'UTF-8'); My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection)...

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

  12. Does Google Chrome Frame really improve performancehttps://www.joellipman.com/component/content/article/does-google-chrome-frame-really-improve-performance.html?catid=61&Itemid=165

    Go to Extensions > Template Manager Select the template and click on 'Edit' Click on 'Edit HTML' Look for the beginning tag Insert the code above just after the tag Click on 'Save' and you're done More Information:...

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

  13. Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new...

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

  14. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    (a giant parenthesis) is still there. Right-click on the grey header of the tablix row again (left-most grey part) Select "Insert Row" and I selected "Outside Group - Below". Done.

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

  15. Splatter Logohttps://www.joellipman.com/component/content/article/splatter-logo.html?catid=115&Itemid=165

    need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new layer beneath Go to Selection > Modify > Expand > 10 px Fill this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 41 - 55 of 55