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

  1. Connection Strings for SQL Serverhttps://joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

    version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the key "Encryption" with "Encrypt" instead....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *

  2. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions accordingly.

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  3. Administrator Program Shortcut without Prompthttps://joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  4. T-SQL DateTimestampshttps://joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  5. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a parameter then the above will simply return an error. Also, if it was this easy, I wouldn't need to post this note on my website. Thinking outside...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  6. Compare two databases using T-SQLhttps://joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the above which does a little more of the work, requires in the following query for you to replace the terms "myDB1" with the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  7. T-SQL: Parse an XML valuehttps://joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    *' This is because more than one record was returned so you need to surround with brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes from root node - STAFF SELECT Event_XML.query('/STAFF') FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  8. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    things to see the results of this stored procedure. The following are commands that I would run to view the results of the above example: VARIABLE myResultSet REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  9. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing the overall report. How? Browsing the web for a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  10. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    value C:\ORACLE\product\11.2.0\client_1 OK all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein matched the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  11. Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    1 Welcome This is HP 2 Copyright This site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  12. Convert foreign characters to English alphabethttps://joellipman.com/articles/else/database/mysql/convert-foreign-characters-to-english-alphabet.html

    WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all:...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  13. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    http://www.ukreg.com/ International Domain Registration Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  14. Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the page first loads is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  15. Difference between two dates - the midnight hourhttps://joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    = number_format(((strtotime($this_time_from_sql)-strtotime($this_time_from_sql))/60)/60, 2); // Using the examples above this is doing the following: 2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 = -23.00...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  16. What's the problem? Amusing computer issueshttps://joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    and tell me.". "Hang on its on the other side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  17. Vertically align an asterisk on a linehttps://joellipman.com/articles/cms/website-development/css/vertically-align-an-asterisk-on-a-line.html

    beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before: Box List After * 1 2 3 * 1 2 3 How? Decrease the line-height of the asterisk and vertically...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  18. Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    !!! */ background-color: #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be affected). If your website...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  19. This file contains HTML or script code that may be erroneously interpreted by a web browserhttps://joellipman.com/articles/cms/website-development/html/this-file-contains-html-or-script-code-that-may-be-erroneously-interpreted-by-a-web-browser.html

    'pdf', 'zip', 'flv', 'swf'); Online forums are saying this is it, but my system still didn't allow them and returned the above error... Secondly: Edit your /includes/specials/SpecialUpload.php file and add the following line shortly after the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB

  20. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was created with the following code: Explanation type="text" - standard attribute that tells the field this is an input...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
Results 141 - 160 of 179