How to use database in Form designer

hi,

i haveing query on data dropdown list.

1. possible populate data dropdown list using query on load of form (ex want show name of person haveing salary less x)?

2.is possible make our query using 2 data base ?

<abhishek_upadhyay@adobeforums.com> ha scritto nel messaggio <br />news:3bbe62bd.-1@webx.la2eafnxani...<br />> hi,<br />><br />> haveing query on data dropdown list.<br />><br />> 1. possible populate data dropdown list using query on <br />> load of form (ex want show name of person <br />> haveing salary less x)?<br />><br /><br />i yes, never tried. theorically, have create odbc <br />connection db data interested in , attack <br />some javascript button on event load.<br />the js following or similar (from designer help):<br />//change commandtype table text. text equivalent of sql <br />property<br />$sourceset.dataconnection.#command.query.commandtype = "text"<br />//set select node. select in case whatever sql property <br />want<br />$sourceset.dataconnection.#command.query.select.nodes.item(0).value = <br />concat("select*from officesupplies id = ", datalistbox1.rawvalue,"")<br />//reopen data connection<br />$sourceset.dataconnection.open()<br /><br />> 2.is possible make our query using 2 data base ?<br /><br />no. can have 1 odbc connection form. may use <br />webservice in order read , write on more 1 db.<br /><br />bye,<br />alessio

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

adobe