Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ : access

Dreamweaver 8ÖÐÏÔʾAccessÊý¾Ý¿âÖеÄͼƬ£¿

ÎÒÓÃDreamweaver 8 ×öÍøÒ³£¬µ±×öµ½ÒªÏÔʾÊý¾Ý¿âÖеÄͼƬÊÇ£¬ÎÒÖ±ÏÈÌí¼ÓÁËÒ»¸ö¡°Í¼Ïñ¡±¿Ø¼þ£¬È»ºó½«Êý¾Ý¼¯¡°picture¡±Ö±½ÓÍϵ½¸Ã¿Ø¼þÉÏ£¬¿ªÊ¼²»ÄÜÏÔʾͼƬµÄ£¬ÎÒÓÚÊǽ«ÓйظÃÊý¾Ý¿âµÄͼƬ¸´ÖƵ½ÎÒ½¨Á¢µÄÕ¾µãµÄ¸ùĿ¼Ï£¬Í¼Æ¬¾ÍÄÜÏÔʾÁË£¡ÕâÑùÕæµÄºÜÂé·³£¬ÒòΪȫ²¿Í¼Æ¬¶¼·Åµ½Õ¾µãµÄ¸ùĿ¼»áµ¼ÖÂÕ¾µãÌ«ÔÓÂÒ£¬¡£ÎÒÏ뽫ͼƬµ¥¶À± ......

ÄÄλÄܸøÎÒЩDELPHI7+ADO·ÃÎÊACCESSµÄ´úÂëʵÀý£¬¶àл

ÎÒ×ÔѧµÄD7£¬·¢ÏֺܻìÂÒ£¬ÌرðÊÇ·ÃÎÊACCESSµÄ·½·¨Óкö࣬ÀýÈç¿ÉÒÔÓÃadoconnection¿Ø¼þÁ¬½Ó¿â£¬»¹¿ÉÒÔÓÃ×Ö·û´®£¬Ôöɾ¸ÄµÄ·½Ê½Ò²ºÃ¼¸ÖÖ£¬¶¼²»ÖªµÀ¸ÃÓÃÄÄÖÖ·½·¨ÁË¡£
ÄÄλÄܸøÎÒµãÀý×Ó£º
ÐèÒªµÄÊÇÏÔʾ¼Ç¼¡¢Ìí¼Ó¼Ç¼¡¢É¾³ý¼Ç¼·½ÃæµÄ¡£
·Ç³£¸Ðл£¡
google,baidu ÀïÃæµ½´¦ÊÇ....ÚÀ

ÕÒÁ˼¸±¾Ê飬¶àÊýÊǽ²ÍϿؼþÈ»ºó×Ô¶¯Ö´ ......

£¨¼±£©ÅжÏAccessÊý¾Ý¿âÖÐÊÇ·ñ¼Ç¼Öظ´

ÎÒÏÖÔÚÏëʵÏÖÒ»ÏÂÕâÑùµÄ¹¦ÄÜ£º
ÔÚÎÒ±£´æ¼Ç¼֮ǰ£¬Ïȼì²éÒ»ÏÂÊý¾Ý¿âÖÐÊÇ·ñÒѾ­´æÔÚͬÑùµÄ¼Ç¼£¬SQLÓïÑÔÓ¦¸ÃÔõôÑùд£¿£¨ADOQuery£©Á¬½ÓÊý¾Ý¿â¡£
ʹÓÃgroup by ij¼¸¸ö×ֶΠhaving count(*)>1 ¼´¿É


ÒýÓÃ
ʹÓÃgroup by ij¼¸¸ö×ֶΠhaving count(*)>1 ¼´¿É
count(*)>1µÄ»°,±íÖÐÒѾ­ÓÐÖظ´µÄ¼Ç¼ÁË

Ò»°ãµÄ± ......

phpÁ¬½ÓaccessÊý¾Ý¿âʱ³ö´í

$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn->Open($connstr);
$rs = @new COM("ADODB.RecordSet");
$sql ="select * from admin&quo ......

ÈçºÎÔÚAccess²éѯÖÐ×Ô¶¨Òå´ø¡°.¡±µÄ×Ö¶ÎÃû

ÎÒÊÔÁËÏÂÕâ¸öÓï¾ä ÔÚsql server ÖÐÄÜͨ¹ýµÄ ÔÚaccessÖоͲ»ÐÐ
SELECT С°à.С°àºÅ as [С°à.С°àºÅ]
from С°à;
²»ÖªµÀÔõôÔÚAccessÖж¨Ò塰С°à.С°àºÅ¡±ÕâÑùµÄ×Ö¶ÎÃû

ACCESS²»ÔÊÐíÕâÑùÓï·¨

SQL code:
as [С°à.С°àºÅ]
SQL code:
as "С°à.С°àºÅ"

SQL code:
SELECT С°à.С°àºÅ as 'С°à. ......

Óöµ½accessÊý¾Ý¿âµÄÕûÊýÐͿռǼ±¨´í£¬ÈçºÎÐÞ¸Ä

<%if rs("tuijian")>0 then%>
  <a href=admin_article.asp?action=tuijianno&id=<%=rs("id")%>><font color=red>ÊÇ</font></a>
  <%else if rs("tuijian")=-1¡¡then%>
  ·ñ
  <%else%& ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [19] [20] [21] [22] 23 [24] [25] [26] [27] [28]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ