Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It appears as though the <code>fullCalendar</code> plugin requires an array of objects. So if <code>vEvents</code> looks like this:</p> <pre><code>var vEvents = [//this bracket starts an array {//this bracket starts an object title: 'new appointment',//this line defines the `title` property of the object it's in start: '12-OCT-2011 14:00'//this line defines the `start` property of the object it's in },//this ends the current object and the comma separates the two objects as items in an array { title: 'next appointment', start: '12-OCT-2011 15:00' } //note that there is not a comma here, it's important that commas are only between objects and there is no trailing comma at the end of the list of objects ];//this bracket ends the array </code></pre> <p>Then you should be able to just set the <code>events</code> option to the <code>vEvents</code> variable like this:</p> <pre><code>$('#calendar').fullCalendar({ ... //and now on to the event creation events: vEvents }); </code></pre> <p><strong>--UPDATE--</strong></p> <pre><code>//first, create an empty array var myEvents = []; //then iterate through your data for (var rowIx = 0; rowIx &lt; this.Data.Rows.length; rowIx++) { //and add an object, notice the `{` and `}` (brackets) that note the beginning and ending of an object definition myEvents.push({title : this.Data.Rows[rowIx][2].text, start : this.Data.Rows[rowIx][5].text;); } </code></pre> <p><code>.push()</code> adds a value onto the end of an array, so here we <code>.push()</code> an object onto an array. <code>title : this.Data.Rows[rowIx][2].text</code> adds the <code>title</code> property to the new object and maps the value you want to that property.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to pass content of variable to jquery function?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJasper
    1. USJasper
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to pass content of variable to jquery function?
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHe's building a **string** variable. It needs to be json-parsed first.
      singulars
      1. PO
      1. USDidier Ghys
    2. COI added some comments in my answer about building an array of objects. If he is building the data himself he might as well be doing it correctly right off rather than building it one way and then using another language to fix it.
      singulars
      1. PO
      1. USJasper
    3. COThank you Jasper, but how do I then get the array to be build dynamically? That's why I approached if with a string that "grows" until the loop over the records has finished...Again, I'm new to JavaScript so my questions may seem foolish, I know :-( So for example a var myEvents :[ title: this.Data.Rows[rowIx][2].text, start: this.Data.Rows[rowIx][5].text ]; does not seem to work
      singulars
      1. PO
      1. USStefan
 

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