1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

求助，找同时搜索多个access数据库的ASP程序。

Discussion in '后端开发' started by cmcm163, Apr 26, 2006.

  1. cmcm163

    cmcm163 New Member

    Joined:
    Dec 23, 2005
    Messages:
    59
    Likes Received:
    0
    求助，找同时搜索多个access数据库的ASP程序。

    因为我的网站是多个access数据库并存的，小弟不才，需要搞个站内搜索，又搞不出同时间搜索多个数据库的程序，麻烦知道的朋友帮我一把了。。。:lovely:
     
    #1 cmcm163, Apr 26, 2006
  2. Tameway

    Tameway New Member

    Joined:
    Sep 6, 2005
    Messages:
    1,286
    Likes Received:
    8
    逐个搜索
     
    #2 Tameway, Apr 26, 2006
  3. 小狼

    小狼 New Member

    Joined:
    Mar 15, 2006
    Messages:
    163
    Likes Received:
    1
    或者整编数据库,把其他数据库放变成一个数据库,增加表
     
    #3 小狼, Apr 26, 2006
  4. cmcm163

    cmcm163 New Member

    Joined:
    Dec 23, 2005
    Messages:
    59
    Likes Received:
    0
    怎样实现"逐个搜索"呢？
     
    #4 cmcm163, Apr 26, 2006
  5. cmcm163

    cmcm163 New Member

    Joined:
    Dec 23, 2005
    Messages:
    59
    Likes Received:
    0
    多表合并不太可能啊。。。合起来数据库太大了。

    如果能设定分类，然后搜索，也是行的。但是这个我也实现不了。。。。。
     
    #5 cmcm163, Apr 26, 2006
  6. 著名混混

    著名混混 New Member

    Joined:
    Mar 22, 2006
    Messages:
    292
    Likes Received:
    1
    只能逐个搜索了，先连一个库，然后关闭再去连另外一个库
     
    #6 著名混混, Apr 29, 2006
  7. cmcm163

    cmcm163 New Member

    Joined:
    Dec 23, 2005
    Messages:
    59
    Likes Received:
    0
    有没有这方面的程序呢？小弟是菜鸟。。:lovely:
     
    #7 cmcm163, May 10, 2006
  8. 风狼

    风狼 New Member

    Joined:
    Oct 1, 2005
    Messages:
    7,452
    Likes Received:
    25
    再建一个表。把所有表名都存进去。然后
    sql="select * from 总表"
    objRs.open sql,conn,1,1
    Do while Not objRs.Eof
    sql2="select * from "&objRs("表名字段")&" where 判断条件"
    Set objRs2=Server.Createobject("adodb.Recordset")
    objRs2.open sql2,conn,1,1
    这里进行显示处理。
    Loop
     
    #8 风狼, May 10, 2006
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)