strSql1 = "select title,govAgentName,companyName,tb_govAgentApplication.releaseDate,REPLACE(Detailinfo,'\n',' <p> ') as Detailinfo"
+ " from tb_govAgentApplication,tb_RegisterCompany,tb_govAgentGroup"
+ " where tb_govAgentApplication.applicationID='" + applicationID
+ "' and tb_govAgentApplication.companyID= tb_RegisterCompany.companyID"
+ " and tb_govAgentApplication.govAgentID=tb_govAgentGroup.govAgentID";
+ " from tb_govAgentApplication,tb_RegisterCompany,tb_govAgentGroup"
+ " where tb_govAgentApplication.applicationID='" + applicationID
+ "' and tb_govAgentApplication.companyID= tb_RegisterCompany.companyID"
+ " and tb_govAgentApplication.govAgentID=tb_govAgentGroup.govAgentID";
你可以执行一样,看提示什么错误,现做分析。
from tb_govAgentApplication,tb_RegisterCompany,tb_govAgentGroup"
where tb_govAgentApplication.applicationID=" + applicationID
and tb_govAgentApplication.companyID= tb_RegisterCompany.companyID"
and tb_govAgentApplication.govAgentID=tb_govAgentGroup.govAgentID";
replace不可以在select主句出现吧...
replace(Detailinfo,'\n','<p>') as Detailinfo
from tb_govAgentApplication a inner join tb_RegisterCompany b
on a.companyID=b.companyID inner join tb_govAgentGroup c
on a.govAgentID=c.govAgentID
where a.applicationID='applicationID'
正规一点
applicationID不是数字值,需要加个引号
--try:strSql1 = "select title,govAgentName,companyName,tb_govAgentApplication.releaseDate,REPLACE(Detailinfo,'\n',' <p>') as Detailinfo"
+ " from tb_govAgentApplication,tb_RegisterCompany,tb_govAgentGroup"
+ " where tb_govAgentApplication.applicationID='" + applicationID
+ "' and tb_govAgentApplication.companyID= tb_RegisterCompany.companyID"
+ " and tb_govAgentApplication.govAgentID=tb_govAgentGroup.govAgentID";
+ " from tb_govAgentApplication,tb_RegisterCompany,tb_govAgentGroup"
+ " where tb_govAgentApplication.applicationID='" + applicationID
+ "' and tb_govAgentApplication.companyID= tb_RegisterCompany.companyID"
+ " and tb_govAgentApplication.govAgentID=tb_govAgentGroup.govAgentID";
======
这句话后面的条件tb_govAgentApplication.applicationID这个字段是个字符串类型的吗?如果是的话,要加上单引号:
"...where tb_govAgentApplication.applicationID='"+applicationID +"'....";
ps:我刚刚说错了,那个表别名就不要用as了.
\n 是 C# 关键字...
请用\\n
在 SQL 應該用 CHR(13) 或 CHR(13) + CHR(10) 代替