1、逻辑判断问题
<%#(bool)Eval("Eval("flower")=true?"<IMG height=14 src=../images/digest_1.gif >":""%>
错误提示:赋值号左边必须是变量、属性或索引器
2、联合查询问题
string sql = "select a.*,b.* from [users] a inner join [bbs_info] b on a.id=b.userid order by a.[id] desc";
我想让users表中的work1字段名不重复,怎么办?谢谢!!
...全文
14514打赏收藏
请教SQL不重复查询和aspx页面逻辑判断问题
1、逻辑判断问题 <%#(bool)Eval("Eval("flower")=true?"":""%> 错误提示:赋值号左边必须是变量、属性或索引器 2、联合查询问题 string sql = "select a.*,b.* from [users] a inner join [bbs_info] b on a.id=b.userid order by a.[id] desc"; 我想让users表中的work
select a.* ,b.* from
(select * from users u where not exists (select 1 from users where work1=u.work1))
a inner join [bbs_info] b on a.id=b.userid
order by a.[id] desc";