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...
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...
b) to query a field in a table and match a word that is embedded within the field....
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.
A numeric variable is surrounded by % signs (i.e. %AnumericDBfieldName% )
A text variable is surrounded by single quotes AND % signs ( as in '%FormVariable%' )
|You are at the www.techadvice.com site which is not associated with the company or products shown on this page.|