These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Sequel query access

2008-03-04 03:59:46

lucianopilla

Registered: Oct 18 2007

Posts: 76

Answered

hello to all,
i want to pass dialog's value as as query's parameters, i think there's some problems with the string:
'Select (code) AS newvalue from "paper" where number = 777 and year = 2002'
if i write parameters directly in code it's works fine, but when i replaces the value with the input value from the dialog it doesn't work, can i have some suggest?
thanks to all.

Adding intelligence to documents

2008-03-04 09:22:25

thomp

Registered: Feb 15 2006

Posts: 4411

What are you talking about? What Product? What dialog?

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

2008-03-05 00:12:21

lucianopilla

Registered: Oct 18 2007

Posts: 76

thanks for interesting.
i'm talking about javascript core for adobe acrobat professional 8.
For dialog i refer to method execDialog. My purpose is to pass the input value in the select query ('Select (code) from "Customer" where number = InputValue1 and year = InputValue2')), the function work with integer but doesn't work with streaks. what's the problem?
thanks in advance!

Adding intelligence to documents

2008-03-06 00:37:56

lucianopilla

Registered: Oct 18 2007

Posts: 76

i solved the problem.
this is the correct way to put variables in a select sql statement:
var SQLString = 'Select (ValueToEelect) from "Table" where Field1 =' +variable1 +'and Field2 =' +variable2;
hope that helps anybody.

Adding intelligence to documents