3wt.ezer.com:ASP:recordset getsqlserver-recordset:學習 asp sql html code 繁體中文 w3 Learning

你正在閱覽 :: 繁體中文 Chinese_Traditional

學習.主題:

首頁
ASP
. Active-Server-Flash
. Array
. Cache
. Connection
. Count
. Counter
. Distinct
. Email
. File
. Folder
. Function
. GetSQLserver
. Header
. mySQL
. Record
. Recordset
»GetSQLserver-Recordset
»GetSQLserver-StaticRecordset
»rs.open
. Request
. Response
. Server
. server-createobject
. ServerVariables
. Session
. Special-Symbols
. String
. Sub
. Time
CSS
Ecommerce
HTML
InternetProtocol
JAVA
Microsoft
php
Robots
SearchEngine
SQL
SQLserver
VBscript
XML

SiteMap

3w....學習.教學 > ASP > recordset » getsqlserver-recordset

3w learning

recordset >
getsqlserver-recordset

Title:

Get SQLserver Recordset - read data from SQLserver DB

由SQLserver 物件讀取資料

Description:

Get SQLserver Recordset - read data from SQLserver DB note: without using EOF or NOT EOF will appear [ error '80020009' ]

Example Code:

<%
sub= " order by c1"	
SQL="select * from Table where c1='"&b1&"' " & sub
Set rs= GetSQLserverRecordset( conn, SQL)
' remark: it is not GetSQLserverStaticRecordset
' remark: so do not use rs.AbsolutePosition=n
%> 
<% =rs("c2") %>

---------example 2 ---------------
<%
If rs.EOF Then <---- in case nothing
else
rs.MoveFirst
  while Not rs.EOF
    response.write rs("cX")
  rs.MoveNext
Wend
End if
%>

Example Result:

display c2 data .....[ the first row list data ] --------example 2 -------------- list all

...

[ 9/7/2010 ]

www learning school add more scripts and tips memo

You are at >>3WT.EZER.COM >> 3WT.EZER.COM/ASP/RECORDSET/GETSQLSERVER-RECORDSET.ASP>>ASP
Helpful link:: SEO web tools :: Live PR | SERP checker Google SERP pageranking checker

recordset > getsqlserver-recordset

recordset >
getsqlserver-recordset