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

  1. Set up Desktop SlideShow in Windows 7https://www.joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    group policies control our every deviation from the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  2. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/else/database/create-read-only-database-user-in-sql-server.html

    to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx db_accessadmin...

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

    "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query...

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

    within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Drop If Object Existshttps://www.joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html

    have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I wanted a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  6. 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

    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 I need to delimit based on the dot/period (.) and use substring...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  7. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet; Should yield something like: MYRESULTSET -------------------------------------------------------------------------------- STUDENTID STUDENT_USERNAME...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  8. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    Virtual Hosts I used to have an account with 1&1 (oneandone.co.uk) and I would strongly urge Joomla developers to avoid them like the plague. They have been less than helpful and when I only had one Joomla site with them, they still would block me...

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

    report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the deployed report on the Reporting Server: An error occurred during client rendering. An error has...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    ends halfway in a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what date...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  11. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Crude solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on how to do this is tough work. What...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  12. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID'];...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  13. Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    bosses that you need the MySQL Workbench as this is FREE and with all the features you'd expect a GUI administration kit like this to have.

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  14. Country Lookup by IP address CSVhttps://www.joellipman.com/articles/else/database/mysql/country-lookup-by-ip-address.html

    this data using other sources and in time a region by IP for more accuracy. Feel free to feedback. It's FREE to download unlike others which is probably why I made the generator in the first place but I do like to make people sign up so I can gauge the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    in the web browser window when the page first loads is described as being ‘above-the-fold’. "belt-and-suspenders" Just like the UK's idiom "belt-and-braces", ‘Belt-and-suspenders’ describes an approach to web design where provision has been made for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  16. What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    The computer had two CD-Roms. The user put the disc in one of the drives but was pressing eject on the second drive. Like these? Share your experiences as comments below :)

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  17. Embed an FLV file into a web pagehttps://www.joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: *
  18. Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    + minutes).slice(-2); str3 = ("0" + seconds).slice(-2); return str1 + ':' + str2 + ':' + str3; } The HTML would be something like: Time Remaining: Time Elapsed:

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: *
  19. 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

    If you want this, I think the rewrite rule is: RewriteCond %{REQUEST_URI} ^/([\w]+).html [NC] But, er, I like that first check (myFolder) that the submitted URL matches the format of your site (and a lot more opportunity to check for malicious code).

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  20. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    with a value that already exists in the table, you will get an error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 141 - 160 of 186