🚀 go-pugleaf

Magnus--

InDesign's JavaScript is built around an Adobe ExtendScript interpreter inside InDesign. It can't communicate with COM objects outside the application. It *can* call VBScripts (or other JavaScripts, or AppleScript on the Mac OS) using the app.doScript method, but a.) you can't pass parameters directly to the scripts you run, and b.) you can't directly get return values back from the scripts you run.

What you can do, however, for simple text and numeric data, is to have the "parent" script stuff the data (as strings) into labels before calling the "child" script. The child script can then retrieve the data from the label or labels, do its processing, and then put any return data into the existing labels or create new labels for that purpose. The parent script can then get the data out of the labels. It's a bit clumsy, but it does work.

But, for this one, I think you might want to use VB/VBScript, which has quite a lot of built-in support for database access.

I almost forgot to mention--if your data is already in comma-delimited or tab delimited text file, you can simply read it from the file using JavaScript's File object.

Thanks,

Ole