Friday, March 06, 2015
   
Text Size
Login

Search

Total: 50 results found.

Search for:
Search Only:

Page 1 of 3

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. Category: (MySQL)

    What? So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be ...
    Created on 03 August 2013
  20. Category: (SQL)

    What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...
    Created on 24 July 2013

Help Develop!

Thank You! :c)



Connect: Google+

Visitors of the World

Latest Posts

  • Basic Android App using Google Maps and Current Location

    • Wed 25-Feb-15
      SOrry ive solved the previous error but having an error context.LOCATIO N_SERVICE);
      lindalee  
    • Wed 25-Feb-15
      Hi im getting an error getLastKnownLocation(provider) can not resolve provider any hekp
      lindalee
  • JDatabase: using the Joomla database with examples

    • Sat 28-Feb-15
      High Praise, Thx Scott! I still use this for myself, nice to know it was of some use to you.
      Joel L.  
    • Fri 27-Feb-15
      Wow, thank you so much, Joomla documents are written for those who can read Joomla documents. :lol: Your ...
      Scott N.  
    • Thu 26-Feb-15
      Clearly represented jfactory querys. This helped me a lot. Thank you very much. :-)
      Oddy