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

  1. SSIS Skip Rows in Excel Source filehttps://joellipman.com/component/content/article/ssis-skip-rows-in-excel-source-file.html?catid=74&Itemid=165

    rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  4. SSRS Zero Paddinghttps://joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  5. Reorder Columns in a Tablehttps://joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  6. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Finish Data Source Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    database column by order of most used 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: *
  8. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally followed by 'b', then followed by 'c'--you use the following regular expression: ab?c This...

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

    believed me when I raised the alarm but hey-ho. How? I'm going to show you how to do this with a .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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  11. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    Other examples out there will work, but I found that once the list count increased the number of digits (eg. 1.10) the text would be more indented (relative) to 1.1. I need all list elements to be all perfectly aligned. // What I Have 1. Item 1 1.1 Item...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  12. Embed an FLV file into a web pagehttps://joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and publish The Code: Additional:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  13. Parse a HTML Table into a ListViewhttps://joellipman.com/articles/cms/website-development/html/parse-a-html-table-into-a-listview.html

    ) ColIndex++ } } Snippets Assume that "Haystack" is the string of code you want to parse (all content). Function ExtractText extracts text given a unique string to mark the start of the extract (1a), a second string (1b) to refine the starting position...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  14. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *
  15. Counting the occurence of a word within a string: Benchmarkhttps://joellipman.com/articles/cms/website-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

    and carried out a benchmark test on the most popular ways of counting the occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took :...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  16. SITS: Export field code and namehttps://joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text which should be |, if you try to apply you should be prompted to convert to use gold characters: Test the XET export and you...

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

    a complex type that contains mixed content or elements only complexType Defines a complex type element documentation Defines text comments in a schema (must go inside annotation) element Defines an element extension Extends an existing simpleType or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: en-GB
  18. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  19. Passwords: Did-you-knowhttps://joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    per second! (source: Lockdown.co.uk 01/2007) By default, the Mozilla Firefox browser lists your stored passwords in plain text to anyone with access to your browser through the tools > options > security > Saved passwords > Show All. This includes a...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  20. CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=53&Itemid=165

    and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
Results 101 - 120 of 124