如何使用ASP从不同的Ms Access表中检索数据 [英] how to retrive data from different Ms Access tables using ASP
问题描述
hi
我正在使用Ms Access和ASP设计数据库。我有3个访问表，即''PERSONAL''，其他为''POLICY''，第3个表被命名为''STAFF''。在联系表中我有ID，名称，子项为字段。同样在策略表中，firlds是： - ID，date_of_policy，no_policy，amount_paid，amount_balance，类似地，第3个，即员工的字段很少。所有三个链接我的共同字段是ID
我想要的是当用户搜索特定名称（来自前端）时它应该搜索表 - ''PERSONAL'' （字段 - 姓名和儿童）。一旦它在ID的帮助下获得了特定的名称，它应该从该特定名称的''POLICY''和''STAFF''中检索数据。
i确实知道如何从同一个表中搜索和检索数据但是对于如何使用PERSONAL表来检索来自不同表的数据有点困惑，仅供参考和链接到其他2个表
plz help
感谢
neha
hi
i am designing a database using Ms Access and ASP. i have 3 tables in access namely ''PERSONAL'', other as ''POLICY'' and 3rd one is named as ''STAFF''. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, amount_paid, amount_balance and similarly the 3rd ie., staff has few fields. all three are linked my a common field which is ID
all i want is when the user searches for a perticular name (from frontend) it should search through table- ''PERSONAL'' (fields- Name and Children). once it get the perticular name with the help of the ID it should retrive the datafrom both ''POLICY'' and ''STAFF'' of that perticular Name.
i do know how to search and retrive data from the same table but got a bit confused on how to retrive data from different tables using the ''PERSONAL'' table just for reference and linking to the other 2 tables
plz help
thanking
neha
推荐答案
Neha，
你不需要单独打开表，尝试：
Neha,
You don''t need to open the tables separately, try:
谢谢Jared
这对我有帮助但我的问题是我无法指定name = Joe .....
它取决于用户在前端选择的名称[ASP]该特定名称的信息（由用户输入） ）应该显示（&可以有成千上万的名字。
plz help
neha
thanks Jared
this helped me but my problem is that i cannt specify name = Joe.....
it depends on the user which name they select on the front end [ASP] the information of that perticular name (typed by user) should be displayed (& there can be thousands of name).
plz help
neha
Neha，
对，我只是以此为例。查询字符串只是一个字符串变量，以db驱动程序可以理解的方式排列。组装字符串的方式与组装任何字符串的方式相同：
Neha,
Right, I just meant for this as an example. The query string is just a string variable arranged in such a way that a db driver can understand it. You assemble the string the same way you assemble any string:
这篇关于如何使用ASP从不同的Ms Access表中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
