Adobe LiveCycle Designer ES
-
Goodday all, I have a couple of question concerning LC. 1) I got some code of the net for connecting to a database using a dsn. My dsn I created is call testDB, as I first want to test stuff before I use it, and my coneection is called DataConnection. Ths connection just contains a sql statement that selects two entities in the database, and in the code, I am creating a new sql statement that will select the same two entities, but this time determining what to select on the conditions provided. The code I got is shown below, and the errors I got is below that :
- var sCategoryName = xfa.resolveNode("form1.#subform[0].txtNameSurname").rawValue
- xfa.sourceSet.DataConnection.#command.query.commandType = "text"
- xfa.sourceSet.DataConnection.#command.query.select = concat("SELECT T_PIC, T_WORD FROM test WHERE T_USERN = ", sCategoryName, ";")
- xfa.sourceSet.DataConnection.open()
- xfa.sourceSet.DataConnection.first()
The errors I get is on line 2 and line 3, saying, respectively, during runtime when the code is being executed : Error : accessor 'xfa.sourceSet.DataConnection.#command.query.commandType' is unknown Error : accessor 'xfa.sourceSet.DataConnection.#command.query.select' is unknown. What is the problem here?:confused: 2) By using a DataBaseConnection, every single entry in the database is shown in the XML file that is being emailed to the specified recipient. How can I stop this from happening without writing an external application to remove this content and the sending this XML file to the specified recipient? If this can't be done, what other solution can I use to solve this query? :sigh: 3) If question 2 has a solution, can I select a random entry in the database using a sql statement? How can I update the database, like adding entries, etc.? :^) Thanx a lot
-
Goodday all, I have a couple of question concerning LC. 1) I got some code of the net for connecting to a database using a dsn. My dsn I created is call testDB, as I first want to test stuff before I use it, and my coneection is called DataConnection. Ths connection just contains a sql statement that selects two entities in the database, and in the code, I am creating a new sql statement that will select the same two entities, but this time determining what to select on the conditions provided. The code I got is shown below, and the errors I got is below that :
- var sCategoryName = xfa.resolveNode("form1.#subform[0].txtNameSurname").rawValue
- xfa.sourceSet.DataConnection.#command.query.commandType = "text"
- xfa.sourceSet.DataConnection.#command.query.select = concat("SELECT T_PIC, T_WORD FROM test WHERE T_USERN = ", sCategoryName, ";")
- xfa.sourceSet.DataConnection.open()
- xfa.sourceSet.DataConnection.first()
The errors I get is on line 2 and line 3, saying, respectively, during runtime when the code is being executed : Error : accessor 'xfa.sourceSet.DataConnection.#command.query.commandType' is unknown Error : accessor 'xfa.sourceSet.DataConnection.#command.query.select' is unknown. What is the problem here?:confused: 2) By using a DataBaseConnection, every single entry in the database is shown in the XML file that is being emailed to the specified recipient. How can I stop this from happening without writing an external application to remove this content and the sending this XML file to the specified recipient? If this can't be done, what other solution can I use to solve this query? :sigh: 3) If question 2 has a solution, can I select a random entry in the database using a sql statement? How can I update the database, like adding entries, etc.? :^) Thanx a lot
I strongly suspect that you are more likely to get an answer from the LiveCycle support forums, here[^], in case you don't know where they are.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
I strongly suspect that you are more likely to get an answer from the LiveCycle support forums, here[^], in case you don't know where they are.
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
I already tried that one. I got some info, thats why I asked these questions, because that didn't help a lot, only a bit, so now I am expanding that question.
OK. It's just that I'm not sure that there are that many people here that could answer your question. Still you never know. :) Good luck!
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
OK. It's just that I'm not sure that there are that many people here that could answer your question. Still you never know. :) Good luck!
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”