Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
User Experience
Lawson Design Studio
Populating List box
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
235
Members:
0
Total:
235
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Design Studio
Populating List box
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
jerome
New Member
Posts: 4
11/11/2005 1:17 PM
I am trying to populate a list box with a dme query. Does anyone have an example of how to do this ? I am also interested in some sort of reference guide if there is such a thing.
Thanks Jerome
jerome
New Member
Posts: 4
11/21/2005 3:46 PM
Ok I got my dropdown to populate from a custom file setup in Lawson. I modified the AP20 screen to add a dropdown on the account detail line. There are 5 detail lines so I had to create a loop to populate the dropdown for each row. Here is the code I used.
function FORM_OnInit()
{
var DMEstring = "/cgi-lawson/dme.exe?PROD=LAWAPP8&FILE=SXMCHG&FIELD=CHGCODE;CHGDESC;&XCOLS=TRUE&XKEYS=TRUE&XRELS=TRUE&XCOUNT=TRUE&XIDA=TRUE&XNEXT=TRUE&OUT=XML";
var DMEinfo = top.httpRequest(DMEstring);
if (DMEinfo.status)
{
alert(DMEinfo.status);
return;
}
var vOBJDMEXML = new top.DataStorage(DMEinfo);
var vRecords = vOBJDMEXML.document.getElementsByTagName("RECORD");
if (vRecords.length ==0)
{
alert("No Records Exist");
return true;
}
var k;
var i;
// get misc charge list
var miscList0 = document.getElementById("VALUES_f241r0");
var miscList1 = document.getElementById("VALUES_f241r1");
var miscList2 = document.getElementById("VALUES_f241r2");
var miscList3 = document.getElementById("VALUES_f241r3");
var miscList4 = document.getElementById("VALUES_f241r4");
for (k=0;k<5;k++)
{
for (i=0;i<vRecords.length;i++)
{
var vCols=vRecords[i].getElementsByTagName("COL");
var span = document.createElement("span");
span.setAttribute("text", vCols[1].firstChild.data); // long description
span.setAttribute("tran", vCols[0].firstChild.data); // transaction value
span.setAttribute("disp", vCols[0].firstChild.data); // display value
eval("miscList"+k).appendChild(span);
}
}
You are not authorized to post a reply.