Forum Discussion

JackFretwell's avatar
JackFretwell
Qrew Assistant Captain
7 years ago

Java code for DoQuery and return value from another table to populate field

Help with code: So imagine I have a customer quote table and a lookup table for reference values, things the customer selects, there are a lot so relationships would fail here as I need to connect ...
APIs and custom code
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
I think this is the offending line:
      _fid_59.value += '$("peritem", this).text();' // not sure what this line is doing
To confirm you can stuff  a value in fid=59 replace with this:
      _fid_59.value = "foo";
If your query is guaranteed to return a single record:
  _fid_59.value = $("peritem", xml).text();

If your query returns multiple records and you want to concatenate them into fid=59 try this:
  $("peritem", xml).each(function() {
    _fid_59.value += $("peritem", this).text();
  })