主题:一小短简单的程序,请各位大侠指教
dim Connstr,Myconn,Mysql
Connstr="DSN=register"
set Myconn=server.CreateObject("adodb.connection")
Myconn.Connectionstring=Connstr
Myconn.open
‘定义一个Insert的SQL语句,向register.mdb的member数据库表插入一条记录
mySQL="insert into member (UserID,UserPWD,Username,Birth,Diploma,TelPhone,CallPhone,IDCard,Province,City,Gender) values ('maguoyou','maguoyou','马国友','1978-1-1','15950548964','88888888','320923198208056332','江苏','南京','男')"
myConn.Execute mySQL
%>
错误类型:
Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/textsite/1/chap6/TMP29df7ejbkp.asp, line 12
‘定义一个Insert的SQL语句,向register.mdb的member数据库表插入一条记录
Connstr="DSN=register"
set Myconn=server.CreateObject("adodb.connection")
Myconn.Connectionstring=Connstr
Myconn.open
‘定义一个Insert的SQL语句,向register.mdb的member数据库表插入一条记录
mySQL="insert into member (UserID,UserPWD,Username,Birth,Diploma,TelPhone,CallPhone,IDCard,Province,City,Gender) values ('maguoyou','maguoyou','马国友','1978-1-1','15950548964','88888888','320923198208056332','江苏','南京','男')"
myConn.Execute mySQL
%>
错误类型:
Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/textsite/1/chap6/TMP29df7ejbkp.asp, line 12
‘定义一个Insert的SQL语句,向register.mdb的member数据库表插入一条记录