<% '************************************************************************* ' ASP Scripting: ' Filename: fabricswatch.asp ' Written by: Angela Madarang ' Date: May 9, 2005 '************************************************************************* ' Description: View Products By Product Line Category '************************************************************************* %> <% strProductLineCategoryId = Request( "product_line_category_id" ) response.write "hello=" & strProductLineCategoryId 'Format Query String strSQL = "SELECT * FROM TCushion WHERE ProductLineCategoryId=" & strProductLineCategoryId strSQL = strSQL + " ORDER BY OrderNo ASC" 'Execute Query Call openDataConnection Set rs = dataConnection.Execute( strSQL ) Call closeDataConnection If NOT (rs.EOF AND rs.BOF) Then Response.Write "" DO WHILE NOT rs.EOF Response.Write "" For i = 1 to 6 If NOT (rs.EOF AND rs.BOF) Then Response.Write "" rs.MoveNext End If Next Response.Write "" LOOP Response.Write "

" Response.Write "" Response.Write "

" End If Set rs = Nothing %>