Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Settha_RSD
Settha_RSD
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
5

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Settha_RSD
Customize the badges you want to showcase on your profile
Re: Filling a form with SQL table content - 1 page per record - Adobe LiveCycle 03-05-2010
Well, I managed to get the answer : never perform a SELECT * FROM but instead, name all the requested columns !Settha

Views

102

Likes

0

Replies

0
Re: Filling a form with SQL table content - 1 page per record - Adobe LiveCycle 03-05-2010
Managed to advance a bit but it seems to be a database query issue : -I set a MySQL connection to a database (test successful)-I want to get "table_1" content displayed (from the database)-> Using the following sentence from you example :xfa.sourceSet.DataConnection.nodes.item(1).query.setAttribute("text", "commandType");xfa.sourceSet.DataConnection.nodes.item(1).query.select.nodes.item(0).value = "Select * From table_1";then trying to connect :Error occurs on the connection part : // Need this ...

Views

103

Likes

0

Replies

0
Re: Filling a form with SQL table content - 1 page per record - Adobe LiveCycle 03-05-2010
Hi PaulWell I tried your script but I encountered few issues :- It does not display the correct information from my tables- You script is JavaScript isn't it ?Could you please send me the .mdb file you used so I can make it work ?I do use a mySQL table with a simple table containing 3 fields as example but I can get anything from it.RegardsSettha

Views

103

Likes

0

Replies

0
Re: Filling a form with SQL table content - 1 page per record - Adobe LiveCycle 22-04-2010
Thank you Paul, will try it and give feedback asap !By the way, is there a simple way to have the display per page and non per row ?RegardsSettha

Views

105

Likes

0

Replies

0
Filling a form with SQL table content - 1 page per record - Adobe LiveCycle 22-04-2010
GreetingsI am kinda new to manipulating database results in PDF.I am currently trying to generate a multi-pages PDF with a sql table query (in a first step) and I would like to get one record per content.For example : I have a table named : customers containing 10 records (names, adresses and so)I would like to have 1 customer per PDF page with all the informationHow can I do that ?- I can actually set up the database connection, returning me all the fields, but I do not see how to populate them...

Views

1.2K

Likes

0

Replies

6