Any reason why you can't do this with a form with a textarea for the sql, maybe a file input for the textfile. Pass the SQL to a command/recordset object depending on the command syntax (select to recordset, everything else to command) and either display the results or a confirmation message.
What DB is it? You can probably incorporate the db's security into this tool. Doesn't sound like a very complex job, or am I missing something? Mark -----Original Message----- From: EXT-Sauceda, Gilbert [mailto:[EMAIL PROTECTED]] Sent: vrijdag 13 september 2002 0:28 To: ActiveServerPages Subject: RE: self-building database apps? there's probably a more efficient way, but what i would do is instantiate a shell object on the web server, via ASP, and execute the sql syntax entered by the user, using isql or osql. i've done this to dynamically create databases, via ASP, for managers who wanted a web interface to manage the whole database and application's permissions. -----Original Message----- From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 3:22 PM To: ActiveServerPages Subject: self-building database apps? I've been asked to develop a program that other database programmers - non web folk - can just 'drop an sql statement into' and perhaps provide a parameter so it knows whether to run another sql after some user input. (the notion is that the parameter would provide the name of a text file from which the other sql statement could be read . . . ). I have to redesign the concept a bit because it doesn't really take enough of the details into consideration. But before I go too far I wonder if other efforts have gone in such a direction. I remember reading about BuildApp but don't know how it works ... any suggestions for me to consider? Regards, Michael Gerholdt SUNY College at Fredonia --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
