Techadvice.com

Main,
Tech Info,
Glossary,
Companies,
Hardware
.
Software.
Windows 95, 98, ME, XP,
NT4, 2000, Errors,
Applications
,
Search products ,
Search FAQs.
Shop
Companies,
Products
,


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

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.
Contact Us,
Disclaimer
Advertisers
, ExoticRecipes
 

---