Thursday, April 24, 2014
Text Size


Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. 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": <STAFF xmlns:xsi="">  ...
    Created on 27 March 2014
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. Category: (SQL)

    ... Expressions With Oracle Database ...
    Created on 28 October 2013
  9. Category: (Joomla)

    ... using the Joomla! administrator panel to navigate to global configuration, does not work! How? It isn't in the configuration.php file prior to Joomla! v1.6.x but in the database. Open the database ...
    Created on 08 October 2013
  10. Category: (Transact SQL)

    Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...
    Created on 24 September 2013
  11. Category: (MySQL)

    What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...
    Created on 09 September 2013
  12. Category: (Transact SQL)

    ... needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the Items column may vary from 1 and 10+. Not sure on why this ...
    Created on 23 August 2013
  13. Category: (SQL)

    ... and password login and demonstrates how to check against the database without including text that the website visitor submits. How? We're simply going to accept both the username and password, then ...
    Created on 19 August 2013
  14. 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
  15. Category: (Joomla! Tutorials)

    ... to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and ...
    Created on 07 May 2013
  16. Category: (Product Documentation)

    ... SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges. ip_lookup.php: ...
    Created on 17 March 2013
  17. Category: (MS Integration Services)

    ... data as a Flat File with fixed columns (Ragged Right). -- "Date" is the last column and can be blank in the source. -- "Date" must default to current date if blank for the target database (cannot be ...
    Created on 14 March 2013
  18. Category: (Microsoft)

    What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged ...
    Created on 08 March 2013
  19. Category: (Oracle SQL)

    Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping ...
    Created on 04 March 2013
  20. Category: (MS Windows)

    What? We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...
    Created on 13 February 2013

Latest Posts

  • 301 Redirect using htaccess file

    • Tue 15-Apr-14
      Further suggestion:
      RewriteRule ^(.*/)?assets/s 2dmain.html\?/( .*/)? $2 [R=301,L]
    • Thu 10-Apr-14
      Playing with some RegEx testers
      RewriteRule ^(.*\?/)?(?:$|( .+?)(?:(\.[^.]$ )|$)) $2 [R=301,L] ...
    • Wed 09-Apr-14
      I tried to redirect links from my old site to my new site, based on what I read in this thread. The old ...
  • Joes Revolver Map (JRM)

    • Tue 22-Apr-14
      Hi Manfred, Some downloaders have reported that the version of this module intended for Joomla 2.5.x ...
    • Sun 20-Apr-14
      Hello, is it possible to use this module also in joomla 3.2? Thanks Manfred
      Manfred V.