Re: SQL database and applescript? ?++
Re: SQL database and applescript? ?++
- Subject: Re: SQL database and applescript? ?++
- From: Lars DeRuntz <email@hidden>
- Date: Fri, 05 Apr 2002 15:04:06 -0800
>
> From: email@hidden
>
> 1) Use Microsoft Excel for Mac. Set up a worksheet with a QueryTable to use
This is a neat idea. If I had the time, right now, I'd try it out myself.
>
> 2) Use an ASP page on a local intranet server and communicate with it using
>
> URL Access from your script. It's fairly easy to write a generic ASP page
>
> that takes a SQL string as a form element and executes it against a database
What about a "GET", via URL search arguments? This could negate having to have an actual web form out there for people to load, and wonder "What's this for?"
>
> server, returning the results as an HTML file. Your script then has to parse
>
> that file to get any results you want back from the SQL server. But if it's
>
> a small operation, this is pretty quick using file read/write commands. One
Or InterNet Explorer's "GetSource"...(Oh, My God, am I actually recommending IE?!?!...yeah, I guess so)
Or, WebMiner, which I think someone around here had recommended, also..
>
> issue with this approach is security -- for the script to be able to post to
>
> that ASP without user interaction, the ASP must be using an anonymous
>
> account. Which means you're leaving an ASP out there on your intranet that
>
> will blindly execute any SQL thrown at it. So make sure that the SQL login
>
> that the ASP uses is relatively harmless to other data on your sever.
http://user:password@host/
But again, you get the user/password combo sent out there. I don't know if this is really any less secure, other than you can see it plainly in the URL. The user should not bookmark it, or be
using it when others may be looking over their shoulder.
All told, there could be some great uses. Thanks for sharing those!
-Lars DeRuntz
iLogistix
Fremont, CA
_______________________________________________
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.