- From: Dmitry Turin <html60@narod.ru>
- Date: Thu, 26 Apr 2007 12:09:03 +0300
- To: public-html@w3.org
Good day, Jonas. >> Can low-skill users write program (for example, by perl or php), >> which convert 3 rational table (from DBMS) into 1 browser table ? >> No. >> In better case, users can write 3 simple request to DBMS and >> merge result into output JS> Most DBMS'es can order data such that it can be outputted directly in a JS> row-by-row order. At least I have never interacted with a DBMS where I JS> couldn't take the output and directly dump it to HTML. There is always gasket (shim) between SQL (pure DBMS) and HTML (browser). Gasket is additional language, which is often un-available for low-skill users. It's very reasonable to turn job in intermediate language into job in SQL. Pay attention at low-skill users, you always think about theory. It's possible to do all - in theory, but not possible with real low-skill users. JS> "ORDER BY field_i, field_j" Lets use term "name" for name of columns/rows, and use term "data" for content of cells. In real multi-dimensional case (10D, 15D) "field_i, field_j" are not equal to serial number (of columns, of rows) for visualization on display - they exist only for bond with data (which will be in cell on display). Usually table with names has one more field (for example, "ser_i", "ser_j"), which contain serial number of columns/rows. It's necessary to write "order by ser_i, ser_j" for output names of columns/rows. Thus it's necessary to sort data by "ser_i, ser_j" of names. It's additional (i think - un-necessary) job for low-skill users. P.S. Really programmers are small percent of all users. Dmitry Turin http://html6.by.ru http://sql4.by.ru http://computer2.by.ru
Received on Thursday, 26 April 2007 09:09:27 UTC