ÇóÒ»SQLÓï¾äµÄת»»
ÏÖÔÚÓÐÒÔÏÂSQLÓï¾ä£º
<stl:sqlContents connectionStringname="connectionStringname">
<stl:queryString>
SELECT TOP 30 image, ('http://www.postcha.com/xiaohua/xiaohua_' + cast(id as varchar) + '.html') AS xiaohua_Url from au_xiaohua
ORDER BY newid()
</stl:queryString>
<ul id="rarclist" class="arclist">
<li><a href="{Sql.xiaohua_Url}" target="_blank"><img src="{sql.image}"></a></li>
</ul>
</stl:sqlContents>
µ«ÊÇÏÖÔÚÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇÔÚimage×Ö¶ÎÖдæµÄÊÇ@/upload/2010/postcha.jpgÕâÑùµÄÖµ£¬¾ÍÊÇ´øÓÐ@Õâ¸ö×Ö·û¡£ÒòΪ³ÌÐòµÄĬÈϵ÷ÓÃͼƬÊÇ<stl:image>±êÇ©£¬¿ÉÒÔ½«@ת»¯Îªµ±Ç°Õ¾µãµÄÓòÃû£¬µ«ÊDz»Ö§³ÖËæ»úÏÔʾ¡£
ÉÏÃæÉú³ÉµÄ´úÂëÊÇ<a href="'http://www.postcha.com/xiaohua/xiaohua_1.html"><img src="@/upload/2010/postcha.jpg"></a>£¬Õâ¸ö@ûÓÐת»»µô£¬µ¼ÖÂͼƬ²»ÄÜÏÔʾ¡£
ËùÒÔ¾ÍÏëÖ±½ÓÓÃsqlÓï¾äÀ´²éѯ£¬µ«ÊÇÏÖÔÚÓÖÓöµ½Õâ¸ö@ת»»µÄÎÊÌ⣬ÄĸöSQL¸ßÊÖ°ïæ¿´¿´¡£
SQL code:
replace(col,@,'')
СµÜÓÞÃÁ£¬Õâ¸ö²ÎÊýÒª·ÅÔÚÄĸöλÖ㿸Ðл¡£
SQL code:
SELECT TOP 30 image, REPLACE(('http://www.postcha.com/xiao
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
±í
id bh
1 10
2 11
3 12
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:
declare @t tabl ......