注册 登录
编程论坛 ASP技术论坛

超级笨问题. SQL语句转Access 语句

leaftest 发布于 2007-08-21 11:10, 490 次点击
用惯了sql server 突然发现要写基于Access的语句时写不来了

Set conn = GetSQLServerConnection( DBName,DBUserName,DBPassWord,"classtable")
Set cmd = Server.CreateObject( "ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText= = "insert into classtable (username,pwd,zhucedate) VALUES ('" & getusername & "','" & getpassword & "','" & now() & "')"
cmd.Execute


以上是连接sql的语句,getusername之类的都是变量不用管它,请问支持mdb数据库的话,该怎么改
2 回复
#2
ayue2222007-08-21 11:47
都一样的撒 ...... 貌似没啥区别 ..不过你这样的写法偶从来米写过 ...
#3
multiple19022007-08-21 12:16
没用过这种写法

我一般用
Connstr="driver=.... data source=..."
CONN(adodb.connection).open connstr
conn.execute("delete from users where id=1")
1