Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unhappy Unanswered: What is wrong? please help.

    I have this propblem when i use the following code it works fine

    sSQL = "SELECT * from member order by lastname;"
    rsMember.Open sSQL, cnDBConn, adOpenDynamic

    but if i want to display a few fields thus i changed the above code with

    sSQL = "SELECT lastname. firstname from member order by lastname;"
    rsMember.Open sSQL, cnDBConn, adOpenDynamic

    I got this error.

    Err_Number: 3265
    Err_Description: Item cannot be found in the collection corresponding
    to the requested named or ordinal
    Err_Source: ADODB.Fields

    Plese Help!
    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    change the period after lastname to a comma
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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