Saturday, February 28, 2015
Text Size


Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Joomla)

    What? A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came ...
    Created on 06 February 2015
  2. Category: (Microsoft)

    ...  I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space ...
    Created on 06 November 2014
  3. Category: (Product Documentation)

    ... aerial surveillance system (less than 20kg equipped with a camera). Regulations different to the UK and US are still being reviewed prior to being added to the database but each country's aviation ...
    Created on 24 October 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: (SITS:Vision)

    ... article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination ...
    Created on 21 August 2014
  6. Category: (SITS:Vision)

    ... the XET export and you should get something like: <stu_codc>5826|England</stu_codc> Almost! If the code and it's short name/full name exist in the database, this works accordingly. ...
    Created on 12 August 2014
  7. Category: (MS Integration Services)

    ... to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will ...
    Created on 05 August 2014
  8. Category: (MySQL)

    Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to ...
    Created on 28 July 2014
  9. Category: (General Joomla!)

    What? A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT ...
    Created on 16 July 2014
  10. Category: (Transact-SQL)

    ...  It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located ...
    Created on 07 July 2014
  11. Category: (MS Integration Services)

    What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...
    Created on 13 June 2014
  12. Category: (MS Integration Services)

    ... Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS packages and VS2010 for database solutions running against SQL Server 2008 R2. We can use VS2012 for both but this requires upgrading all the ...
    Created on 09 June 2014
  13. Category: (Transact-SQL)

    ... NOT NULL DROP FUNCTION ufn_ProperCase GO Method #2: Revised version This version will use a variable table but it could be adapted to feed off any database table. As before it capitalizes words ...
    Created on 04 June 2014
  14. 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
  15. Category: (MS Reporting Services)

    ...  Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about ...
    Created on 07 March 2014
  16. Category: (General Joomla!)

    ... allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script ...
    Created on 28 February 2014
  17. Category: (General Joomla!)

    ...  Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick ...
    Created on 26 February 2014
  18. Category: (Uncategorised)

    What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...
    Created on 05 December 2013
  19. Category: (MS Reporting Services)

    ... "shared data source" to use). You might be able to get this working with a shared data source but in our case the shared data source didn't have the correct database (initial catalog) specified despite ...
    Created on 22 November 2013
  20. Category: (General Joomla!)

    ... the HOME folder - only check the subfolders. If they are, you've lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected ...
    Created on 17 November 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);
    • Wed 25-Feb-15
      Hi im getting an error getLastKnownLocation(provider) can not resolve provider any hekp
  • 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. :-)