Figure 1. An input form used to add a database connection 9
Figure 2. Form used to create a database method to retrieve part data. 10
Figure 3. A test input form for the database method in figure 2 11
Figure 4. Output from the test form shown in figure 3 11
Figure 5. Search interface creation wizard 12
Figure 6. Contents view of the Computer folder after adding a tabular search interface. 13
Figure 7. An automatically generated input form for a tabular product search 13
Figure 8. Source of the generated input form for the tabular product search 14
Figure 9. A standard_html_header document that includes a logo 14
Figure 10. The input form for a tabular product search, after adding a standard_html_header and a logo to the Computer folder. 14
Figure 11. Output of a search using the tabular_product_report created by the search interface wizard. 14
Figure 12. Part one of the source of the tabular_product_report document that was generated by the search-interface creation wizard. 15
Figure 13. Part two of the tabular_product_report Document,
showing the DTML text to insert data items. 16
Figure 14. Part three of the tabular_product_report document, showing source to display following batches and text to be inserted when there are no results. 16
Figure 15. A database-connection status view 20
Figure 16. Database-connection properties view 20
Figure 17. Database method input argument format. Argument name and type are separated by a colon. A equal sign separates the default value from the name and type. The default value is a string representation of the desired value. If the default value contains spaces, or is an empty string, then it must be surrounded by double quotes. 21
Figure 18. Test output showing an error message and SQL used. 23
Figure 19. SQL Database Method Advanced view 25
Previous Chapter | Up | Next Section | Contents