Previous | Next | (P-PDF) JavaScript

Topic: No Topic
Conf: (P-PDF) JavaScript, Msg: 28232
From: IMSAK
Date: 10/6/2001 03:51 PM

I am using the function below to query a database and return the value from the databae. I would like to insert the value of var "ckid" into the query statement so that this function can be called from links with different values. Thus when a link is clicked on, the var ckid value in the link is declared then the lookup() function is called and the form s populated with the data from the database. I have tried many combinations of " and ' in conjunction with the variable value and have yet to come up with a combination that would work to place the variable in the query string and have it work. I have tried declaring the variable outside the function and it still does not work.

function lookup()
{var ckid = 1019650;
statement.execute('Select * from Mapsoft1 where A2 = ckid');
statement.nextRow
row = statement.getRow();

var e;
try {
statement.nextRow();
}catch(e) {
getConnected();
}
row = statement.getRow();
populateForm(row);
popup2()
}