[Framers] database access from Extendscript?

[Scott Prentice]

Hi Rick...

Not FDK .. but the MS function SQLExecDirect() (and friends). It works 
quite well.

...scott



On 2/27/17 5:12 PM, Rick Quatro wrote:
> Hi Scott,
>
> Are there built-in FDK functions for accessing ODBC? Thanks.
>
> Rick
>
> -----Original Message-----
> From: Framers
> [mailto:framers-bounces+rick=rickquatro.com at lists.frameusers.com] On Behalf
> Of Scott Prentice
> Sent: Monday, February 27, 2017 4:30 PM
> To: framers at lists.frameusers.com
> Subject: Re: [Framers] database access from Extendscript?
>
> Hmm. You can connect to ODBC through the FDK .. could probably expose that
> to an ExtendScript call. Of course, if you're going to do part of it in FDK,
> you might as well do all of it there.
>
> I wonder if it's possible to make Ajax calls from ExtendScript ..
> probably not. But if that was possible, you could use that to pull your data
> from the "cloud" (if your data was there).
>
> Probably not terribly useful thoughts ..
>
> ...scott
>
>
> On 2/27/17 1:19 PM, Alan Houser wrote:
>> Thanks, Rick. Appreciated. Most of my automated publishing projects
>> are XML-based. But on occasion (like this one) the client wants to go
>> directly from an ODBC connection.
>>
>> Alas, there are still good reasons to use FrameScript!
>>
>> -Alan
>>
>>
>> On 2/27/17 3:45 PM, Rick Quatro wrote:
>>> Hi Alan,
>>>
>>> The short answer is no, ExtendScript doesn't have any built-in ODBC
>>> capabilities. The closest you can get is to see if your database
>>> content can be exported to XML and then use ExtendScript to parse and
>>> import the XML to FrameMaker. ExtendScript has a built-in XML object
>>> that is pretty good. It has an xpath method that lets you perform
>>> XPath 1.0 queries on the XML object.
>>>
>>> Rick
>>>
>>> Rick Quatro
>>> Carmen Publishing Inc.
>>> rick at frameexpert.com
>>> 585-366-4017
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Framers
>>> [mailto:framers-bounces+rick=rickquatro.com at lists.frameusers.com] On
>>> Behalf Of Alan Houser
>>> Sent: Monday, February 27, 2017 3:18 PM
>>> To: framers at lists.frameusers.com
>>> Subject: [Framers] database access from Extendscript?
>>>
>>> Colleagues,
>>>
>>> I'm a bit spoiled by the FrameScript database utilities, and am
>>> trying to do similar database publishing with Extendscript. For those
>>> on the list who have worked with both, does Extendscript provide any
>>> database I/O capabilities? (I believe the answer is "no"). If it does
>>> not, is there a Javascript library that you've found to be workable?
>>>
>>> -Alan
>>>
>>> --
>>> Alan Houser
>>> Group Wellesley, Inc.
>>> Consultant and Trainer, Technical Publishing arh on Twitter
>>> 412-450-0532
>>>
>> _______________________________________________
>>
>> This message is from the Framers mailing list
>>
>> Send messages to framers at lists.frameusers.com Visit the list's
>> homepage at  http://www.frameusers.com Archives located at
>> http://www.mail-archive.com/framers%40lists.frameusers.com/
>> Subscribe and unsubscribe at
>> http://lists.frameusers.com/listinfo.cgi/framers-frameusers.com
>> Send administrative questions to listadmin at frameusers.com
>>
> _______________________________________________
>
> This message is from the Framers mailing list
>
> Send messages to framers at lists.frameusers.com Visit the list's homepage at
> http://www.frameusers.com Archives located at
> http://www.mail-archive.com/framers%40lists.frameusers.com/
> Subscribe and unsubscribe at
> http://lists.frameusers.com/listinfo.cgi/framers-frameusers.com
> Send administrative questions to listadmin at frameusers.com
>
> _______________________________________________
>
> This message is from the Framers mailing list
>
> Send messages to framers at lists.frameusers.com
> Visit the list's homepage at  http://www.frameusers.com
> Archives located at http://www.mail-archive.com/framers%40lists.frameusers.com/
> Subscribe and unsubscribe at http://lists.frameusers.com/listinfo.cgi/framers-frameusers.com
> Send administrative questions to listadmin at frameusers.com
>