[RESOLVED] Retrieve multiple records from ... where ...

[Radjesh Klauke]

Ola,

I know this is basic, but my mind is totally blanc. I'm trying to retrieve all records from a table with a specific code.

Dim cmd As New MySqlCommand("SELECT myValueRow FROM myTable WHERE  searchRow = 'test'", myconnection)
myreader = cm.executereader

while reader.read
   debug.print(.....)  '   eeeh.... can't use executescaler, want all of them. "reader.item("myvaluerow") also returns one value
end while

Thanks in advance.