creating an asp page that deals with an SQL database. when i try to display all records in table x, not all show up. so "select * from x" does not work within the asp but it does work if i use SQL.

also, if i deal with the database directly, i have to "commit;" after each statement or table x reverts back to its original state after i log off.

More information would be needed to help with your first point - like what does your ASP code look like?

Re the 2nd point, yes you must issue COMMIT at the end of a transaction, which may actually consist of many statements. Some client software issues commits for you automatically, but it is actually better if you control this explicitly in your code.

how do i "commit" within an asp page?

Google is your friend; use it!