×

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

@Calgary

替你回答了, 答案见内.

nadir(xi)
我不常来这,有问题到我论坛上问.
(#1195252@0)
Last Updated: 2003-5-19
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

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

    请问 SQL格式是什么？多谢！！！！
    • 用select语句写一个SQL语句就可以了 -zlinda(晴耕雨读); 2003-5-19 (#1195242@0)
      • 替你回答了, 答案见内. -nadir(xi); 2003-5-19 {30} (#1195252@0)
        我不常来这,有问题到我论坛上问.
      • 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. -doodle(doodle); 2003-5-19 (#1195667@0)
        • 这问题是这样地:"select * from name where date = '#2003-05-19#' ". -rror(斧头帮黄金左脚系统支); 2003-5-19 (#1195688@0)
          • Additional functions can be used in query too like datepart(...), it's useful for group by -jchonc(James); 2003-5-20 (#1195970@0)
            • Hi, Thanks, everybody! I tried several times. The right format is: -doodle(doodle); 2003-5-22 {640} (#1199362@0)
              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

More Topics

  • Torvalds patch improves Linux performance by 2.6%
  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论