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

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

    were scheduled explicitly. function lookup_run_parts() { while read line ; do match=$(echo "${line}" | egrep -o 'run-parts (-{1,2}\S+ )*\S+') if [[ -z "${match}" ]] ; then echo "${line}" else cron_fields=$(echo "${line}" | cut -f1-6 -d' ')...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  2. URL passed settings in Reporting Serviceshttps://www.joellipman.com/component/content/article/url-passed-settings-in-reporting-services.html?catid=75&Itemid=165

    &rs:Format=PDF&rc:PageWidth=11in&rc:PageHeight=8.5in Or a clean export to PDF with minimal margins http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  3. SSRS Redirect after a report is runhttps://www.joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

    report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. SSRS External Images don't displayhttps://www.joellipman.com/component/content/article/ssrs-external-images-dont-display.html?catid=75&Itemid=165

    or network share (file). Before you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  5. Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    Default port is 3306. Specifying port Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Named pipes Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword; It is the port value of -1 that tells...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  6. Hide a Drive per User in Windows 7https://www.joellipman.com/component/content/article/hide-a-drive-per-user-in-windows-7.html?catid=80&Itemid=165

    -- For Example: To Restrict B & C, enter 6 decimal -- " " E & G, enter 80 decimal or 50 hexadecimal Drive Letter Decimal Hex A 1 1 B 2 2 C 4 4 D 8 8 E 16 10 F 32 20 G 64 40 H 128 80 I 256 100 J 512 200 K 1024 400 L 2048 800 M 4096 1000 N 8192 2000 O...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  7. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")... 6/15/09 =Format(Fields!myDateTime.Value, "M/d/yyyy h:mmtt")... 6/15/2009 2:45PM =Format(Fields!myDateTime.Value, "MM/dd/yy HH:mm")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  8. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate) --Last day of month SET @EndDate = DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) --Last day to display on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  10. MySQL last year week month day trend periodshttps://www.joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE DATE(registerDate)=DATE(NOW()); -- BEFORE: count yesterdays total SELECT COUNT(id) FROM Table1 WHERE...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    LIKE CONCAT('%',@stringtoFind,'%') -- yields id title OldFoundInOld NewFoundInOld OldFoundInNew newText oldText 1 Article 1 yes no no Hello World Hello World 2 Article 2 yes no no Hello World Hello World 3 Article 3 yes no no Hello World Hello World Now...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/cms/website-development/css/three-boxes-two-roll-over-one-falls-out.html

    the equalize method to make div layers the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  13. htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/cms/website-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

    %{REQUEST_URI} !index.php RewriteCond %{REQUEST_URI} ^/([^\.]+)\/([\w]+).html [NC] RewriteRule .* index.php?myFolder=%1&myFiles=%2 [L] ErrorDocument 400 /error/?v=400 ErrorDocument 401 /error/?v=401 ErrorDocument 403 /error/?v=403 ErrorDocument 404...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  14. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    UTF-8, indicate encoding ! Bytes: 0xA0 0x3C 0x2F 0x73 in /home/public_html/my_folder/my_xml_processing_script.php on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory with simplexml_load_string()....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  16. Tagliatelle alla Carbonarahttps://www.joellipman.com/component/content/article/tagliatelle-alla-carbonara.html?catid=96&Itemid=165

    Ingredients 1 tbsp extra virgin olive oil 300g/10½oz prosciutto slices, cut into strips 1cm/½in wide 100g/3½oz unsalted butter 150ml/5fl oz white wine 6 free-range egg yolks 50g/2oz parmesan, freshly grated, plus extra for serving 50g/2oz aged...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  17. How To Make Chocolate Chip Cookieshttps://www.joellipman.com/component/content/article/how-to-make-chocolate-chip-cookies.html?catid=96&Itemid=165

    cookies, and with VideoJug's special recipe, it's easy to make the perfect chocolate chip cookie every time. You Will Need: 150 g sugar 160 g brown sugar, , packed 220 g butter 2 eggs, , large 2 tsp vanilla extract 280 g all-purpose flour 1 tsp baking...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  18. Joes Google Map (JGM) Downloadshttps://www.joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=105&Itemid=165

    Version Platform ChangeLog Options 1.1 - Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  19. Submit form as a server and not the client with cURLhttps://www.joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    can install it from here: http://curl.haxx.se/download.html I'm demonstrating this with 3 scripts on the intermediary server: 1. to display the HTML form (usually handled by the mobile app) 2. to send the values to the third-party (executable script) 3....

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  20. MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 201 - 220 of 337