asp:比较两个访问数据库中的记录 [英] asp : compare records in two access databases
问题描述
我已经找到了一个可以比较两个记录的asp脚本
不同的访问数据库
mdb'具有完全相同的表
我想要的是(输出)所有差异都来自html-table
在一个网页
可以有人帮助我,给我一个例子吗?
谢谢
夏洛特
" Charlotte" < ch *************** @ SPAMtelenet.bewrote in message
news:%P ************** ***** @ newsfet14.ams ...
>
我已经找到了一个可以比较两个
不同访问数据库中所有记录的asp脚本
mdb'具有完全相同的表
我想要的是(输出)所有差异都来自html-table
在一个网页
可以有人帮助我,给我举个例子?
是否定义了主键?
您希望输出看起来像什么?
给定此布局:" key,field1,field2"
其中表1包含
1,a,b
2,c ,$
和表2包含::
1,a,b
3,e,f
您希望如何报告差异?
或许只是确定关键?差异?
table1:1 =,2 +,3-
table2:1 =,2-,3 +
Evertjan。写道:
Bob Barrows [MVP]于2008年2月11日写在
microsoft.public.inetserver.asp.general:
我不认为,在OP的情况下,鲍勃,这是关于大型数据库的用户和
,但关于业主想要做一些
半定期在她的数据库上工作,比如说一次b / b
。
我不确定你是怎么得出这个结论的。
>
设置一个需要10分钟或者一个小时的动作过程
在ASP中并没有那么糟糕。
如果涉及繁忙的网络服务器。
能够从不同的
位置是ASP方法的一个很好的补充。
以及其他各种远程程序技术。
-
Microsoft MVP - ASP /ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复,请删除
NO SPAM
$ b $
我已经找到了一个可以比较两个
不同访问数据库中所有记录的asp脚本
mdb'有完全相同的表
我想要的是(输出)所有差异都来自html表中
在一个网页中
有人可以帮我吗,给我一个例子吗?
谢谢
charlotte
例子:
我有两个MDB并且两者都有完全相同的表(table1)
来自MDB1的
table1和来自MDB2的table1完全相同结构
每个包含以下字段:
id,lastname,firstname
MDB1中的
是100条记录
$ b MDB2中的$ b是90条记录
(记录为id 91,92,93,..... 100不存在)
并记录i d 50有一个不同的名字
所以,这将是:
50 - 没有 - MDB1中的错误名字
91 - peeters - kurt
92 - hannivoort - evertjan
93 - deleeuw - charlotte
....
....
100 - 特拉沃尔塔 - 约翰
html表是:
< table>
< tr>
< td> 50< / td>
< td>< / td>
< td>错误的名字< / td>
< / tr>
< tr>
< td> 91< / td>
< td> peeters< / td>
< td> kurt< / td>
< / tr>
< tr>
< td> 92< / td>
< td> hannivoort< / td>
< td> evertjan< / td>
< / tr>
< tr>
< td> 93< / td>
< td> deleeuw< / td>
< td> charlotte< / td>
< / tr>
....
....
< tr>
< td> 100< / td>
< td> travolta< / td>
< td> john< / td>
< / tr>
< / table>
所以,两个MDB中的记录不一样html-table
以及所有在MDB1中都没有的记录
我希望这是不可理解的
charlotte
Hi,
i''ve googeled to find a asp-script that can compare all the records in two
different access databases
the mdb''s have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?
thanks
charlotte
"Charlotte" <ch***************@SPAMtelenet.bewrote in message
news:%P*******************@newsfet14.ams...>
Hi,
i''ve googeled to find a asp-script that can compare all the records in two
different access databases
the mdb''s have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?Is a primary key defined?
What do you want the output to look like?
Given this layout: "key,field1,field2"
where table 1 contains
1,a,b
2,c,d
and table 2 contains::
1,a,b
3,e,f
How would you want the differences reported?
Perhaps just identifying the "key" differences?
table1 : 1=,2+,3-
table2 : 1=,2-,3+
Evertjan. wrote:Bob Barrows [MVP] wrote on 11 feb 2008 in
microsoft.public.inetserver.asp.general:
I don''t think, in the case of the OP, Bob, this is about users and
about large databases, but about the owner wanting to do some
houeshold jobs on her database on a semi regular basis, say once a
year.
I''m not sure how you came to that conclusion.
>
Setting a process in motion that takes 10 minutes or perhaps an hour
in ASP is not that bad.It is if a busy web server is involved.
Being able to do that from different
locations is a nice plus of the ASP method.Along with various other remote procedure techniques.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
Hi,
i''ve googeled to find a asp-script that can compare all the records in two
different access databases
the mdb''s have exactly the same tables
what i want is that (the output) all the differences comes in a html-table
in a webpage
can anybody help me, are give me a example ?
thanks
charlotte
example:
I have two MDB and both have exactly the same table (table1)
table1 from MDB1 and table1 from MDB2 have exactly the same structure
each containing these fields:
id , lastname , firstname
in MDB1 are 100 records
in MDB2 are 90 records
(records with id 91,92,93,.....100 aren''t there)
and record with id 50 has a different firstname
so, this will be:
50 - nothing - wrong firstname that is in MDB1
91 - peeters - kurt
92 - hannivoort - evertjan
93 - deleeuw - charlotte
....
....
100 - travolta - john
the html-table is:
<table>
<tr>
<td>50</td>
<td></td>
<td>wrong firstname</td>
</tr>
<tr>
<td>91</td>
<td>peeters</td>
<td>kurt</td>
</tr>
<tr>
<td>92</td>
<td>hannivoort</td>
<td>evertjan</td>
</tr>
<tr>
<td>93</td>
<td>deleeuw</td>
<td>charlotte</td>
</tr>
....
....
<tr>
<td>100</td>
<td>travolta</td>
<td>john</td>
</tr>
</table>
so, the records that aren''t the same in the two MDB comes in the html-table
and also all the records witch aren''t in MDB1
I hope this is ubderstandable
charlotte
这篇关于asp:比较两个访问数据库中的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!