Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    21

    Unanswered: database inconsistencies

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    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.

  3. #3
    Join Date
    Sep 2004
    Posts
    21
    how do i "commit" within an asp page?

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Google is your friend; use it!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •