Results 1 to 3 of 3

Thread: ODBC question

  1. #1

    Thread Starter
    Member
    Join Date
    May 2001
    Posts
    39

    ODBC question

    Hi

    Anyone knows the function to start a transaction in the context of php ODBC functions ?

  2. #2
    <?="Moderator"?> john tindell's Avatar
    Join Date
    Jan 2002
    Location
    Brighton, UK
    Posts
    1,099
    Do u mean something like this?

    PHP Code:
    <?

    $strDSN = "DSN=dsnsourcename;";
    $strSQL = "SELECT * FROM yourtable";


    $rs = new com("ADODB.RecordSet");

    $rs->open($strSQL,$strDSN,2,1);
    while(!$rs->EOF){
    print $rs->fields["Value"]->value."<br>";
    $rs->movenext;
    }
    $rs->close
    ?>

  3. #3

    Thread Starter
    Member
    Join Date
    May 2001
    Posts
    39
    The subject is 'Unified ODBC functions', exists a function 'commit' and other named 'rollback', but nothing like 'begin' or 'begintrans' !?!?

Posting Permissions

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



Click Here to Expand Forum to Full Width