Sunday, August 30, 2015
Text Size


Total: 50 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (PHP)

    Previously 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 ...
    Created on 28 March 2015
  2. Category: (Joomla)

    ... `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of deleting, I change the existing menu item alias from "about-us" ...
    Created on 13 March 2015
  3. Category: (Joomla)

    ... database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the text ...
    Created on 06 February 2015
  4. Category: (Microsoft)

    What? A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want ...
    Created on 06 November 2014
  5. Category: (Application Development)

    ... == RESULT_LOAD_IMAGE && resultCode == RESULT_OK && null != data && TAKE_OR_PICK == 2) { Uri selectedImage = data.getData(); String[] filePathColumn = ; Cursor cursor ...
    Created on 04 November 2014
  6. Category: (MySQL)

    What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...
    Created on 22 October 2014
  7. Category: (Transact-SQL)

    Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...
    Created on 07 July 2014
  8. Category: (MS Integration Services)

    ... and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? ...
    Created on 13 June 2014
  9. Category: (MS Reporting Services)

    Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. ...
    Created on 15 April 2014
  10. Category: (MS Reporting Services)

    ... first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent ...
    Created on 08 April 2014
  11. Category: (MS Reporting Services)

    ... column groups). The headers do not stay fixed at the top of the page anymore but then this isn't the show-stopper; being unable to see the bottom of the report was.  ...
    Created on 08 April 2014
  12. Category: (Transact-SQL)

    ... in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": <?xml version="1.0" ...
    Created on 27 March 2014
  13. Category: (Microsoft)

    What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
    Created on 06 March 2014
  14. Category: (General Joomla!)

    ... and order the data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then change it to 1. If it's name is "root..." and title is "Root Asset" ...
    Created on 26 February 2014
  15. Category: (Uncategorised)

    ...  We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) ...
    Created on 05 December 2013
  16. Category: (MS Windows)

    What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
    Created on 15 November 2013
  17. Category: (MS Integration Services)

    ... (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so ...
    Created on 04 October 2013
  18. Category: (Transact-SQL)

    ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...
    Created on 24 September 2013
  19. Category: (MySQL)

    ...  -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT ...
    Created on 09 September 2013
  20. Category: (Transact-SQL)

    Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...
    Created on 23 August 2013

Help Develop!

Thank You! :c)

Connect: Google+

Visitors of the World

Latest Posts