Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Incidentally you can write a fluent API in VBScript. I built a library to facilitate inline creation of HTML to avoid the "tag soup" garbage and I'm using it in an app right now (that's how I found this question).</p> <p>Here's an example with a couple helpers wrapping the 960gs grid:</p> <pre><code>with html .open with head .open stylesheet_link "assets/stylesheets/960gs/reset.css" stylesheet_link "assets/stylesheets/960gs/960.css" stylesheet_link "assets/stylesheets/960gs/text.css" stylesheet_link "assets/stylesheets/app.css" .close end with with body .open with grid_container(12) .open call main .close end with .close end with .close end with </code></pre> <p>And then main could be similar to this:</p> <pre><code>with grid_row with grid_column(4) .id "nav-left" .open with ul .open li.open.contains( link_to("Google", "http://google.com") ).close li.open.contains( link_to_if(a &gt; b, "Microsoft", "http://microsoft.com") ).close li.open.contains( link_to_unless(a &gt; b, "Apple", "http://apple.com") ).close .close end with .close end with with grid_column("8 push_2") .id "main-content" .open h1.open.contains("Title Here").close do until recordset.eof p.class("record").open.contains(recordset("column_name")).close recordset.movenext loop .close end with end with </code></pre> <p>The way the lib is written it could generate XML with essentially zero effort, basically any tag language that has the "nested elements with attributes" structure.</p> <p>Classic ASP looks the way it does because the people who use(d) it and the people who made the tutorials just threw it out there and didn't fully understand the language and good practices. So we are stuck maintaining meandering code vomit. But if you do it right it can start to look like ruby. Heck I even implemented some ruby iteration stuff using dynamic vbscript classes a few years ago just to see if I could do it and it worked, but I lost that code a long time ago. Point being that even though vbscript is limited it still has more capability than people give it credit for, they just usually don't do things as well as could be done.</p>
    singulars
    1. This table or related slice is empty.
    1. POCalling JScript functions from VBScript - Parentheses
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDave
    1. USDave
    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. 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
    1. COYes, exactly...
      singulars
      1. PO
      1. USEkkehard.Horner
    2. COThis is fantastic, and exactly the sort of thing I was trying to implement myself, something to control and standardise markup generation. Which prompted the original question. Agree on all points too.
      singulars
      1. PO
      1. USBrett Postin
    3. COThanks! It can generate literally any tag because all tags are built behind the scenes like so w/ a tag "factory" method of sorts: set mydiv = tag("div").attr("id", "mydiv"). Then you could just use "with mydiv ..." as shown above. Or do xml, i.e. set rss = tag("rss") etc.
      singulars
      1. PO
      1. USDave
 

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