<%call query2table("select substring(name,1,4),price,units,substring(lxfs,1,5),substring(dates,6,5) from SCXX_price where cityid='12' or cityid='68' or cityid='68' and types='农副产品' and dates>getdate()-30 order by dates desc") '将cityid后的数字改为本市分配的代码 %>