SQL in JScript

[Tango524]

Hi guys!

I am having trouble with the lines below- particularly the getString and SQL statement. It gives me error 68- whatever that means. Any clues as to what is wrong? Thanks!

function onLoad()
{
con = DBDriver.getConnection("alias:hrbid"
stmt = con.createStatement("SELECT DISTINCT hrbid_employee.employee_number from hrbid_employee WHERE hrbid_employee.employee_number = 11111"
rs = stmt.executeQuery();
info = rs.getString(hrbid_employee.employee_number)
md = rs.getMetaData();
alert("number : " +info);
}

 

[jemminger]

my guess is you're using server-side JScript, in which case this is an illegal statement:

alert("number : " +info);


alert() is for client-side only


=========================================================
while (!succeed) try();
-jeff

http://www.jeffemminger.com