This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Ad by

推荐 OXIO 加拿大高速网络，最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Hi, Thanks, everybody! I tried several times. The right format is:

doodle(doodle)

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

(#1199362@0)
Last Updated: 2003-5-22
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)
我不常来这,有问题到我论坛上问.
http://www.aaunion.net/dispbbs.asp?boardid=26&id=330&star=1#589
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

@Sacramento

Hi, Thanks, everybody! I tried several times. The right format is:

Replies, comments and Discussions:

More Topics