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

ASPÊý¾Ý¿â²éѯÁ¬±íÎÊÌâ~~~~~~~~~

a±íÖÐÓвúÆ·±àºÅ£¬b±íÖÐÒ²ÓÐÓвúÆ·±àºÅ£¬ÏÖÔÚÁ½¸ö±íÁ¬ÔÚÒ»Æð£¬µ«Ö»ÐèÒªÒ»¸ö²úÆ·±àºÅµÄÁÐÃû£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖ£©~~~~~
ÄãÒªÔõôÁ¬£¿Ìõ¼þ¶¼Ã»Ëµ£¿2¸öIDÏàµÈΪÌõ¼þ£¿

¶Ô~~ÒÔËûÃǵIJúÆ·±àºÅΪÌõ¼þ~~~ÊÇSQL2000µÄ~~£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖÁ¬½Ó·½·¨£©~~~~~




Ò²¾ÍÊÇ説Á¬½Óʱ°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô

¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

ÒýÓÃ
¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~


ÒýÓÃ
ÒýÓà 4 Â¥ chinmo µÄ»Ø¸´:
¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~


lzΪʲôÌáÈ¡Êý¾ÝµÄʱºò×ÜÓÃÕâÖÖ·½·¨ÄØ£¿
ÓÃlfet join ÒѾ­È·¶¨ÁËÕâ¸ö²úÆ·idÊÇ´ÓA±íÖжÁÈ¡³öÀ´µÄ°¡£¿


û°ì·¨°¡~~ÀÏʦ¸øµÄÄÑÌâ~~Æäʵ~~ÎÒÒ²ÊÇͦÓôÃÆµÄ~~´ó¼Ò~·°ï°ïæßÂ~~~

±äÁ¿ÊdzÌÐò²úÉ


Ïà¹ØÎÊ´ð£º

Çó¸ÄÒ»¸öASPС³ÌÐò¼ÓÉÏ´«¹¦ÄܺÍÏÂÔØ¹¦ÄÜ¡£¡£

Îļþ£ºfolder.inc
HTML code:

<%
Dim folderini,pos,pageName
fPath = Request.ServerVariables("PATH_TRANSLATED")
pos = instrRev(fPath,"\")
folderini = Left(fPath,pos)+&qu ......

³õʶasp,Çë¸ßÊÖÖ¸½Ì

ÎÒÏëÓÃaspд¸öÒ³ÃæÒÔǰûÓнӴ¥¹ý£¬ÎÒ¿´ÍøÉÏ˵aspµÄÔËÐл·¾³Ö»ÄÜÊÇwindows£¬»¹±ØÐëҪװIIS¡£
Çë½Ì¸÷λ¸ßÊÖ£¬asp»¹ÓÐÆäËûµÄÔËÐл·¾³Âð?
²î²»¶à¾ÍÕâЩÁË£¬¾ÍÊÇIISÒ»¶¨Òª×°ºÃ
»¹ÓÐÒªÊÇÓÃVS2005µÄ»°ºÃÏñ¿ÉÒÔÖ±½ÓÔ ......

aspÉý¼¶µ½asp.net£¬ºÃ¶à½á¹¹¶¼²»ÖªµÀÈçºÎת»»

aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É
<%
if ȨÏÞ=1 then
%>
<input type="submit" name="Submit" value="Ìá½»" />
<%
end i ......

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ