title: DELPHI Fill a listbox with the results of ADO Query
body: <p>have been reading through all associated threads but no solution posted to help me with Delphi.</p>
  
  <p>Quite simply, i have a MySQL table called Story and i want to extract specific fields from this - and hence populate list box.</p>
  
  <p>From other posts, i've used the following...</p>
  
  <pre><code>adoqMenu.Close;
  adoqMenu.SQL.Text := 'SELECT StoryID, Story Description, Completion Date FROM Story';
  try
    adoqMenu.Open;
    ListBox1.Items.Clear;
    while not adoqMenu.Eof do
    begin
      ListBox1.Items.Add(adoqMenu.Fields[0].AsString);
      adoqMenu.Next;
    end;
  finally
    adoqMenu.Close;
  end;
  </code></pre>
  
  <p>This only gives me the first field...grr. Quite simply, how can i change this so that the fields stated in the SELECT clause appear in the listbox as is?</p>
  
  <p>Thanks</p>