This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C1F738.1285C370
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Peili Zhang,

Thank you for the kind words, I'm glad I was able to help.

The force is strong with you.

Venlig hilsen/Kind Regards,


Steffen Wogensen Jaques

  ----- Original Message -----
  From: Peili Zhang
  To: Going_Live
  Sent: Thursday, May 09, 2002 8:29 AM
  Subject: [going_live] THANK YOU SO MUCH! THANK YOU SO MUCH!


  Dear Dr. Jaques:

  Thank you so much! You are absolutely right. I often use 
adOpenDynamic.

  I did not realize that I could get your wonderful help. I just deadly 
found some code in the internet to copy in my code:

  'call function pub to exec the sp to see how many vendors for this 
code
     call pubTwo ("spCodeVendor", session("SICID"))  
    
     set rstCV =3D server.CreateObject ("ADODB.Recordset")
   
     with rstcv
    .CursorType =3D adForwardOnly
    .LockType =3D adLockReadOnly
    .CursorLocation =3D adUseClient
     end with
  
     'this way to get the RecordCount (I did not know why until got your 
help)
     rstcv.Open cmdCVTwo
    
     counter=3Drstcv.RecordCount

  Now I know why.

  Thank you so much!!!!!!!!!!!

  Best Regards!!!!!!!!!!!!!

  Your student,

  Peili Zhang

    webmaster@w... wrote:

    Hey Peili,

    If I am not mistaken, you are using the constant: adOpenDynamic to 
open the
    Recordset, right -- Using that means that after you have called the 
db and
    created a recordset, any changes made during this time by other 
people will be
    seen in your recordset ?

    Solution:

    Instead of using adOpenDynamic try using adOpenStatic you are making 
the
    recordset (yes you guessed it!) static, which means you can now use 
the
    RecordCount method.

    Hope it helps :)

    Kind Regards,

    Steffen Wogensen Jaques





-------------------------------------------------------------------------
-----
  Do You Yahoo!?
  Yahoo! Shopping - Mother's Day is May 12th! --- Change your mail 
options at http://p2p.wrox.com/manager.asp or to unsubscribe send a 
blank email to