var OrderNoString = "" // build a string for part number href to summaryr
project.lock()
OrderNoCursor = database.cursor("select * from order_header, customer where order_no like '" + request.OrderNo + "%' and customer.customer_no = order_header.customer_no order by order_no")
if (request.OrderNo.length > 0)
write ("Order Numbers that begin with " + request.OrderNumber + ".
")
else
write ("All available orders.
")
write ("")
write ("" +
"Order Number | " +
"Customer Name | " +
"
")
while (OrderNoCursor.next()) {
write(OrderNoCursor.order_no);
|
write ( "" + OrderNoCursor.customer_name + " | " +
"")
} //end while
write ("
")
project.unlock()