Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : asp

ÇóÖú£º¹ØÓÚasp¶à·ÖÖ§Óï¾äµÄ´íÎó

±àдÁËÒ»¸ö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 ......

ASP¶àÌõ¼þÁªºÏ²éѯ£¬¿ÉÒÔ×Ô¼ºÑ¡Ôñ²éÌõ¼þ

¾ÍÏñÕâÑùµÄÕ¾
http://www.cqvip.com/asp/advanced.asp?suid=EGBNBFDHDNCBCOPIBOLGEMCBCDOIPNFP

άÆÕµÄ£¬¶àÖÖÌõ¼þ²éѯ£¬

ÄǸö ²¢ÇÒ »òÕß ²»°üº¬£¬£¬¾«È·£¬Ä£ºý  ÒªÔõôʵÏÖ£¿¸ø¸ö˼·¡£


²¢ÇÒ and
»òÕß or
²»°üº¬ not
¾«È·=
Ä£ºýlike

¸ù¾Ý²»Í¬µÄÑ¡ÔñÉú³É²»Í¬µÄSQLÓï¾ä¾Í ......

asp ÈçºÎʵÏÖ Êý¾Ý¿âÅÅÐò,²¢ÇÒ·ÖÒ³ÏÔʾ???

ÕÛÌÚNÌìÁË,¸ã²»¶¨,Çë¸ßÊִͽÌ~!лл~!

ÎÒÓõÄÊÇC#,´úÂëÇëÓÃC#д,VB,µÄ¿´²»Ì«¶®,ллÁË~!

¶ÔÊý¾Ý¿âÅÅÐòºóÈçºÎѡȡÆäÖÐÁ¬ÐøµÄÒ»¶Î?
ÈçºÎʵÔÚ·ÖÃæÏÔʾ?
лл~!@
ÅÅÐòÓÃorder by¾Í¿ÉÒÔ°É¡­¡­

ÓÿؼþGridView
°´ÕÕÏòµ¼ÉèÖþÍÐÐÁË£¬ºÜÈÝÒ׵ġ£

WITH OrdersByOrderIDASC AS
(
    ......

ÇóÒ»¸öASPÁ¬½Óµ½ORACLEÊý¾Ý¿âµÄÑù±¾³ÌÐò

-------------ÏÖÓл·¾³-----------------------------
±¾ÈËÒѾ­°²×°ºÃÈçÏ»·¾³£º
XPÉϵÄIIS
XPÉÏÒѾ­×°ºÃÁËORACLE ¿Í»§¶Ë
TNSNAMESΪ£ºorclcong
ͨ¹ýSQLPLUSµ½Ô¶³ÌÊý¾Ý¿âµÄÁ¬½Ó´®Îª£ºconn tantan/oracle@orclcong

Êý¾Ý¿â·þÎñÆ÷µÄÐÅÏ¢ÈçÏ£º
Êý¾Ý¿â°æ±¾£º10201
IPµØÖ·Îª£º192.168.6.129
Óû§ ......

ÔÚaspÖеÄÎÊÌâ ÓëÊý¾Ý¿âÓйØ

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 ËüÓ¦¸ÃÈ ......

ASPÏÂÀ­Ê½²Ëµ¥Ð´·¨ÄÄ´íÁË£¿Çë½Ì´ó¼Ò

<!--  #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 ......
×ܼǼÊý:1883; ×ÜÒ³Êý:314; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [267] [268] [269] [270] 271 [272] [273] [274] [275] [276]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ