Sunday, December 21, 2014
   
Text Size
Login

Search

Total: 59 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Microsoft)

    ... to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N 116°35′51″E Beijing Shahezhen ...
    Created on 06 November 2014
  2. Category: (Application Development)

    ... position, View convertView, ViewGroup parent) { ViewHolder holder; if (convertView == null) { convertView = View.inflate(context, R.layout.rss_item, null); holder ...
    Created on 24 October 2014
  3. Category: (Product Documentation)

    ... is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to country) rules are currently ...
    Created on 24 October 2014
  4. Category: (Transact-SQL)

    ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ...
    Created on 20 August 2014
  5. Category: (XSLT)

    ... and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output ...
    Created on 18 August 2014
  6. Category: (SITS:Vision)

    ... code and then the inner SRL text which should be <<field_code.entity>>|<<field_name.entity>>, if you try to apply you should be prompted to convert to use gold characters: Test ...
    Created on 12 August 2014
  7. Category: (MS Integration Services)

    ... convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could ...
    Created on 05 August 2014
  8. Category: (Transact-SQL)

    What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
    Created on 04 June 2014
  9. Category: (MS Reporting Services)

    ... referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"", ...
    Created on 15 April 2014
  10. Category: (PHP)

    What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...
    Created on 27 March 2014
  11. Category: (MS Reporting Services)

    ... = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '') AND (Surname LIKE @GivenSurname OR @GivenSurname = '') AND (CONVERT(VARCHAR(10),DOB, 103) = @GivenDOB ...
    Created on 07 March 2014
  12. 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
  13. Category: (MS Integration Services)

    ... the full process of packaging the script into a reusable component. Example #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize ...
    Created on 04 October 2013
  14. Category: (Web Development)

    ... Code Injection Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if you need to convert them back later (eg. 034, 039). Do NOT allow any punctuation ...
    Created on 05 September 2013
  15. Category: (Transact-SQL)

    ... n ON n.type = 'P' AND n.number < CONVERT(int, LEFT(CAST( DaysOffSick AS INT ),3)) -- yields EmployeeNo DaysOffSick DateOfSickness Items -------------- ...
    Created on 23 August 2013
  16. Category: (Transact-SQL)

    What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...
    Created on 14 May 2013
  17. Category: (MS Integration Services)

    ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...
    Created on 14 March 2013
  18. Category: (MS Windows)

    ... going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ...
    Created on 13 February 2013
  19. Category: (PHP)

    ... comment if they do not: Surround string (apostrophes) with red styling Convert: this='a string'  »  this='a string' $string_formatted = preg_replace ( '/\'([^\']+)\'/', '<span ...
    Created on 07 February 2013
  20. Category: (SQL)

    ... '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, getdate())) Seconds to ...
    Created on 31 January 2013

Latest Posts

  • Basic Android App using Google Maps and Current Location

    • Wed 17-Dec-14
      Is that how it's spelt? setContentVie( "View". If not try going to build and "clean project". Also ...
      Joel L.  
    • Tue 16-Dec-14
      I have problem in "cannot resolved R" " setContentVie(R .layout.activit y_maps);" :cry: How to solve ...
      LucasR
  • Migrate Joomla! 1.5.x to 2.5.x+

    • Thu 18-Dec-14
      Interesting report LLiSEIL! I'll definitely have to review it when Joomla 3.5 comes out. Error 1: is ...
      Joel L.  
    • Tue 16-Dec-14
      * Categories: - duplicates, I suppose from the multiple times I launched the script. - love the notes ...
      LLiSEIL  
    • Tue 16-Dec-14
      SQL ERror 3 > -- Step 2) Import articles from J15 and insert as articles in J30 INSERT INTO `newbase_j25`.d ...
      LLiSEIL