Friday, April 18, 2014
   
Text Size
Login

Search

Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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 http://www.mysite.com/blog/videos/2010/january/21.html // ...
    Created on 05 September 2013
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. Category: (Transact SQL)

    ... on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID ...
    Created on 14 May 2013
  19. Category: (MS Integration Services)

    ... Split Task: Check keycolumn is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. ...
    Created on 23 April 2013
  20. Category: (MS Windows)

    ...  Then it wouldn't be evaluated as an expression and perhaps Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have ...
    Created on 12 April 2013

Latest Posts

  • 301 Redirect using htaccess file

    • Tue 15-Apr-14
      Further suggestion:
      RewriteRule ^(.*/)?assets/s 2dmain.html\?/( .*/)? $2 [R=301,L]
      Webmaster  
    • Thu 10-Apr-14
      Playing with some RegEx testers
      RewriteRule ^(.*\?/)?(?:$|( .+?)(?:(\.[^.]$ )|$)) $2 [R=301,L] ...
      Webmaster  
    • 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 ...
      pelle
  • JComments 2.3.0 with ReCaptcha in Joomla 2.5.x

    • Fri 28-Mar-14
      You are a rockstar mate! thanks. Followed the steps listed and it worked! If only all tutorials were ...
      Kman
  • K2 Items disappear

    • Thu 03-Apr-14
      The fix works great, but the problem is occurring a couple of times a day. Any idea how to fix ...
      Larry C.