Missing record set

Results 1 to 2 of 2

Thread: Missing record set

  1. #1
    Join Date
    Dec 1969

    Default Missing record set

    I am running MySql on a Windows 2000 server box using and MyODBC drivers and IIS 5. For some reason whenever I run code such as below, It skips the first record in the data that should be returned from the query. Could you please help! Thank you,<BR><BR><BR>Mark Figueredo<BR><BR><BR>set objConnection = Server.CreateObject("ADODB.Connection")<BR>objConn ection.Open "DSN=" & strDSN & ";uid=" & strDBUserName & ";pw=" & strDBPassword & ";"<BR>Set objPORS = Server.CreateObject("ADODB.Recordset")<BR>objPORS. Open strQuery,objPOConn, 0, 1<BR><BR><BR>Do While NOT objPORS.EOF<BR> <BR>‘ Misc response.writes<BR><BR>objPORS.MoveNext<BR>Loop<BR >

  2. #2
    Join Date
    Dec 1969

    Default Multiple Crosspost<eop>


Posting Permissions

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