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

irishfish72
irishfish72
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
6

Discussions

Discussions
0

Questions

Questions
6

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by irishfish72
Customize the badges you want to showcase on your profile
Re: Drop-down list to pull in Access record - Adobe LiveCycle 26-10-2011
Paul,Files have been sent. Happy Hunting.Misty

Views

553

Likes

0

Replies

0
Re: Drop-down list to pull in Access record - Adobe LiveCycle 26-10-2011
Paul,Thanks for being so patient. I know you guys hate us newbies. This is in FormCalc, not JavaScript, correct? I had to change != to <> or got syntax error.After that, got the followign error message:Accessor oDB.nodes.item("1").query.setAttribute("text","commandType") is unknownButton know looks like this:var nIndex = 0while(xfa.sourceSet.nodes.item(nIndex).name <> "DataConnection2") donIndex = nIndex + 1endwhilevar oDB = xfa.sourceSet.nodes.item(nIndex).clone(1)if (HasValue(SelectID)) thenoD...

Views

318

Likes

0

Replies

0
Re: Drop-down list to pull in Access record - Adobe LiveCycle 26-10-2011
Correct.

Views

320

Likes

0

Replies

0
Re: Drop-down list to pull in Access record - Adobe LiveCycle 26-10-2011
I have switched back to using this in my personal file and not test file so button script is as follows with your edit:if (HasValue(SelectID)) then$sourceSet.DataConnection2.clone(1).#command.query.commandType = "text"var sqlString = Concat("SELECT * FROM Medication WHERE MRN = '", Ltrim(Rtrim(SelectID.rawValue)) ,"'")xfa.host.messageBox(sqlString)$sourceSet.DataConnection2.clone(1).#command.query.select = sqlString$sourceSet.DataConnection2.clone(1).open()endifAnd got this... Warning: JavaScrip...

Views

319

Likes

0

Replies

0
Re: Drop-down list to pull in Access record - Adobe LiveCycle 26-10-2011
Hi Paul,Wow, I am so not getting this.Updated script on button to following:if (HasValue(SelectField)) then$sourceSet.DataConnection2.clone(1).#command.query.commandType = "text"var sqlString = Concat("Select * FROM OfficeSupplies Where ID = '", Ltrim(Rtrim(SelectField.rawValue)) ,"'")$sourceSet.DataConnection2.clone(1).#command.query.select = sqlString$sourceSet.DataConnection2.clone(1).open()endifBuilt second connection with "delayed open" checked and still not getting anything but first recor...

Views

322

Likes

0

Replies

0
Drop-down list to pull in Access record - Adobe LiveCycle 14-10-2011
Hi - I am a newby at this so please bear with me. I know this have been addressed a hundred times but I can't seem to find anyone else who is having this specific issue.I have v8.2.Since my scripting wasn't working, I downloaded the "Adobe LiveCycle Designer 7.0, providing interactive database lookup from forms" document to try and see if I can figure out what is going on.I built exactly as in document with exception of adding "clone(1)" as needed based on what I found in other postings about v8...

Views

3.0K

Likes

0

Replies

10