¿´µ½Ò»¸öasp,Î񼆼̮æÊÇÔõôʵÏֵģ¬ÓÃѸÀ×ÊÔÁËÏÂÔØ£¬ºÃÏñ¿´²»µ½·þÎñ¶ËµÄ½Å±¾Êǰɣ¬ÕâÊÇʲôÔÒòÄØ
¿Í»§¶ËÏòweb·þÎñÆ÷ÇëÇóaspµÄʱºò£¬web·þÎñÆ÷½âÊÍÖ´ÐÐÆäÖеĽű¾¡£²¢½«Ö´Ðеõ½µÄHTML·µ»Ø¸ø¿Í»§¶Ë¡£
Èç¹ûIISÉèÖÃÁ˲»ÔÊÐí½Å±¾Ö´ÐУ¬¾Í¿ÉÒÔÏÂÔØ¿´µ½Ô´´úÂëÁË¡£
aspÊÇÔÚ·þÎñ¶ËÔËÐÐ×îºóÉú³Éhtml¸ñʽµÄÎļþ
È»ºóÄ ......
set rs=server.createobject("adodb.recordset")
set RS=server.createobject("adodb.recordset")
sql1="select jufenjiekou from A"
Rs.open sql1,conn,1,1
while not Rs.eof
sql2="select top 1 * from AE"
rs.open sql2,conn,1,3
²Ù×÷¡£¡£¡£
r ......
ÎÒ×î½üÒª×öÕâÑùÒ»¸öÔÚÏß¿¼ÊÔϵͳ£¬ÌâÄ¿¶¼×öºÃÁËÈ«²¿ÊÇWardÎĵµ£¬Ã¿Ì×ÌâÄ¿µÄÌâÁ¿¡¢¸ñʽ¶¼ÊÇÒ»ÑùµÄ¡£ÎÒµÄÒªÇóÊÇÄÜ×öµ½°´ÒªÇóËæ»ú³öÌ⣬ÿÖÖÌâÐ͵ÄÊýÁ¿¿ÉÒÔ°´ÊäÈëµÄÒªÇó½øÐÐ×éºÏ³ÉÒ»Ì×ÊÔ¾í¡£ÓÐ×ö¹ýµÄÅóÓѸø¸ö˼·£¬»òÕßÓÐÏà¹Ø´úÂë²Î¿¼Ï¡£ÎÊÌâ½â¾öÁË£¬ÎÒÔÙ×·¼Ó100·Ö¡£
×îºÃ½«ÌâÄ¿µ¼ÈëÖÁÊý¾Ý¿â£¬ÔÙ´ÓÊý¾Ý¿âÀïÈ¡Ì⣬ÕâÑù»áºÃ²Ù× ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµÚÒ»½×¶ÎÈÎÎñ£¬¾ÍÊÇÑÕÉ«±ä»»£¬×Ô¼º¿ØÖÆ£¬ºÜÈÝÒ×ʵÏÖµÄ
Â¥Ö÷ÊÇÒª½ø¶ÈÌõ°É,¸ãÕâôÊéÃæµÄÒ»¸ö´Ê,°Ñ´ó¼Ò»ï¶¼Î ......
ÀýÈçÎÒÓÐÒ»¸ö×Ö¶ÎÒª³ËÒÔ100£¬Ôõôд´úÂëÄØ
<%=rs("a1")*100%>
»òÊÇ <%=rs("a1")+rs("a2")%>
ÕâÑùд¶¼Êdzö´íµÄ
ÊDz»ÊÇÖ»ÄÜÔÚSQLÓï¾äÀïдºÃ£¿
sql="select a1*100 as a1 from table1"
È»ºóÔÙÔÚÏÂÃæÒýÓã¬ÕâÑù¾Í¿Ï¶¨ÊÇû´íµÄ¡£
<%=rs("a1&q ......
¸÷λ´óÏÀ£ºÇëÎÊÔõÑùÔÚASP³ÌÐòÖе÷ÓÃSQL´æ´¢¹ý³Ì£¿Ð»Ð»£¬Çë¸ø¸öÀý×Ó£¡
http://hi.baidu.com/lz0830/blog/item/e847e5e9077fde39b80e2db9.html
1 ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
set connection = server.createobject("adodb.connection")
connection.open someDSN
Connection ......