Access To SQL

I'm converting an Access 2000 database to SQL 2000. In this conversion I will
be creating a Web front end and need to know how to conditionally format HTML
tables based on the results of a query/view in SQL. Example: If dept. A sales
are <= x then format table cell red. If dept A sales >= y then format table
cell green.

Should (can) I attempt to do the formatting in SQL prior to submitting to the
Web HTML table or should I evaluate the HTML table after the results have
been written and format then?

The end result on this is to build a Web based color dashboad based on query
results.

Any help is really appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200603/1
.

Relevant Pages

  • Re: wraping while converting html to PDF
    ... Pre formatted way, but when html is converted to PDF, PRE is working ... with restrictions of PDF file format itself: ... I know all the challenges of HTML-to-PDF converting process and would ...
    (comp.text.pdf)
  • ODBC/VBA?EXCEL and ORACLE database
    ... We recently converted one of our datawarehouses to ORACLE. ... I am now having difficulty converting several Excel Macros that use VBA ... With a SQL Syntax error. ... function is required to override ORACLE default format of:date Timestamp" ...
    (microsoft.public.excel.programming)
  • Re: [9fans] 3 questions
    ... I am converting my own style which I call tt format to html format. ... some program code ...
    (comp.os.plan9)
  • Re: can I add a percent symbol without multiplying by 100?
    ... I have tables I'm converting to HTML and I need percent symbols on each cell. ... The percentage format does just that. ...
    (microsoft.public.mac.office.excel)
  • Re: how to generate html table from "table" data?
    ... Why not try writing your own code for this first? ... Of course some attempts to generate html from tabular data are behind ... table and save the output of the SQL SELECT to the file in the html ... format. ...
    (comp.lang.python)
Quantcast