Re: Submit Multiple SQL statemtents to one Execute statement

egan006@xxxxxxxxx wrote:
HI
I have code

Firstly
dim sql as string
dim con as adodb.connection
dim conStr as sring

conStr = "DSN Warehouse IP etc etc etc"
con.open constr
'This is not complete but this is not the problem'

Maybe, maybe not:
http://www.aspfaq.com/show.asp?id=2126


I have a text box on the form which is like an IDE
the user types a SQL into this say for example

delete from customer_table;
insert into customer_table
select * from old_customer_table;


or
drop database master

Ah, but this application is only intended to be used by trustworthy users. I
get it. :-)

This SQL script contains 2 statement which get assigned to sql
variable
when i try 'con.execute sql' i get an error

any suggestions,

LOL
How about:
Tell us what error you are getting!

Or
Tell us what database type and version you are using!!

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Submit Multiple SQL statemtents to one Execute statement
    ... dim con as adodb.connection ... dim conStr as sring ... conStr = "DSN Warehouse IP etc etc etc" ... the user types a SQL into this say for example ...
    (microsoft.public.data.ado)
  • Re: UPDATING/INSERTING DATETIME FIELDS FROM ASP?
    ... datetime/shortdatetime fields in an SQL database from an ASP? ... dim cn, cmd,sql,dateval ... cmd.commandtype = 1 'adCmdText ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Which identity?
    ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features? ... Another way to do it if using the .AddNew method on a Jet based ADO ... Dim rsTest As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: display data to user question
    ... I created a project that has an embedded SQl table with the scenario you ... Dim cn As New SqlConnection("Data ... Protected Sub Page_Load(ByVal sender As Object, ...
    (microsoft.public.dotnet.framework.aspnet)