Previous | Next | (P-PDF) JavaScript

Topic: Re: No Topic (Via Email)
Conf: (P-PDF) JavaScript, Msg: 28234
From: dpstory
Date: 10/6/2001 09:11 PM

On 6 Oct 2001, at 15:52, p-pdf-javascript Listmanager wrote:

> From: "Bob"
>
> 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.

try

statement.execute('Select * from Mapsoft1 where A2 = ' + ckid);

it worked for me.

> 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()
> }
>

dps


Dr. D. P. Story / dpstory@uakron.edu / (330) 972-7514
http://www.math.uakron.edu/~dpstory/ Dept of Mathematics
and Computer Science / University of Akron / Akron, Ohio 44325
AcroTeX Web Site: http://www.math.uakron.edu/~dpstory/acrotex.html
Site Includes: e-Calculus, Algebra Review in Ten Lessons,
Mathematics Games, Pdfmarks:Links & Forms,
Using LaTeX to Create Quality PDF Documents for the WWW,
Web.sty and Exerquiz.sty Packages for LaTeX,
and much, much more.