Populating field values from a SQL database

hi,
i using adobe designer 7.0. have dynamic form fields connected sql tables (dropdown lists). trying populate fields based on selection in dropdown list , data fields have come database.

i looked @ scripting feature , @ sample code didn't help. have written script i'm positive doesn't need. nevertheless, present here.

$sourceset.monitoring.#command.query.commandtype = "text"
$sourceset.monitoring.#command.query.select.value = concat("select station_design tblstations station = ",ltrim(rtrim(stationid.rawvalue)) ,"")
$sourceset.monitoring.open()

monitoring name of database , stationid dropdown value selected.

any appreciated.

thanks
kavitha

you can try changing:

$sourceset.monitoring.#command.query.select.value = concat("select station_design tblstations station = ",ltrim(rtrim(stationid.rawvalue)) ,"")

to

$sourceset.monitoring.#command.query.select.nodes.item(0).value = concat("select station_design tblstations station = ",ltrim(rtrim(stationid.rawvalue)) ,"")

otherwise you'll need more specific what's not working.

chris
adobe enteprise developer support

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

adobe