高手们帮我看看这个小问题吧？

[dendoll]

findword="product_name like '%"&productname&"%' "
oldfathergrandfather_id="oldfathergrandfather_id='"&c1_id&"' "
sql="select * from product where "&oldfathergrandfather_id&" and "&findword&" "
sql=sql&" order by product_id desc"
rs.open sql,conn,1,1
rs.close

放在网页上后不起作用，但也不出错

[dendoll]

顶

[PPLUNCLE]

楼主为什么不把条件都加在一起
oldfathergrandfather_id="oldfathergrandfather_id='"&c1_id&"' "
上面那一句真的可以那么写吗?我没试过,但是我觉得楼主的写法不符合规范写法!

[dendoll]

这么写也没错啊！

[monkeys]

你要这样写，无可非议
你先将你的sql语句输出来看看

[stefli]

应该没有错误啊
response.write sql
然后看看有没有满足条件的数据

[dendoll]

用response.write sql语句后浏览网页中显示：

select * from product where oldfathergrandfather_id='' and oldgrandpapa_id='' and grandfather_id='' and product_name like '%1%' order by product_id desc

怎么看有没有满足条件的数据呢？请多指教！