Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»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


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±í
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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ