RE: Querying an SQL database
RE: Querying an SQL database
- Subject: RE: Querying an SQL database
- From: "Rose, Eric" <email@hidden>
- Date: Wed, 23 Apr 2003 14:29:23 -0400
There is a program I've been using called "MacSQL" which gives you
a way to run queries against a MySQL database. It advertises itself
as being 'fully scriptable', so it might support the kind of query
event you are describing here. Check it out at www.rtlabs.com/macsql/
Eric.
-----Original Message-----
From: Steve [
mailto:email@hidden]
Sent: Wednesday, April 23, 2003 9:03 AM
To: email@hidden
Subject: Querying an SQL database
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.
_______________________________________________
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.