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

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments

querying data


Not applicable
I have acces to a Microsoft Access data base via Livecycle Designer 8 and I want to compare the user name in the database to a user name I get from the the person filling out the form. I need to know how to put a specific name from a database into a variable so that I can compare the two values. Does anyone have any idea how I would I go about doing this?
0 Replies


Level 10
You will need to set up an ODBC connection to get the data from the database. Look in the help it describes how to access a DB. You can bind the appropriate column in the DB to a hidden field (holds the value). Then you can compare the two fields and perform the appropriate action.


Not applicable
sounds good. i am not familiar with the syntax of iterating through a database using livecycle, do you know where I can get some information on how to do this?


Level 10
In the designer help do a search on odbc and there are good instructions that tell you how to set up the connection. Once you have the connection setup it is a matter of creating the appropriate SQL statement and executing your query at the right time.