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

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

    t0 WHERE [pretendField]='elephantastic' -- insert some empty rows to blank out later as separators (select from your existing table, needs to contain data to order by so that it's the last row of each day -- if grouping by day -- basically insert a row...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    under the Server Administration section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    and submit to Client Apply chosen template Design and Layout Implementation Corporate Logo Create initial logo and replace existing template logo with this one Discuss suitability and variances Convert, format, or create vector-based version of the logo...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. 301 Redirect using htaccess filehttps://joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  5. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    The error I was getting was Error: Failed to retrieve directory listing though I could access the folders if I browsed the existing folders by entering it in the remote directory field. Still no files or folders would show. There's a good bit of...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
  6. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    Slide divs to be added inside the "inner_window". Move the slides in from right to left with a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed slide. Replace contents of the hidden slide...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  7. XML Schema Referencehttps://joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    Defines text comments in a schema (must go inside annotation) element Defines an element extension Extends an existing simpleType or complexType element field Specifies an XPath expression that specifies the value used to define an identity constraint...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  8. Modifying columns in a tablehttps://joellipman.com/articles/else/database/modifying-columns-in-a-table.html

    making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
Results 41 - 48 of 48