Populating a listbox

David · **Posted:** September 23rd, 2006, 9:16 am

I have a MySQL DB from which I want to extract information and display in a listbox (first name and last name). I assume that I am going to have to use a combination of SetSelection and ReplaceSelection as per textbox, but, I cannot see how to apply these to a listbox

How do I populate the listbox using a script and variables extracted from the DB?

Another quick one - how do you add a line feed or carriage return (ASCII chr(13)) to a line of text to force a new line?

Cheers

Ronnie Dackus · **Posted:** September 24th, 2006, 8:08 am

Hi,

Try this one, replace the name "Listbox 1" with your listbox.

Code:

var db = new Database("FILEDSN=artikelenontwerp.dsn");
var records = null;
var num_records = 0;

//////////////////////////////////////////////////////////////////////////////
//
// NOTE: Start_Record_Num is the record number for the first of the 5 records
//       and it is a Page Variable
//

function SearchDB()
{
   var sql = "SELECT * FROM Customers WHERE LastNAme = '" + zoek + "' ORDER BY LastNAme;";
   // Debug.trace(sql+"\n");
   records = db.ExecuteSQL(sql);
   num_records = records.GetNumberOfRecords();
   numberrecords = num_records;
   ShowRecords();
}

function ShowRecords()
{
   if (records == null) {
      return;  // need to call Search First to get records
   }
   var list_box = Listbox_1;
   list_box.SetSelection(0, -1);   // Select all the old text
   list_box.ReplaceSelection("");   // Remove all the old text
   
   if (records.FirstRecord()) {
      list_box.ReplaceSelection(records.FirstNamet+"\t "+records.LastName);
      records.NextRecord();
      for (i=1; i<num_records; i++) {
         list_box.ReplaceSelection("\n"+records.LastName+"\t "+records.FirstName);
         records.NextRecord();
      }
   }
}

Regards,

Ronnie Dackus

David · **Posted:** September 24th, 2006, 9:18 pm

Cheers Ronnie - just what I was looking for

Digital Workshop

Populating a listbox

Who is online