请问如何用在asp中用conn.excute的方法清空一个数据表? (100分)

D

downage

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-25

• #1

请给出完整语句,谢谢!

 

N

netarct

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-25

• #2

ADOQuery1.sql.close;
ADOQuery1.sql.clear;
ADOQuery1.sql.add('delete from tablename')
ADOQuery1.execute;

 

H

hmjku

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-25

• #3

没错，用上面的方法就行了

 

D

downage

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-25

• #4

大哥们,我用asp!!

 

P

pink_wt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-26

• #5

conn.excute("delete from tablename")

 

D

downage

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-26

• #6

db="logo.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " &
Server.MapPath(db)
set conn=server.createobject("ADODB.connection")
conn.open connstr
sql="delete from logo"
set rs=conn.excute(sql)
难道这样不对么?

 

D

dgweb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2004-03-27

• #7

下面修改是正确的执行：
Provider = "Provider = Microsoft.Jet.OLEDB.4.0;"
DBN = Provider &"Data Source="&
Server.MapPath("Sample.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DBN &";Jet OLEDBatabase Password="&
Pssword
Set Cmd = Server.CreateObject("ADODB.Command")
Set Cmd.activeConnection = Conn
Cmd.Commandtext = "Delete From YouTable"
Cmd.Execute