×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

替你回答了, 答案见内.

我不常来这,有问题到我论坛上问.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / 请教高手一个ASP and SQL问题。
    请教高手一个问题。
    我用MS Access存放了一些数据,其中一列存放的是自动生成的日期,格式为,例如:2003-4-20,2003-5-19。现在我想用ASP将数据按照不同的时间段取出来,从2003年4月1日到2003年5月31日。

    请问 SQL格式是什么?多谢!!!!
    • 用select语句写一个SQL语句就可以了
      • 替你回答了, 答案见内.
        我不常来这,有问题到我论坛上问.
      • I know how to use ASP and SELECT in SQL, but I don't know the format of date to be used in search, something like #2003-5-19#, or '2003-5-17', or #2003/5/19#. seems all of them didn't work.
        • 这问题是这样地:"select * from name where date = '#2003-05-19#' ".
          • Additional functions can be used in query too like datepart(...), it's useful for group by
            • Hi, Thanks, everybody! I tried several times. The right format is:
              Hi, Thanks, everybody!

              I tried several times. The right format is:

              FromTime = “2003-5-11”

              Totime = “2003-6-12”

              sql = "SELECT * FROM guestbook WHERE Time BETWEEN #" & FromTime & "# AND #" & ToTime & "#"

              rs.open sql, connection


              I have another question. I installed two OS in my computer. One is Win2000, and another is Red Hat Linux8. Every time when I boot my computer, a screen will prompt me to select an OS to boot. Days ago, I reinstalled win2000, this screen disappeared. Now I don’t have any choice. When booting, Win2000 is directly booted. How to solve this problem to get that screen back???

              Thanks