Self Sorting Table Using Text File - Parameters

The following is the complete list of parameters and features available in the fully licensed version.

Parameter Index

• nFonts
• FONTx
• nColors
• ColorX
• Title
• TitleFont
• BGcolor
• LNcolor
• TXTcolor
• TXTfont
• Brdrwidth
• Brdrcolor
• nColumns
• maxRows
• CellBGcolor
• CellTXTcolor
• Cellfont
• Colfont
• Decplaces
• COLx
• Delimiter
• FileLocation

See also File Information.

Parameters

nFonts

The Number of Fonts.

Typical Value: "2"

Range Of Values: "0 " - "99"

Default Value: "1"

FONTx

Font definition where x is the font number e.g. FONT1, FONT2 etc...

Typical Values:

"TimesRoman|B|14"
"TimesRoman|I|12"
"Helvetica|BI|14"

Range Of Values: Type|N,B,I|size

N - Normal
B - Bold
I - Italic

Default Value: "Courier|N|12"

nColors

The Number of Colors.

Typical Value: "4"

Range Of Values: "0 " - "99"

Default Value: "2"

ColorX

Color definition where X is the color number e.g. Color1, Color2 etc...

Typical Values:

"255|255|255"
"0|0|0"
"255|0|0"
"255|128|0"

Range Of Values:

Red|Green|Blue
0-255|0-255|0-255

Default Value:

"255|255|255" (Color1)
"0|0|0" (Color2)

Title

The Main Title.

Typical Value: "This is the main title"

Range Of Values: "Any Text"

Default Value: " "

TitleFont

The number of the font for the Title.

Typical Value: "1"

Range Of Values: "1" - nFonts

Default Value: "1"

BGcolor

Background color number.

Typical Value: "1"

Range Of Values: "1" - nColors

Default Value: "1"

LNcolor

Line color number.

Typical Value: "1"

Range Of Values: "1" - nColors

Default Value: nColors

TXTcolor

Text color number.

Typical Value: "1"

Range Of Values: "1" - nColors

Default Value: nColors

TXTfont

Text font number.

Typical Value: "1"

Range Of Values: "1" - nFonts

Default Value: nFonts

Brdrwidth

Width of border.

Typical Value: "1"

Range Of Values: "1" - "99"

Default Value: "1"

Brdrcolor

Border color number.

Typical Value: "1"

Range Of Values: "1" - nColors

Default Value: nColors

nColumns

The number of columns.

Typical Value: "6"

Range Of Values: "1" - "99"

Default Value: "1"

maxRows

The number of rows to be read from the file.

Typical Value: "200"

Range Of Values: "1" - "99999"

Default Value: "1"

CellBGcolor

Background color of cells.

Typical Value: "2"

Range Of Values: "1" - nColors

Default Value: "1"

CellTXTcolor

Cell text color.

Typical Value: "3"

Range Of Values: "1" - nColors

Default Value: "1"

Cellfont

Cell text font.

Typical Value: "1"

Range Of Values: "1" - nFonts

Default Value: "1"

Colfont

Column header font.

Typical Value: "1"

Range Of Values: "1" - nFonts

Default Value: "1"

Decplaces

Number of decimal places to display totals to.

Typical Value: "2"

Range Of Values: "0" - "10"

Default Value: "0"

COLx

Column header data where x is the number of the column e.g. COL1, COL2 etc...

Typical Value: "User Name|2|150|5|2"

Range Of Values: "Title | Type | Width in pixels | Background color | Text Color"

Type = "0" for numeric value with total, "1" for numeric value without total and "2" for text.

Default Value: " "

Delimiter

The is the character that is used in the text file to seperate the data e.g. "Cell1 Data|Cell2 Data".

Typical Value: "|"

Range Of Values: Any character

Default Value: " "

FileLocation

A relative URL of the file that you want to use e.g. "FlatFile.txt" or "subdir1/.../FlatFile.txt". You can not have an absolute URL e.g. "http://www.yourdomainname.com/file.txt". There for the file can only be located in the same directory or a sub directory from the applet file.

Typical Value: "file.txt"

Range Of Values: Any file name.

Default Value: " "

File Information

Each line in the file is a row of data. You use the Delimiter character to seperate the data into the different cells. See flatfile1.txt for an example.

With a '|' delimiter character the data file will look like this:
14 Wood Drive|£ 175,000|Detached|Town|2|4|Yes|Yes|Yes|No 11B Chorley Road|£ 35,000|Flat|Town|1|1|No|No|Yes|No 21A Chorley Road|£ 32,500|Flat|Town|1|1|No|No|Yes|No 114C Smyth Street|£ 17,000|Flat|City|1|1|No|No|No|No 96A Surrey Road|£ 42,000|Flat|Town|1|2|No|Yes|Yes|No 42 London Road|£ 85,000|Terraced|Town|2|2|No|Yes|Yes|No 43 London Road|£ 85,500|Terraced|Town|2|2|No|Yes|Yes|No 132 London Road|£ 86,000|Terraced|Town|2|2|No|Yes|Yes|No 209 London Road|£ 85,750|Terraced|Town|2|2|No|Yes|Yes|No 11 London Road|£ 84,500|Terraced|Town|2|2|No|Yes|Yes|No 27 London Road|£ 87,750|Terraced|Town|2|2|No|Yes|Yes|Yes 83 London Road|£ 75,000|Terraced|Town|2|2|No|Yes|No|No 342 London Road|£ 115,000|Semi Detached|City|2|3|Yes|Yes|Yes|No 12 Mole Close|£ 155,000|Bungalow|Town|2|3|Yes|Yes|Yes|No 21 High Street|£ 95,000|Terraced|Village|2|2|No|Yes|Yes|Yes Southacres Farm|£ 175,000|Detached|Rural|2|4|Yes|Yes|Yes|No 92 Southland Road|£ 155,000|Detached|Town|2|4|Yes|Yes|Yes|No 61 Norton Drive|£ 170,000|Detached|Village|2|4|Yes|Yes|Yes|No 11 Westland Close|£ 235,000|Detached|Town|3|4|Yes|Yes|Yes|No 4 Temple Drive|£ 375,000|Detached|Village|3|5|Yes|Yes|Yes|Yes 142 High Street|£ 125,000|Semi Detached|Town|2|3|Yes|Yes|Yes|No 91 Low Road|£ 105,000|Semi Detached|City|2|3|No|Yes|No|No 67 New Street|£ 145,000|Semi Detached|City|2|4|Yes|Yes|Yes|No 92 Southland Road|£ 155,000|Detached|Town|2|4|Yes|Yes|Yes|No 61 Norton Drive|£ 170,000|Detached|Village|2|4|Yes|Yes|Yes|No 11 Westland Close|£ 235,000|Detached|Town|3|4|Yes|Yes|Yes|No 4 Temple Drive|£ 375,000|Detached|Village|3|5|Yes|Yes|Yes|Yes 142 High Street|£ 125,000|Semi Detached|Town|2|3|Yes|Yes|Yes|No 91 Low Road|£ 105,000|Semi Detached|City|2|3|No|Yes|No|No 67 New Street|£ 145,000|Semi Detached|City|2|4|Yes|Yes|Yes|No

© 2000 JPowered.com.