Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Adapt the code from <a href="http://ajaxcontroltoolkit.codeplex.com/SourceControl/latest#Client/MicrosoftAjax/Extensions/String.js" rel="nofollow noreferrer">MsAjax string</a>.</p> <p>Just remove all of the <code>_validateParams</code> code and you are most of the way to a full fledged .NET string class in JavaScript.</p> <p>Okay, I liberated the msajax string class, removing all the msajax dependencies. It Works great, just like the .NET string class, including trim functions, endsWith/startsWith, etc.</p> <p>P.S. - I left all of the Visual Studio JavaScript IntelliSense helpers and XmlDocs in place. They are innocuous if you don't use Visual Studio, but you can remove them if you like.</p> <pre><code>&lt;script src="script/string.js" type="text/javascript"&gt;&lt;/script&gt; &lt;script type="text/javascript"&gt; var a = String.format("Hello {0}!", "world"); alert(a); &lt;/script&gt; </code></pre> <h3>String.js</h3> <pre><code>// String.js - liberated from MicrosoftAjax.js on 03/28/10 by Sky Sanders // permalink: http://stackoverflow.com/a/2534834/2343 /* Copyright (c) 2009, CodePlex Foundation All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * Neither the name of CodePlex Foundation nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS AS IS AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.&lt;/textarea&gt; */ (function(window) { $type = String; $type.__typeName = 'String'; $type.__class = true; $prototype = $type.prototype; $prototype.endsWith = function String$endsWith(suffix) { /// &lt;summary&gt;Determines whether the end of this instance matches the specified string.&lt;/summary&gt; /// &lt;param name="suffix" type="String"&gt;A string to compare to.&lt;/param&gt; /// &lt;returns type="Boolean"&gt;true if suffix matches the end of this instance; otherwise, false.&lt;/returns&gt; return (this.substr(this.length - suffix.length) === suffix); } $prototype.startsWith = function String$startsWith(prefix) { /// &lt;summary &gt;Determines whether the beginning of this instance matches the specified string.&lt;/summary&gt; /// &lt;param name="prefix" type="String"&gt;The String to compare.&lt;/param&gt; /// &lt;returns type="Boolean"&gt;true if prefix matches the beginning of this string; otherwise, false.&lt;/returns&gt; return (this.substr(0, prefix.length) === prefix); } $prototype.trim = function String$trim() { /// &lt;summary &gt;Removes all leading and trailing white-space characters from the current String object.&lt;/summary&gt; /// &lt;returns type="String"&gt;The string that remains after all white-space characters are removed from the start and end of the current String object.&lt;/returns&gt; return this.replace(/^\s+|\s+$/g, ''); } $prototype.trimEnd = function String$trimEnd() { /// &lt;summary &gt;Removes all trailing white spaces from the current String object.&lt;/summary&gt; /// &lt;returns type="String"&gt;The string that remains after all white-space characters are removed from the end of the current String object.&lt;/returns&gt; return this.replace(/\s+$/, ''); } $prototype.trimStart = function String$trimStart() { /// &lt;summary &gt;Removes all leading white spaces from the current String object.&lt;/summary&gt; /// &lt;returns type="String"&gt;The string that remains after all white-space characters are removed from the start of the current String object.&lt;/returns&gt; return this.replace(/^\s+/, ''); } $type.format = function String$format(format, args) { /// &lt;summary&gt;Replaces the format items in a specified String with the text equivalents of the values of corresponding object instances. The invariant culture will be used to format dates and numbers.&lt;/summary&gt; /// &lt;param name="format" type="String"&gt;A format string.&lt;/param&gt; /// &lt;param name="args" parameterArray="true" mayBeNull="true"&gt;The objects to format.&lt;/param&gt; /// &lt;returns type="String"&gt;A copy of format in which the format items have been replaced by the string equivalent of the corresponding instances of object arguments.&lt;/returns&gt; return String._toFormattedString(false, arguments); } $type._toFormattedString = function String$_toFormattedString(useLocale, args) { var result = ''; var format = args[0]; for (var i = 0; ; ) { // Find the next opening or closing brace var open = format.indexOf('{', i); var close = format.indexOf('}', i); if ((open &lt; 0) &amp;&amp; (close &lt; 0)) { // Not found: copy the end of the string and break result += format.slice(i); break; } if ((close &gt; 0) &amp;&amp; ((close &lt; open) || (open &lt; 0))) { if (format.charAt(close + 1) !== '}') { throw new Error('format stringFormatBraceMismatch'); } result += format.slice(i, close + 1); i = close + 2; continue; } // Copy the string before the brace result += format.slice(i, open); i = open + 1; // Check for double braces (which display as one and are not arguments) if (format.charAt(i) === '{') { result += '{'; i++; continue; } if (close &lt; 0) throw new Error('format stringFormatBraceMismatch'); // Find the closing brace // Get the string between the braces, and split it around the ':' (if any) var brace = format.substring(i, close); var colonIndex = brace.indexOf(':'); var argNumber = parseInt((colonIndex &lt; 0) ? brace : brace.substring(0, colonIndex), 10) + 1; if (isNaN(argNumber)) throw new Error('format stringFormatInvalid'); var argFormat = (colonIndex &lt; 0) ? '' : brace.substring(colonIndex + 1); var arg = args[argNumber]; if (typeof (arg) === "undefined" || arg === null) { arg = ''; } // If it has a toFormattedString method, call it. Otherwise, call toString() if (arg.toFormattedString) { result += arg.toFormattedString(argFormat); } else if (useLocale &amp;&amp; arg.localeFormat) { result += arg.localeFormat(argFormat); } else if (arg.format) { result += arg.format(argFormat); } else result += arg.toString(); i = close + 1; } return result; } })(window); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POUse of String.Format in JavaScript?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPeter Mortensen
    1. USSky Sanders
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUse of String.Format in JavaScript?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    1. COI didn't know that it was possible for Javascript to look like C ... :-D. Very nice work Sky, thanks for taking the time to comment it!
      singulars
      1. PO
      1. USSean Vieira
    2. CO@Sean, I didn't write the code or comments, I just took the string class from msajax and removed/replaced all of the external dependencies. This gives you a lot of very useful and familiar string functions from .net. I figure if you are going to do something, do it right. Trivial, brittle string munging snippets are a recipe for a headache.
      singulars
      1. PO
      1. USSky Sanders
    3. COHmm I will check this out in a couple mins. Thanks but do you have to make everything a string? Like could I have a variable where "World" is like the String.Format takes in an object. Also is there a limit of how many place holders you can send in. I know String.Format after 3 place holders you got to send in an array in.
      singulars
      1. PO
      1. USchobo2
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload