ASP数据库帮助 [英] ASP Database Help
问题描述
大家好，
我需要一些帮助：
我有一个带有表格的网页。此表单提交到mdb文件的数据
（id（自动编号），名称，电子邮件contry等）。我想制作另一个
页面，我可以输入ID号码，它只会显示所有字段
即id。
我希望我已经足够清楚......
非常感谢你的帮助。
Massa
Hi all,
I need some help on this one:
I have a webpage with a form. This form submits data that goes to a mdb file
(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for
that id.
I hope I''ve been clear enough...
Thanks a lot for you help.
Massa
推荐答案
2003年12月1日星期一21:37:23 -0200，马萨 <毫安***** @ ig.com.br>写道：
On Mon, 1 Dec 2003 21:37:23 -0200, "Massa" <ma*****@ig.com.br> wrote:
大家好，
我需要一些帮助：
我有一个带有表格的网页。此表单提交到mdb文件的数据
（id（自动编号），名称，电子邮件等）。我想再打一个
页面，我可以输入身份证号码，它只会显示所有字段。
我希望我已经足够清楚......
非常感谢你的帮助。
Hi all,
I need some help on this one:
I have a webpage with a form. This form submits data that goes to a mdb file
(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for
that id.
I hope I''ve been clear enough...
Thanks a lot for you help.
很清楚......你在哪里需要帮助？给出一些特定领域。我支付
因为你可以保存数据，你可以建立数据连接，
等
Very clear... where do you need help? Give some specific areas. I
assume since you can save the data, you can make a data connection,
etc.
I假设您已成功保存数据。
Dim sSQL
Dim oRS
Dim lngID
lngID = Request.Form（" theID"）''我假设您有一个表单提交了id
数字
sSQL =" SELECT columnName1 ，columnName2 FROM tableName WHERE primaryIDField ="
& lngID
设置oRS = validConnectionObject.Execute（sSQL）
如果不是oRS.EOF那么
Response.write"< ;表>< TR><的第i; column1的< /第><的第i;列2< /第>< / TR>" &
vbCrLf
Do while not oRS.EOF
Response.Write"< tr>< td>" &安培; oRS.Fields（" columnName1"）& "< / td>< td>"
& oRS.Fields（" columnName2"）& "< / TD>< / TR>" &安培; vbCrLf
RS.MoveNext
循环
Response.Write"< / table>" &安培; vbCrLf
结束如果
设置oRS = Nothing
" Massa" <毫安***** @ ig.com.br>在消息中写道
news：10 *************** @ gorgo.centroin.com.br ...
I assume you are successfully saving the data.
Dim sSQL
Dim oRS
Dim lngID
lngID=Request.Form("theID") ''I assume you have a form that submits the id
number
sSQL="SELECT columnName1, columnName2 FROM tableName WHERE primaryIDField="
& lngID
Set oRS=validConnectionObject.Execute(sSQL)
if not oRS.EOF then
Response.write "<table><tr><th>Column1</th><th>Column2</th></tr>" &
vbCrLf
Do While not oRS.EOF
Response.Write "<tr><td>" & oRS.Fields("columnName1") & "</td><td>"
& oRS.Fields("columnName2") & "</td></tr>" & vbCrLf
RS.MoveNext
Loop
Response.Write "</table>" & vbCrLf
end if
Set oRS=Nothing
"Massa" <ma*****@ig.com.br> wrote in message
news:10***************@gorgo.centroin.com.br...
大家好，
我需要一些帮助：
我有一个带有表单的网页。此表单提交到mdb
文件（id（自动编号），名称，电子邮件等）的数据。我想再打一个
页面，我可以输入ID号码，它会显示所有字段只有
的那个ID。
我希望我已经足够清楚......
非常感谢你的帮助。
Massa
Hi all,
I need some help on this one:
I have a webpage with a form. This form submits data that goes to a mdb file (id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for that id.
I hope I''ve been clear enough...
Thanks a lot for you help.
Massa
我无法弄清楚如何在这个页面输入我输入的身份证号码（带一个
确定按钮）。
谢谢
Massa
Dan Brussee <分贝****** @ nc.rr.com>在消息中写道
新闻：pe ******************************** @ 4ax.com ...
I can''t figure out how to make this page where I type the ID number (with a
ok button).
Thanks
Massa
"Dan Brussee" <db******@nc.rr.com> wrote in message
news:pe********************************@4ax.com...
2003年12月1日星期一21:37:23 -0200，Massa <毫安***** @ ig.com.br>写道：
On Mon, 1 Dec 2003 21:37:23 -0200, "Massa" <ma*****@ig.com.br> wrote:
大家好，
我需要一些帮助：
我有一个带有表格的网页。此表单提交到mdb
文件（id（自动编号），名称，电子邮件等）的数据。我想再打一个
页面，我可以输入身份证号码，它只显示所有字段
forthat id。
我希望我已经足够清楚... <非常感谢你的帮助。
Hi all,
I need some help on this one:
I have a webpage with a form. This form submits data that goes to a mdb file(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only forthat id.
I hope I''ve been clear enough...
Thanks a lot for you help.
很清楚......你在哪里需要帮助？给出一些特定领域。我假设你可以保存数据，你可以建立数据连接，等等。
Very clear... where do you need help? Give some specific areas. I
assume since you can save the data, you can make a data connection,
etc.
这篇关于ASP数据库帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
