Forrige
Oversigt
Server-Side JavaScript serie, Planche nr. 9
Kursus Indhold

Produkt-side

HTML, med indlejret JavaScript

<HTML><HEAD>
<SERVER>
////////////////////////////////////////////////////////////////////////
///
//  lw_product.html - LiveWire and Server-Side JavaScript
//Implementation
//
//  This page displays a list of products from the PRODUCT table
//  for a given category_id. 
////////////////////////////////////////////////////////////////////////
///
</SERVER>
<TITLE>Categories</TITLE>
</HEAD><BODY>
<P>
<UL>
<SERVER>

if (project.productDB.pool.connected()) {
   var iCategoryID = request.category_id;
   var conn =
project.productDB.pool.connection("conn", 60);

   conn.beginTransaction();
   qs = "SELECT product_name from PRODUCT WHERE
category_id =" + iCategoryID; 
   results = conn.cursor(qs);
   while (results.next()) {
        
write("<LI>"+results.product_name+"</A>\n");
   }
   results.close();
   conn.commitTransaction();
   conn.release();   
}
else {
        write("<p>Database
connection failed");
}</SERVER></UL>
</BODY></HTML>


© 1999 BLA*net - Leif E. Andersen, leander@blanet.dk