<%
Dim objRs, strSql, j
strSql = "SELECT * FROM buscompany WHERE sigunname = ?"
With oCmd
.ActiveConnection = dbcon
.CommandType = adCmdText
.CommandText = strSql
.Parameters.Append .CreateParameter("sigunname", 200, &H0001, 20, "서울특별시")
Set objRs = .Execute
End With
Do Until objRs.EOF
Write(objRs("name"))
objRs.MoveNext
Loop
Set objRs = Nothing
Response.End
%>'Dev & Mng' 카테고리의 다른 글
| PowerBand 2.1.0.1 (0) | 2006/11/09 |
|---|---|
| use oracle parametered query in asp (0) | 2006/10/26 |
| ADODB Command (0) | 2006/10/25 |
| ADODB Type Library (0) | 2006/10/25 |
