此主题相关图片如下：sql tag.jpg

调用实例：产品报价

SQL 语句

select top  {$Param(0)} id,Title,Price from KS_Product where tid in(select id from ks_class where tn='{$Param(1)}') and  verific=1 and deltf=0  order by ID DESC

循环体：

[loop={$Param(0)}]

<div align=left style='line-height:20px;'>  <a href="{$Field(id,GetInfoUrl,5,1)}" target="_blank"> {$Field(Title,Text,18,0,2,无商品)}| </a><span style="color:#87ADD9">{$Field(Price,Text,0,0,0,无报价)}</span></div>

[/loop]

标签名字：产品报价

调用：{SQL_产品报价(12,20088575593290)}       括号内：       12->数量  后面tid