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 241 results were found.

  1. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not...

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

  2. Making a CD copy with only one drivehttps://www.joellipman.com/component/content/article/making-a-cd-copy-with-only-one-drive.html?catid=80&Itemid=165

    drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER Right-click on the CD drive and select OPEN Go to EDIT > SELECT ALL > EDIT > COPY PASTE to a temporary folder Select all the files, right-click on them and select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  3. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean...

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

  4. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft Help sites: Office 2010: Select the data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only"...

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

  5. Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-get-unique-values-of-a-field.html

    and even on this website so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map();...

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

  6. Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    v3.2.# ------ ----------------------------------------------------------------- INSERT INTO my_wordpress_db.wp_posts SELECT id 'ID', 1 'post_author', created 'post_date', created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title...

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

  7. List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS PageID, CONVERT(p.page_title USING latin1) AS PageTitle, CONVERT(t.old_text USING latin1) AS PageContent,...

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

  8. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." Browse to the first file in the folder to loop through and select it. Set the connection manager...

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

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

    showed the heading "Equipment". Iteration in T-SQL? Unlike good old MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary...

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

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

    I get warning errors (with an end!) BEGIN -- initial query to get me the student ID based on the inputted parameter SELECT student_accounts.student_id INTO p_STUDENT_REF FROM student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME;...

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

  11. Problem creating SSRS report subscriptionshttps://www.joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data source" and test the connection. Ensure...

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

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

    the structure and data. Thinking inside of the box I think everyone suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was...

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

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

    3 tape-monkeys Now suppose we had a convoluted query which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON...

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

  14. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS AcademicWeek, DATE_FORMAT(calendar.StartDate, '\%e-\%b-\%y') AS Mon, DATE_FORMAT(DATE_ADD(calendar.StartDate,...

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

  15. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM a_pretend_table WHERE a_condition=true ) AS my_field_name FROM...

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

  16. Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-json-via-a-shopify-webhook.html

    your Zoho Creator: Log-in to your ZohoCRM Create a Connection Go to Setup > Developer Space > Connections > Add Connection Select the Zoho Creator connection, give it a Connection Name, I'm going with joels_creator Give it a lowercase Connection Link...

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

  17. Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-list-of-timezones.html

    A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT...

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

  18. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    Login to Zoho One Go to Settings (cog in top right) Click on Applications i the sidebar Click on the Add Application button Select Creator by clicking the Add button below it Link it if applicable to your super admin account Create an app, a form and...

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

  19. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    Getting to the development-side Login to ZohoCRM as a super-admin Go to Setup (cog icon in the top right) Under Zia, select "Conversational AI" Click on the link "Zia Developer Console" (yours will have the specific OrgID in the URL). Click on "Add...

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

  20. Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-change-system-field-length.html

    to ZohoCRM > Setup > Modules and Fields Click on the "Deals" module (or whichever module you are wanting to edit) > and select the layout (eg. "Standard") Click on the ellipsis/3 dots icon of the system field you want to hack and select "Edit...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 41 - 60 of 241