Re: scripting indesign, mysql
Re: scripting indesign, mysql
- Subject: Re: scripting indesign, mysql
- From: Timothy Bates <email@hidden>
- Date: Fri, 19 Jul 2002 13:09:37 +1000
>
I'm new to applescript and looking for a solution to get data out
>
of a mysql database and into Indesign 2.0.
>
I want a direct way without another program.
>
Is this possible under OS X ?
Yes and No. If it were really true, either Indesign would need a mySQL
connection command, or AppleScript would need this native.
But, a simple solution is
1. make a php page on your apache server which takes a SQL sentence and
returns the result.
"www,mysite.com/sqlserver?query=select client from adverts where date < ()"
--> bob
jane
anne
Then just call this using "URL Access Scripting" or a command line call to
curl.
2. Alternatively, make the call to mySQL on the command line.
Command line scripting is so messy I would go with solution 1.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.