Querying an SQL database
Querying an SQL database
- Subject: Querying an SQL database
- From: Steve <email@hidden>
- Date: Wed, 23 Apr 2003 14:03:00 +0100
Are there any tools or tricks available that I can use to get
AppleScript (or AS Studio) to query a mySQL database running on an OS X
Server from OS X Client machine?
I am currently working for a company that uses FileMaker for everything
except accounting and making the tea. FileMaker isn't the problem; the
problem comes from the volume of data and the fact that a lot of the
data is replicated - if it's changed in one place it has to be manually
changed in all the other places. I thought a nice, relational mySQL
database with an ASS front end would do the trick but I am unable to
find a way to connect the two.
Any suggestions gratefully received. If you're interested, what I'd
ideally like to be able to do is a query such as "SELECT CustomerID,
CompanyName FROM Customers" and display the result in a NSTableView.
And, since this is at an experimental stage, it would also help if the
solution was free, cheap or came with a long (60 day+) trail period.
Thanks in advance,
Steve
PS. I just found today that my employers firewall blocks any emails
that I send that contain the acronym version of Apple Script Studio...
Hmmm...
_______________________________________________
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.