Extremely Low prices on Ink and Toner Cartridges

IDC | Applications | FrontPage 97 | »

Beginners should read and print out the Example on this page.

This page has simple instructions on referencing IDC files.

Typically the IDC file is used to access databases from a web page.

An IDC file is constructed which uses SQL statements to query the data and return values.

There are 3 parts to accessing the data and presenting the information.

A web page has a hyperlink that calls the IDC

The hyperlink can be simply a reference to the IDC files such as...

MyIDCfile.IDC

The IDC has a SQL and a returning web page reference

the 2 most used SQL statements are the equal and the like statements

a) to query a field in a table and match a value, you can use...

SELECT MyField
FROM MyTable
WHERE MyField='%MyVariable%'

b) to query a field in a table and match a word that is embedded within the field....

SELECT MyField
FROM MyTable
WHERE MyField Like '%%%MyVariable%%%'
.......notice the single quotes and the 3 percent signs

 

An HTX file is used to present the data.

The HTX file is simple an HTM file which has the extension renamed from HTM to HTX

the field used to display the value returned by the IDC.

Basic Rules

• Within the IDC, a web page form text box variable used in the "which" section ( i.e. the text box name where you type in the search word) is entered as follows:

A numeric variable is surrounded by % signs (i.e. %AnumericDBfieldName% )

A text variable is surrounded by single quotes AND % signs ( as in '%FormVariable%' )

• Note: The type of variable is determined by your selection within the database table when the field is created or edited.
  
• A database variable is entered by referencing the database name followed by a period then the table name, (i.e. DBname.TableName )

---