<%@ LANGUAGE = JScript %>

<! --METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5 Library"
 
UUID= "{00000205 - 0000 - 0010 - 8000 -00AA006D2EA4}" VERSION= "2 . 5 " -->
 

<%

   DB = Session( "cnn" ); 
   newUser = Server.CreateObject( "ADODB.RecordSet" );
                         newUser.ActiveConnection = DB;
             newUser.CursorType = adOpenStatic;
//               newUser.LockType = adLockBatchOptimistic;
                 newUser.LockType = adLockOptimistic;
             newUser.Source =  "select TOP 1  * from authors";
             newUser.Open;
             newUser.AddNew;

    newUser.Fields( "au_id" ).value ='648-92-1945';
    newUser.Fields( "au_lname" ).value = 'Petrov';
        newUser.Fields( "au_fname" ).value = 'Ivan';

             newUser.Update;

             newUser.Close;
             newUser.Open;
             newUser.AddNew;

    newUser.Fields( "au_id" ).value ='648-92-2945';
    newUser.Fields( "au_lname" ).value = 'Petrov1';
        newUser.Fields( "au_fname" ).value = 'Iva1n';

             newUser.Update;
             newUser.Close;

//             newUser.Source =  "select * from authors" ;
//             newUser.Open;             
//             Response.Cookies( "nid" ) = newUser.Fields( "au_id" );
//             newUser.Close; 
                        
                         newUser.Source =  "select TOP 1  * from jobs";
             newUser.Open;
                         newUser.AddNew;
                         newUser.Fields( "job_desc" )='Test record';
                         newUser.Fields( "min_lvl" )= 20 ;
                         newUser.Fields( "max_lvl" )= 100 ;
             newUser.Update;
             newUser.Close; 
             


%>