New Forum | Previous | Next | (P-PDF) Beginners
Topic: SQL statement using variable not in db
Conf: (P-PDF) Beginners, Msg: 75615
Date: 11/2/2002 10:15 AM
I need help with the following.
How do i write a query statement that needs to compare the value i just got from the web browser???
the path is sth like anxiet1.pdf?alanb
I would like to use alanb in my query.
I've included my code below:
var s = this.path;
var s1 = getQueryString(s); // gets alanb from the path
var myConnection = ADBC.newConnection("Educate");
var myTables = myConnection.getTableList();
myStatement = myConnection.newStatement();
myStatement.execute("SELECT * from Doctors where Userid = 's1' "); // pulls the record for alanb into the pdf
What is the syntax to do this? Or is it not possible to do it using statement.excute?
Any help will be appreciated!!