Search results


var OrderNoString = "" // build a string for part number href to summaryr project.lock() OrderNoCursor = database.cursor("select * from order_header, customer,order_line where order_header.order_no like '" + request.OrderNo + "%' and customer.customer_no = order_header.customer_no and order_line.order_no = order_header.order_no order by order_header.order_no") if (request.OrderNo.length > 0) write ("

Order Numbers that begin with " + request.OrderNo + ".

") else write ("

All available orders.

") write ("

") write ("" + "" + "" + "" + "" + "") while (OrderNoCursor.next()) { ") write ( "") } //end while write ("
Order NumberCustomer NameLine NumberItem Number
" + OrderNoCursor.customer_name + "") write ( "" + OrderNoCursor.line_no + "" + OrderNoCursor.item_no + "

") project.unlock()