VB + MYSQL list more than 1 result

• • Reply

  13 years ago

  by SoiL

  mike bowman

  , United Kingdom

  Joined 13 years ago
      im having problems with getting this code to display more than 1 result, im used to using PHP and just started VB last night.
  
  to me when getting results from mysql it would display all the results unless u put in "limit" but i guess VB is different than PHP when it comes to this.
  
  could someone take a look please and tell me how i can get this code to display 10 results insted of just the 1?
  
  thanks
  
  
  [code start]
  
  Option Explicit
  
  Private Sub Form_Load()
  Dim cnMySql As New rdoConnection
  Dim rdoQry As New rdoQuery
  Dim mikecoQry As New rdoQuery
  Dim rdoRS As rdoResultset
  Dim WallpaperID As Integer
  Dim i As Integer
  
  
  ' set up remote data connection using the
  ' MySQL ODBC driver
  
  cnMySql.CursorDriver = rdUseOdbc
  cnMySql.Connect = [-password and connection info removed for posting-]
  cnMySql.EstablishConnection
  ' Select Wallpapers
      With rdoQry
  
       .Name = "select wallpaper"
   
       .SQL = "select * from wallpapers order by id DESC"
       .RowsetSize = 10
  
       Set .ActiveConnection = cnMySql
       Set rdoRS = .OpenResultset(rdOpenKeyset, rdConcurRowVer)
  
       mrbox.Text = rdoRS!Name & rdoRS!Image
  
  End With
  [code end]
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse
• • Reply

  13 years ago

  by ErwinB

  Erwin Bergsma

  Leuven, Belgium

  Joined 15 years ago

  I can think of two things to check:

  Can the object you're using to display the results handle more than 1 line ?

  Can you assign all records of the recordset at once to the object, or do you have to cycle through the recordset, and add the values one by one ?

  Good luck,

  Erwin

  Report abuse