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

  1. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    channel (see "Sources" below): portrait: ::5 Premium Portrait Photography::4 well-lit, sharp-focus, high-quality, artistic, unique, award-winning photograph, Canon EOS 5D Mark IV DSLR, f/8, ISO 100, 1/250 second, close-up, natural light, professional,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  2. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" which is the file name as it is to be displayed in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

    hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note on one of Microsoft...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  5. XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

    Adds multiple schemas with the same target namespace to a document key Specifies an attribute or element value as a key (unique, non-nullable, and always present) within the containing element in an instance document keyref Specifies that an attribute...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  6. Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

    which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := "My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole content Needle1b := "" ; Needle1b is a marker for a value...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  7. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    EmpNumber QualificationRef 001 00101 001 00102 002 00201 -- Qualification Ref is a unique number using the -- Employee Number concatenated with a 2 digit sequence -- number (padded with zeros) How? So how do we do it? In the above example, Joel Lipman...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  8. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    Ref: Another single line text field Candidate x JobOpening Name: Mandatory name field that we will use so as to create unique records The connection Within any syntax editor of ZohoRecruit (where you type the deluge code), there will be a "Connections"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

    space with same access details. Database Setup For JoelLipman.Com to do: Backup original database if exists already Assign unique database name Assign unique database username/password Add the user to the database Create test database with same user...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

    NULLName of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ReportIDuniqueidentifierNULLThe ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  11. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list to be left with just the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

    execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    use but also the database name - by this step, "my_new_database" should have been renamed). Save the SQL file, this is now unique to your website and this process. It does not contain usernames or passwords but has the real database names and all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

    that sounded good enough for our customers. The Workaround we actually went with Our Stored Procedure would check if the unique identifying number (in our case StudentID) matches a record in the database table and that the request number was...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Joes Revolver Map (JRM)https://joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

    your ID from the script code: For example: rm_f1st('0','280','true','false','000000','3sv7MUqXeMI','true','ff0000'); or The Unique ID code would be "3sv7MUqXeMI" (without the double-quotes) How to do this without using this extension: Visit the website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  18. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

    This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

    an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits)...

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

    strict liability, or other tort. Privacy Policy What other members know about you: • If shared, your public name (not unique and only the first name) • Your selected aircraft (by public name or \"anonymous\") What joellipman.com stores about you: • Your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 1 - 20 of 29

Please publish modules in offcanvas position.