The Book Order Query

If a user is interested in ordering a book, he or she can click on the Order Info button. IDC is used again to query the database and return the title, description, and any comments on the selected book. The results are then displayed in an HTML extension file.

Add this functionality by starting a new document in a text editor. The file will be saved as order.idc in the \scripts\project3 folder. Add the following code to set up the book order query:

Datasource:Bookstore
Template:c:\inetsrv\scripts\project3\order.htx
SQLStatement:
+SELECT Title,Description,Comments,Special,Subject
+FROM Titles
+WHERE Title LIKE '%txtTitle%' 

© 1996 by Scot Hillier. All rights reserved.