|
Server-Side JavaScript serie, Planche nr. 9 |
![]() |
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>