Re: [ASP ] ASP連結SQL sever問題

看板Visual_Basic作者fumizuki (矇面加菲獅)時間19年前 (2006/11/11 17:36)推噓0(0推 0噓 0→)

留言0則, 0人參與討論串2/2 (看更多)

方法一： Set conn = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") conn.open "log", "test" , "test" Set cmd.ActiveConnection = cn cmd.CommandType = 2 'Open Table cmd.CommandText = "table" Set rs = cmd.Execute() 方法二： Set conn = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") conn.open "log", "test" , "test" Set cmd.ActiveConnection = cn cmd.CommandType = 1 '可以省略這行 cmd.CommandText = "select * from table" '下查詢語法 Set rs = cmd.Execute() 方法三： Set conn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") conn.open "log", "test" , "test" Set rs.ActiveConnection = cn rs.Open "select * from table" '下查詢語法方法四： Set conn = CreateObject("ADODB.Connection") Set rs = CreateObject("ADODB.Recordset") conn.open "log", "test" , "test" rs.Open "select * from table", conn '下查詢語法方法五： Set conn = CreateObject("ADODB.Connection") conn.open "log", "test" , "test" Set rs = conn.Execute("select * from table") '下查詢語法 -- ▃▅▇▆▄ ▆▂▃ ` 逝去感情如何能留住，半點癡情遺留殊不易，██▅▇▄▃ ▇▃▂" . █████████▃i ▁▄▇ 更多悽悽慘慘的遭遇…………██▆▃ █▅▆▃ˍ▄* ◢ ▂█▄▇▅▂▌. 我不知道，王～八～蛋～～！ ▂▆███ █▄▃ 。fumizuki。Check。 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 210.58.156.20