Display records from database with script

Ronnie Dackus · **Posted:** November 18th, 2005, 1:22 pm

Hi,

I want to display records from a database with script ( see code below ).
I want to set a pub variable " klantnaam " to the database field " Naam", something is wrong but I doen't know what??!!!!

Code:

var db = new Database("FILEDSN=klantgegevens.dsn");
var records = null;

function Searchklant()
{
   var sql = "SELECT * FROM klantTbl WHERE Naam LIKE '%"+zoekklantnaam+"%' ORDER BY Naam;";
   // Debug.trace(sql+"\n");
   records = db.ExecuteSQL(sql);
   
   ShowRecords()
}
function ShowRecords()
{
    klantnaam = Naam
   }

Hope somebody can help.

Ronnie

tuinkran · **Posted:** January 7th, 2006, 7:46 pm

try ==

Digital Workshop

Display records from database with script

Who is online