Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here is my SimpleValidationTextArea. Basically I've merged dijit/form/ValidationTextBox and dijit/form/TextArea. This code is ugly and needs some improvements but it works ;) </p> <pre><code>define("dijit/form/SimpleValidationTextArea", [ "dojo/_base/declare", // declare "dojo/_base/kernel", // kernel.deprecated "dojo/i18n", // i18n.getLocalization "./TextBox", "../Tooltip", "dojo/text!./templates/ValidationTextBox.html", "dojo/dom-class", // domClass.add "dojo/sniff", // has("ie") has("opera") "dojo/i18n!./nls/validate" ], function(declare, kernel, i18n, TextBox, Tooltip, template, domClass, has){ //To use this widget you need to add this line to your css file //errorBorder{ border-color: #D46464; } var SimpleValidationTextArea; return SimpleValidationTextArea = declare("dijit.form.SimpleValidationTextArea", TextBox, { /* from SimpleTextarea */ // summary: // A simple textarea that degrades, and responds to // minimal LayoutContainer usage, and works with dijit/form/Form. // Doesn't automatically size according to input, like Textarea. // // example: // | &lt;textarea data-dojo-type="dijit/form/SimpleTextarea" name="foo" value="bar" rows=30 cols=40&gt;&lt;/textarea&gt; // // example: // | new SimpleTextarea({ rows:20, cols:30 }, "foo"); baseClass: "dijitValidationTextBox dijitTextArea", // rows: Number // The number of rows of text. rows: "3", // rows: Number // The number of characters per line. cols: "20", templateString: "&lt;textarea ${!nameAttrSetting} data-dojo-attach-point='focusNode,containerNode,textbox' autocomplete='off'&gt;&lt;/textarea&gt;", buildRendering: function(){ this.inherited(arguments); if(has("ie") &amp;&amp; this.cols){ // attribute selectors is not supported in IE6 domClass.add(this.textbox, "dijitTextAreaCols"); } }, filter: function(/*String*/ value){ // Override TextBox.filter to deal with newlines... specifically (IIRC) this is for IE which writes newlines // as \r\n instead of just \n if(value){ value = value.replace(/\r/g,""); } return this.inherited(arguments); }, _onInput: function(/*Event?*/ e){ // Override TextBox._onInput() to enforce maxLength restriction if(this.maxLength){ var maxLength = parseInt(this.maxLength); var value = this.textbox.value.replace(/\r/g,''); var overflow = value.length - maxLength; if(overflow &gt; 0){ var textarea = this.textbox; if(textarea.selectionStart){ var pos = textarea.selectionStart; var cr = 0; if(has("opera")){ cr = (this.textbox.value.substring(0,pos).match(/\r/g) || []).length; } this.textbox.value = value.substring(0,pos-overflow-cr)+value.substring(pos-cr); textarea.setSelectionRange(pos-overflow, pos-overflow); }else if(this.ownerDocument.selection){ //IE textarea.focus(); var range = this.ownerDocument.selection.createRange(); // delete overflow characters range.moveStart("character", -overflow); range.text = ''; // show cursor range.select(); } } } this.inherited(arguments); }, /* -from SimpleTextarea */ // summary: // Base class for textbox widgets with the ability to validate content of various types and provide user feedback. // required: Boolean // User is required to enter data into this field. required: false, // promptMessage: String // If defined, display this hint string immediately on focus to the textbox, if empty. // Also displays if the textbox value is Incomplete (not yet valid but will be with additional input). // Think of this like a tooltip that tells the user what to do, not an error message // that tells the user what they've done wrong. // // Message disappears when user starts typing. promptMessage: "", // invalidMessage: String // The message to display if value is invalid. // The translated string value is read from the message file by default. // Set to "" to use the promptMessage instead. invalidMessage: "$_unset_$", // missingMessage: String // The message to display if value is empty and the field is required. // The translated string value is read from the message file by default. // Set to "" to use the invalidMessage instead. missingMessage: "$_unset_$", // message: String // Currently error/prompt message. // When using the default tooltip implementation, this will only be // displayed when the field is focused. message: "", // constraints: __Constraints // user-defined object needed to pass parameters to the validator functions constraints: {}, // pattern: [extension protected] String|Function(constraints) returning a string. // This defines the regular expression used to validate the input. // Do not add leading ^ or $ characters since the widget adds these. // A function may be used to generate a valid pattern when dependent on constraints or other runtime factors. // set('pattern', String|Function). pattern: ".*", // regExp: Deprecated [extension protected] String. Use "pattern" instead. regExp: "", regExpGen: function(/*__Constraints*/ /*===== constraints =====*/){ // summary: // Deprecated. Use set('pattern', Function) instead. }, // state: [readonly] String // Shows current state (ie, validation result) of input (""=Normal, Incomplete, or Error) state: "", // tooltipPosition: String[] // See description of `dijit/Tooltip.defaultPosition` for details on this parameter. tooltipPosition: [], _deprecateRegExp: function(attr, value){ if(value != SimpleValidationTextArea.prototype[attr]){ kernel.deprecated("SimpleValidationTextArea id="+this.id+", set('" + attr + "', ...) is deprecated. Use set('pattern', ...) instead.", "", "2.0"); this.set('pattern', value); } }, _setRegExpGenAttr: function(/*Function*/ newFcn){ this._deprecateRegExp("regExpGen", newFcn); this.regExpGen = this._getPatternAttr; // backward compat with this.regExpGen(this.constraints) }, _setRegExpAttr: function(/*String*/ value){ this._deprecateRegExp("regExp", value); }, _setValueAttr: function(){ // summary: // Hook so set('value', ...) works. this.inherited(arguments); this.validate(this.focused); }, validator: function(/*anything*/ value, /*__Constraints*/ constraints){ // summary: // Overridable function used to validate the text input against the regular expression. // tags: // protected return (new RegExp("^(?:" + this._getPatternAttr(constraints) + ")"+(this.required?"":"?")+"$")).test(value) &amp;&amp; (!this.required || !this._isEmpty(value)) &amp;&amp; (this._isEmpty(value) || this.parse(value, constraints) !== undefined); // Boolean }, _isValidSubset: function(){ // summary: // Returns true if the value is either already valid or could be made valid by appending characters. // This is used for validation while the user [may be] still typing. return this.textbox.value.search(this._partialre) == 0; }, isValid: function(/*Boolean*/ /*===== isFocused =====*/){ // summary: // Tests if value is valid. // Can override with your own routine in a subclass. // tags: // protected return this.validator(this.textbox.value, this.constraints); }, _isEmpty: function(value){ // summary: // Checks for whitespace return (this.trim ? /^\s*$/ : /^$/).test(value); // Boolean }, getErrorMessage: function(/*Boolean*/ /*===== isFocused =====*/){ // summary: // Return an error message to show if appropriate // tags: // protected var invalid = this.invalidMessage == "$_unset_$" ? this.messages.invalidMessage : !this.invalidMessage ? this.promptMessage : this.invalidMessage; var missing = this.missingMessage == "$_unset_$" ? this.messages.missingMessage : !this.missingMessage ? invalid : this.missingMessage; return (this.required &amp;&amp; this._isEmpty(this.textbox.value)) ? missing : invalid; // String }, getPromptMessage: function(/*Boolean*/ /*===== isFocused =====*/){ // summary: // Return a hint message to show when widget is first focused // tags: // protected return this.promptMessage; // String }, _maskValidSubsetError: true, validate: function(/*Boolean*/ isFocused){ // summary: // Called by oninit, onblur, and onkeypress. // description: // Show missing or invalid messages if appropriate, and highlight textbox field. // tags: // protected var message = ""; var isValid = this.disabled || this.isValid(isFocused); if(isValid){ this._maskValidSubsetError = true; } var isEmpty = this._isEmpty(this.textbox.value); var isValidSubset = !isValid &amp;&amp; isFocused &amp;&amp; this._isValidSubset(); this._set("state", isValid ? "" : (((((!this._hasBeenBlurred || isFocused) &amp;&amp; isEmpty) || isValidSubset) &amp;&amp; (this._maskValidSubsetError || (isValidSubset &amp;&amp; !this._hasBeenBlurred &amp;&amp; isFocused))) ? "Incomplete" : "Error")); this.focusNode.setAttribute("aria-invalid", isValid ? "false" : "true"); if(this.state == "Error"){ this._maskValidSubsetError = isFocused &amp;&amp; isValidSubset; // we want the error to show up after a blur and refocus message = this.getErrorMessage(isFocused); domClass.add(this.domNode, "errorBorder"); }else if(this.state == "Incomplete"){ message = this.getPromptMessage(isFocused); // show the prompt whenever the value is not yet complete this._maskValidSubsetError = !this._hasBeenBlurred || isFocused; // no Incomplete warnings while focused }else if(isEmpty){ message = this.getPromptMessage(isFocused); // show the prompt whenever there's no error and no text }else if(this.state == ''){ //everything is fine domClass.remove(this.domNode, "errorBorder"); } this.set("message", message); return isValid; }, displayMessage: function(/*String*/ message){ // summary: // Overridable method to display validation errors/hints. // By default uses a tooltip. // tags: // extension if(message &amp;&amp; this.focused){ Tooltip.show(message, this.domNode, this.tooltipPosition, !this.isLeftToRight()); }else{ Tooltip.hide(this.domNode); } }, _refreshState: function(){ // Overrides TextBox._refreshState() if(this._created){ this.validate(this.focused); } this.inherited(arguments); }, //////////// INITIALIZATION METHODS /////////////////////////////////////// constructor: function(params /*===== , srcNodeRef =====*/){ // summary: // Create the widget. // params: Object|null // Hash of initialization parameters for widget, including scalar values (like title, duration etc.) // and functions, typically callbacks like onClick. // The hash can contain any of the widget's properties, excluding read-only properties. // srcNodeRef: DOMNode|String? // If a srcNodeRef (DOM node) is specified, replace srcNodeRef with my generated DOM tree. this.constraints = {}; this.baseClass += ' dijitSimpleValidationTextArea'; }, startup: function(){ this.inherited(arguments); this._refreshState(); // after all _set* methods have run }, _setConstraintsAttr: function(/*__Constraints*/ constraints){ if(!constraints.locale &amp;&amp; this.lang){ constraints.locale = this.lang; } this._set("constraints", constraints); this._refreshState(); }, _setPatternAttr: function(/*String|Function*/ pattern){ this._set("pattern", pattern); // don't set on INPUT to avoid native HTML5 validation }, _getPatternAttr: function(/*__Constraints*/ constraints){ // summary: // Hook to get the current regExp and to compute the partial validation RE. var p = this.pattern; var type = (typeof p).toLowerCase(); if(type == "function"){ p = this.pattern(constraints || this.constraints); } if(p != this._lastRegExp){ var partialre = ""; this._lastRegExp = p; // parse the regexp and produce a new regexp that matches valid subsets // if the regexp is .* then there's no use in matching subsets since everything is valid if(p != ".*"){ p.replace(/\\.|\[\]|\[.*?[^\\]{1}\]|\{.*?\}|\(\?[=:!]|./g, function(re){ switch(re.charAt(0)){ case '{': case '+': case '?': case '*': case '^': case '$': case '|': case '(': partialre += re; break; case ")": partialre += "|$)"; break; default: partialre += "(?:"+re+"|$)"; break; } }); } try{ // this is needed for now since the above regexp parsing needs more test verification "".search(partialre); }catch(e){ // should never be here unless the original RE is bad or the parsing is bad partialre = this.pattern; console.warn('RegExp error in ' + this.declaredClass + ': ' + this.pattern); } // should never be here unless the original RE is bad or the parsing is bad this._partialre = "^(?:" + partialre + ")$"; } return p; }, postMixInProperties: function(){ if(!this.value &amp;&amp; this.srcNodeRef){ this.value = this.srcNodeRef.value; } this.inherited(arguments); this.messages = i18n.getLocalization("dijit.form", "validate", this.lang); this._setConstraintsAttr(this.constraints); // this needs to happen now (and later) due to codependency on _set*Attr calls attachPoints }, _setDisabledAttr: function(/*Boolean*/ value){ this.inherited(arguments); // call FormValueWidget._setDisabledAttr() this._refreshState(); }, _setRequiredAttr: function(/*Boolean*/ value){ this._set("required", value); this.focusNode.setAttribute("aria-required", value); this._refreshState(); }, _setMessageAttr: function(/*String*/ message){ this._set("message", message); this.displayMessage(message); }, reset:function(){ // Overrides dijit/form/TextBox.reset() by also // hiding errors about partial matches this._maskValidSubsetError = true; this.inherited(arguments); }, _onBlur: function(){ // the message still exists but for back-compat, and to erase the tooltip // (if the message is being displayed as a tooltip), call displayMessage('') this.displayMessage(''); this.inherited(arguments); } }); }); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODojo validation of a textarea
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USmalan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

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