OK, got it. Thanks. -----Original Message----- From: Framers [mailto:framers-bounces+rick=rickquatro....@lists.frameusers.com] On Behalf Of Scott Prentice Sent: Monday, February 27, 2017 8:28 PM To: framers@lists.frameusers.com Subject: Re: [Framers] database access from Extendscript?
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....@lists.frameusers.com] On > Behalf Of Scott Prentice > Sent: Monday, February 27, 2017 4:30 PM > To: framers@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. >>> r...@frameexpert.com >>> 585-366-4017 >>> >>> >>> >>> -----Original Message----- >>> From: Framers >>> [mailto:framers-bounces+rick=rickquatro....@lists.frameusers.com] On >>> Behalf Of Alan Houser >>> Sent: Monday, February 27, 2017 3:18 PM >>> To: framers@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@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 listad...@frameusers.com >> > _______________________________________________ > > This message is from the Framers mailing list > > Send messages to framers@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 listad...@frameusers.com > > _______________________________________________ > > This message is from the Framers mailing list > > Send messages to framers@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 listad...@frameusers.com > _______________________________________________ This message is from the Framers mailing list Send messages to framers@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 listad...@frameusers.com _______________________________________________ This message is from the Framers mailing list Send messages to framers@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 listad...@frameusers.com