注册 登录
编程论坛 ACCESS论坛

哪里出错了?

hehe198504 发布于 2006-07-03 21:26, 802 次点击

这句话哪里出错了?!
mySQL="Insert into downloads(Name,Image,Type,Size,Rank,Language,RefeshTime,Content)"
mySQL=mySQL+"values('"& myName &" ','"& myImage &"' ,'"& myType &" ','"& mySize &" ','"& myRank &" ','"& myLang &" ',#"& myTime &"#,'"& myContent &" ') "

2 回复
#2
greess2006-07-04 16:27
values前面加一个空格
#3
hehe1985042006-07-04 21:16

好像不行那!!!
看看这个!!!怎么回事?大虾们,求助!!!Help!!
mySQL="select * from downloads where Name='" & myName & " ' "
set myRes=myConn.Execute (mySQL)

if myRes.bof and myRes.eof then
response.write"上传成功!"
mySQL="insert into downloads(Name,Image,Type,Size,Rank,Language,RefreshTime,Content)"
mySQL=mySQL+"values ('"& myName &" ','"& myImage &"' ,'"& myType &" ','"& mySize &" ','"& myRank &" ','"& myLang &" ',#"& myTime &"#,'"& myContent &" ') "

myConn.Execute (mySQL)
response.write"<br>你已经上传成功!"
%>

<%
else
response.write"上传失败!"
%>

1