Re: SQL for presentation

frebe73@xxxxxxxxx wrote:


It is also
claimed that the "business logic" should be implemented in the database
as views and the application on top of the database only should be
responsible for presentation (and communication).

I cannot speak for every participant in the forum, but speaking only for
myself I would restate this as: All business rules *can* be implemented in
the server using triggers. All business rules *should* be implemented in
the server for the advantage of centralization. It should also be noted
that security should be considered a class of biz rules which also gain by
this centralization.

AFAIK I am alone in advocating use of server-controlled derived values
placed directly into tables and not views. There are many reasons for this
which I won't go into just yet.


In web applications, the presentation - HTML - is a data structure. If
select statements could make almost any kind of data transformation,
why couldn't we use select statements to produce the HTML text?

Two answers. First is public sites. HTML for public sites is usually a
marketing or sales tool besides being a presentation tool. It is often
hand-crafted on a page-by-page basis in consideration of its vital sales
role. Jumping from a SELECT to HTML is difficult to picture here.

Second would be internal-use admin screens, commonly called CRUD screens.
We have a zero-code solution there, but it is based on a small amount of
library code that reads a data dictionary and generates things like inputs,
selects, and textareas. Jumping from a SELECT to HTML is also hard to
picture here.





--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)
.

Relevant Pages

  • Re: Accessing an Unnamed HTML element
    ... it's a processing directive to some server side application. ... What actually appears in the document that the web browser receives is ... The database query could be generating any amount of non block level html ...
    (comp.lang.javascript)
  • Re: Virtual SBS server
    ... I have been posting in HTML since I became an MVP for SBS 5 years ago. ... With regard to Outlook over HTTP, it might be a bit faster since you don't have the VPN overhead to contend with. ... >>Depending on the database VPN may work, ... >desktop so making the server do all the work would be ...
    (microsoft.public.backoffice.smallbiz)
  • Intelligent/hard-working 20 year ERP, MS SQL, Developer/Crystal, HP3000-conversion/migration
    ... server, ... export to Excel formats directly from the database. ... legacy business needs and new features. ...
    (comp.sys.hp.mpe)
  • Database Question
    ... I've tried to have it saved in a Access file but my server does'nt allow ... allows in text and html comes across as one big rambling mess into my ... database and makes it hard as hell to figure out who's info is who's. ... Names and grad year to show on a separate page??? ...
    (microsoft.public.frontpage.programming)
  • Re: Need some Frontpage and Login Page Help
    ... What you want to do w/ a database requires knowledge of ASP and DB connections on a Windows server supporting Access ... Your host will have to support subwebs and unique permissions under the FP Server Extensions ... Creating the HTML pages ...
    (microsoft.public.frontpage.programming)