Selecting Specific Database Record - Stored Procedure problem

hi,

i trying specific records using stored procedure. basing code on sample provided stefan. stored procedure follows.

commmitmentletter 1,0
1 being first customer # , 0 being first loannum.

my code follows:
// customer name , determine associated custno
var sloanno = test.rawvalue - 1
var scustomername = xfa.event.newtext
var scustomerid = $.bounditem(scustomername)

// set query's commandtype "storedproc"
xfa.sourceset.commitmentconnection.#command.query.commandtype = "storedproc"

// set stored procedure in commitmentconnection show information belongs specific customer.

xfa.sourceset.commitmentconnection.#command.query.select = concat ("commitmentletter ",custno,",",sloanno)
// open data connection , move first record
xfa.sourceset.commitmentconnection.open()
xfa.sourceset.commitmentconnection.first()

custno should replace 1 , sloanno replace 0.

i keep receiving open operation failed / syntax error or access violation on sql server.

any ideas?

More discussions in LiveCycle pre-ES (6.x and 7.x) discussions

adobe