Wednesday, July 23, 2014
Text Size


Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (AutoHotkey)

    ...  units := "d" ; default to days Else StringLeft, units, units, 1 enddate -= startdate, %units% return enddate } ; ********************************************************************************************************************************************************************** ; ...
    Created on 17 July 2014
  2. Category: (MS Integration Services)

    ... the example below. Add a variable (preferably to the scope of the package) called "SourceExtractFile" and give it the data type "String". Set the Value to the full path and the first file including ...
    Created on 13 June 2014
  3. Category: (Transact SQL)

    ... @c= substring(@Text,@i,1), @Ret = @Ret + CASE WHEN @Reset=1 THEN UPPER(@c) ELSE LOWER(@c) END, @Reset = CASE WHEN @c like '[a-zA-Z'']' THEN 0 ELSE 1 END, @i ...
    Created on 04 June 2014
  4. 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
  5. 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
  6. Category: (Transact SQL)

    What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...
    Created on 27 March 2014
  7. Category: (MS-Dos)

    ... copies only those files whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string  ...
    Created on 23 February 2014
  8. Category: (Joomla)

    ... ReCaptcha: 1. Open the file: /plugins/captcha/recaptcha/recaptcha.php 2. Find the following string in the OnDisplay function: return '<div id="dynamic_recaptcha_1"></div>'; 3. ...
    Created on 24 November 2013
  9. Category: (MS Reporting Services)

    ... string to the data source is held in the parameters (though, with more time, we could have tried changing the "connection string" parameter to "shared datasource" parameter where the user can select which ...
    Created on 22 November 2013
  10. Category: (MS Windows)

    ... following image: I create another column with the symbol omitted using the formula: =SUBSTITUTE(B3, "₱", "") Which leaves the value as a literal string... Now the tricky part, how to ...
    Created on 15 November 2013
  11. Category: (MS Reporting Services)

    ... DataSource In the folder where you put your Data Sources, click on the button "New Data Source" Specify the details, especially the connection string (which the system account can use). Set "Connect ...
    Created on 11 November 2013
  12. Category: (SQL)

    ... character in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching character list to specify characters that ...
    Created on 28 October 2013
  13. Category: (General Joomla!)

    ... encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string. STRING Removes HTML HTML Allows basic HTML ARRAY Forces value ...
    Created on 17 October 2013
  14. Category: (MS Integration Services)

    ...  { // Check type for all string properties if (object.ReferenceEquals(p.PropertyType, typeof(string))) { // declare two arrays  ...
    Created on 04 October 2013
  15. Category: (General Web Development)

    ... for errors. Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example // ...
    Created on 05 September 2013
  16. Category: (Transact SQL)

    ...  EmployeeNo , DaysOffSick , DateOfSickness ,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values ...
    Created on 23 August 2013
  17. Category: (SQL)

    ... lookup the username in the database, retrieving the values we need. This script will apply to sites where the username is alphanumeric (no symbols, punctuation allowed) and where the password is any string ...
    Created on 19 August 2013
  18. Category: (PHP)

    ... so I'm posting it here... And now people can see how I safeguard my sites but obscurity should never be a recommended security measure. How This function will check a posted string for suspicious ...
    Created on 02 August 2013
  19. Category: (MySQL)

    ...  MODIFY COLUMN misplaced_column VARCHAR(13) NOT NULL DEFAULT 'DefaultString' COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), ...
    Created on 22 July 2013
  20. Category: (MS Integration Services)

    What? Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ...
    Created on 14 May 2013

Latest Posts

  • Joes Quicklist Weblinks (JQW)

    • Thu 17-Jul-14
      Hi, thanks a lot. But I have got a problem with download it. Error: "File could not be found Important!
    • Tue 15-Jul-14
      Hi Artur, I forgot to get back to you sooner. I was going to include a set of instructions to do this ...
    • Mon 14-Jul-14
      Hi Skarosg, Not sure if we took this to e-mail but I noticed your site is displaying the images now.
    • Fri 11-Jul-14
      Hi, How can I put user name and category of weblink in module, near the date? Thanks..
  • Joes Word Cloud (JWC)

    • Tue 17-Jun-14
      I'm using JE 3.1.19 stable.