hi i'm new to sql and asp and just most database stuff... right now... i have an asp page which loads a default html page...
in the html page, there's a section where it reads from an sql database and reads the row/columns and returns it all in a table thats displayed in html on the page... in the table in sql.. theres about 600 rows.. but i have it split up sort of.. like for rows 1-100 i made a column called row_id and i have that as 1 for rows 1-199... then for rows 200-299 the row_id for all those rows is 2, and so on... is there a way in my html code to retrieve only certain rows given the row_id, say i only want to display rows 200-299 and i have the row_id 2, is there a way to display just those rows instead of the whole table of 600 rows?
here is the code that reads sql table and shows it in html on a webpage, this code returns the whole table:
chargenumbers is the name of the table,
charge_id,project,task_number,description,project_ id are the name of the columns... right now i added an extra column called row_id and i want to be able to display only the rows that have a certain row_id..