Execute 里怎么写SQL - 编程论坛

#2

octillion2008-08-03 21:24

给出出错状态

#3

icebo2008-08-03 21:36

insert into content (channelid,ClassID,Author,webfrom,Title,Image,Content,reContent,Tags,Isbest,Addtime,Adduser,Addip) values ('1','1','11111','tudou','11111111','images/nopic.gif','1111111111111111
sdf
asdfsadf

阿斯顿飞1111','<DIV class=toplogo><A href="http://www. height=60 alt=爱韩剧 src="http://127.0.0.1/images/toplogo.gif" width=200></A> </DIV>
<DIV class=topbanner><IMG height=60 alt=爱韩剧 src="http://127.0.0.1/images/468x60.jpg" width=468 border=0> </DIV>
<DIV class=toplink>
<UL>
<LI><SPAN style="CURSOR: hand" onclick="var strHref=window.location.href;this.style.behavior='url(#default#homepage)';this.setHomePage('http://www.');">将爱韩剧设置为首页</SPAN>
<LI><A onclick="javascript:window.external.AddFavorite('http://www.','爱韩剧');" href="http://www.将爱韩剧添加到收藏</A> </LI></UL></DIV>','111','False','2008-8-3 21:13:47','11','127.0.0.1')

提示语法错误

#4

icebo2008-08-03 21:38

出问题的地方就在 <DIV class=toplogo><A href="
因为这个"在insert into 语句里是有意义的，但是我不知道怎么转化啊

#5

yms1232008-08-04 09:14

insert into content (channelid,ClassID,Author,webfrom,Title,Image,Content,reContent,Tags,Isbest,Addtime,Adduser,Addip) values ('1','1','11111','tudou','11111111','images/nopic.gif','1111111111111111
字段和值不对应13个字段，只有7个值

#6

octillion2008-08-04 11:49

Sql的字符串里似乎双引号无所谓单引号双写貌似是这样的

再不行用AddNew方法

#7

hahatuzi20002008-08-04 13:17

在值的地方,加上个""试试,就是你自己说的那个<DIV>的值,从头到尾加""试试.