Sybernet / Supplied Procedures Reference
Release 3.00
Mar 03, 2005
backwards forwards

HTTP.SP_HTML_PREFERENCES

This procedure is used to build your HTML body tag. The original theory was it allowed you to specify the typical attributes (like bgColor), but allowed your user to override these values. The problem here is users usually don't specify the preferences, or when they do they set the font color equal to the background color.

sp_html_preferences will use style sheets for newer browsers. It will also do other clever things like set the print size on the printer to 3/4 the print size on the screen (unless you say otherwise).

Syntax

procedure sp_html_preferences
(
    @APPEARANCE                    VARCHAR(30)
,   @onLoad                        VARCHAR(255)
,   @bgColor                       VARCHAR(30)
,   @text                          VARCHAR(30)
,   @backGround                    VARCHAR(64)
,   @fontSize                      VARCHAR(3)
,   @pointSize                     VARCHAR(3)
,   @pointsize_print               VARCHAR(3)
,   @line_height_print             VARCHAR(4)
,   @font                          VARCHAR(30)
,   @link                          VARCHAR(30)
,   @aLink                         VARCHAR(30)
,   @vLink                         VARCHAR(30)
,   @face                          VARCHAR(30)
,   @color                         VARCHAR(30)
,   @topmargin                     VARCHAR(6)
,   @leftmargin                    VARCHAR(6)
,   @marginheight                  VARCHAR(6)
,   @marginwidth                   VARCHAR(6)
,   @onresize                      VARCHAR(255)
,   @a_link                        VARCHAR(255)
,   @a_visited                     VARC@AR(255)
,   @a_hover                       VARCHAR(255)
,   @a_active                      VARCHAR(255)
)   ;

Parameters

Parameter Description
appearance
 
Allows you to specify the default appearance.
onLoad
 
javascript:onload
bgColor
 
Background color.
text
 
Foreground color.
backGround
 
Background image.
fontSize
 
Font size (deprecated in favor of pointSize)
pointSize
 
Pointsize of screen.
pointsize_print
 
Pointsize of print.
line_height_print
 
Line height of print.
font
 
Font family
link
 
Color of links.
aLink
 
Color of active links.
vLink
 
Color of visited links.
face
 
Deprecated.
color
 
Deprecated.
topmargin
 
Topmargin of screen.
leftmargin
 
Leftmargin of screen.
marginheight
 
Marginheight of screen.
marginwidth
 
Marginwidth of screen.
onresize
 
javascript:onresize
a_link
 
Stylesheet "a:link"
a_visited
 
Stylesheet "a:visited"
a_hover
 
Stylesheet "a:hover"
a_active
 
Stylesheet "a:active"

Example

The following example illustrates how to call sp_html_preferences:

exec http.dbo.sp_html_preferences

See Also

SP_HTML_HREF
SP_HTML_INPUT
SP_HTML_FORM
SP_HTML_FRAME
SP_HTML_MENUBAR


Sybernet is a trademark of SRI International.
Copyright © 1996-2008 SRI International. All Rights Reserved.
Denis D. Workman / http://Sybernet.sri.com/