±àдÁËÒ»¸öaspµÄ¹ØÓÚ¶à·ÖÖ§µÄÀý×Ó£¬½á¹ûÀÏÊdzö´í¡¡
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http ......
¾ÍÏñÕâÑùµÄÕ¾
http://www.cqvip.com/asp/advanced.asp?suid=EGBNBFDHDNCBCOPIBOLGEMCBCDOIPNFP
άÆÕµÄ£¬¶àÖÖÌõ¼þ²éѯ£¬
ÄǸö ²¢ÇÒ »òÕß ²»°üº¬£¬£¬¾«È·£¬Ä£ºý ÒªÔõôʵÏÖ£¿¸ø¸ö˼·¡£
²¢ÇÒ and
»òÕß or
²»°üº¬ not
¾«È·=
Ä£ºýlike
¸ù¾Ý²»Í¬µÄÑ¡ÔñÉú³É²»Í¬µÄSQLÓï¾ä¾Í ......
ÕÛÌÚNÌìÁË,¸ã²»¶¨,Çë¸ßÊִͽÌ~!лл~!
ÎÒÓõÄÊÇC#,´úÂëÇëÓÃC#д,VB,µÄ¿´²»Ì«¶®,ллÁË~!
¶ÔÊý¾Ý¿âÅÅÐòºóÈçºÎѡȡÆäÖÐÁ¬ÐøµÄÒ»¶Î?
ÈçºÎʵÔÚ·ÖÃæÏÔʾ?
лл~!@
ÅÅÐòÓÃorder by¾Í¿ÉÒÔ°É¡¡
ÓÿؼþGridView
°´ÕÕÏòµ¼ÉèÖþÍÐÐÁË£¬ºÜÈÝÒ׵ġ£
WITH OrdersByOrderIDASC AS
(
......
-------------ÏÖÓл·¾³-----------------------------
±¾ÈËÒѾ°²×°ºÃÈçÏ»·¾³£º
XPÉϵÄIIS
XPÉÏÒѾװºÃÁËORACLE ¿Í»§¶Ë
TNSNAMESΪ£ºorclcong
ͨ¹ýSQLPLUSµ½Ô¶³ÌÊý¾Ý¿âµÄÁ¬½Ó´®Îª£ºconn tantan/oracle@orclcong
Êý¾Ý¿â·þÎñÆ÷µÄÐÅÏ¢ÈçÏ£º
Êý¾Ý¿â°æ±¾£º10201
IPµØÖ·Îª£º192.168.6.129
Óû§ ......
sql="exec SqlStr 'top 1 smt_id,smt_title,SMT_news','smt_xxnews','SMT_key=1 and smt_newssort=20 and SMT_key1=1 and SMT_key2=1 and smt_key3=1','SMT_id desc'"
¸ßÊÖ½âÊÍÒ»ÏÂÉÏÃæÕâ¾äµÄÒâÒå ¾ÍÊÇÕâ¾äsqlÊÇÈçºÎÖ´ÐеÄ
ÏÂÃæÊÇÔÂë:£¨Ã»ÓÐselect ËüÓ¦¸ÃÈ ......
<!-- #include file="../db.inc.asp" -->
<table width="524" border="1">
<caption align=center> <h4>A±í </h4> </caption>
<tr>
<td width="159" align=center>B
&l ......