asp include
aspÔÚµ÷ ÓÃÎļþµÄʱºòÒ»°ãÓà includeÓï¾äÈ磺<! #include file="filename.asp" -->ÔÚµ÷ÓÃÎļþµÄʱºò¶ÔÓÚ¾²Ì¬ÎļþÒ»°ãÓÃiframeÓÃinclude²»Æð×÷Óã¬ÔÚһЩ¶¯Ì¬µÄÎļþÃûµÄʱºòÒ»°ãÓà Èç¹ûÒª¶¯Ì¬µÄ°üº¬ÎļþÇëʹÓà ÈçÏ£º
server.transfer Îļþ
»ò
server.execute Îļþ
¶ø²»ÄÜÓ¦ÓÃÈç<! #include file="µ÷ÓõIJÎÊý.asp" -->
Ïà¹ØÎĵµ£º
¡¡¡¡1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡¼ÙÉèÓÐÒÔÏ´洢¹ý³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢¹ý³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE dbo.getUserList
as
set nocount on
begin
select * from dbo.[userinfo]
end
go
¡¡¡¡ÒÔÉÏ´æ´¢¹ý³ÌÈ¡µÃuserinfo±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ ......
ÎÊÌ⣺
aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡
´æ´¢¹ý³ÌÈçÏ£º
CREATE PROCEDURE GetRecordfromPage
@tblName varchar(255), -- ±íÃû
@fldName varchar(255), &nb ......
µÚÒ»ÖÖ£º
'ʹÓÃÊý¾Ý¿âÁ¬½Ó¶ÔÏó²éѯÊý¾Ý¼¯¶ÔÏó£¬Óà set±äÁ¿½ÓÊÕ¡£
set rset1 = conn.execute("select * from productType where id="&request("id"))
'±íʾֻÄÜÈ¡³ö½á¹û¼¯ÀïÃæµÄÖµ£¬µ«ÊDz»ÄÜÈ¡µ½×ܵÄÌõÊýÖ®ÀàµÄ¡£¡£¡£
set rset2 = conn.execute("select top 8 * from productType ......
dim dtNow
dtNow = date()
dim newDate
newDate = year(dtNow) & "-" & right("0" & month(dtNow),2) & "-" & right("0" & day(dtNow),2)
Õâ¸ö×Ô¶¯½«2010-4-20 ת»¯Îª 2010-04-20
http://w.sogou.com/question/99319695.html ......
ÔÚ±àдASP³ÌÐòµÄʱºò£¬Í¨³£¶¼»áÓõ½<!--#include virtual/file="path/filename"-->°ÑÒ»¶ÎÏà¶Ô¶ÀÁ¢µÄÎļþ´úÂëǶÌ×µ½µ±Ç°Ò³ÃæÖÐÀ´¡£
¡¡¡¡Ê¹ÓÃ"file"µÄʱºò£¬µÈºÅºóÃæÊ¹ÓõÄÊÇÏà¶Ô·¾¶¡£Ê¹ÓÃ"virtual"µÄʱºò£¬µÈºÅºóÃæÊ¹ÓõÄÊǾø¶Ô·¾¶¡£ºÜ¶àÈ˶¼²»ÖªµÀvirtualÕâ¸ö°üº¬¾ø¶Ô·¾¶¡£ ......