帮我看看那里错了！

[icecsdn]

我想从数据库中取出日期和当前日期相等，并且时间在给定的一个范围内的数据。
字段zhudian应该在两个时间段之间。
var s:String;
n1,n2 : TParameter;
s:string

s:='select * from t1 where (nowdate=#'+Datetostr(date)+'#) and (zhudian >=n1) and (zhudian<=:n2)';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('n1').value:=strtodate('91-8-1');
Parameters.parambyname('n2').value:=strtodate('93-2-1');
open;
end;

[icecsdn]

上面写错了
我想从数据库中取出日期和当前日期相等，并且时间在给定的一个范围内的数据。
字段zhudian应该在两个时间段之间。
var s:String;
n1,n2 : TParameter;
s:string

s:='select * from t1 where (nowdate=#'+Datetostr(date)+'#) and (zhudian >=n1) and (zhudian<=:n2)';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('n1').asdatetime:=strtodate('9:00:00');
Parameters.parambyname('n2').asdatetime:=strtodate('18:00:00');
open;
end;

[naughtyboy]

s:='select * from t1 where (nowdate=#'+Datetostr(date)+'#) and (zhudian >=:n1) and (zhudian<=:n2)';
nowdate=#'+Datetostr(date)+'#这里也换一下

[icecsdn]

什么意思？

[movingboy]

1)s:=......一句中的#应该替换为两个单引号
2)n1前好像少了一个冒号

[icecsdn]

谁能解决啊？

[icecsdn]

谁能解决啊？

[icecsdn]

谁知道啊？

[zhptj]

var s:String;
n1,n2 : TParameter;
s:string
ss:string;
ss:='#'+Datetostr(date)+'#';

s:='select * from t1 where nowdate=:zz) and zhudian >=:n1 and zhudian<=:n2';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('zz').asstring:=ss;
Parameters.parambyname('n1').asdatetime:=strtodate('9:00:00');
Parameters.parambyname('n2').asdatetime:=strtodate('18:00:00');
open;
end;

[xfgncit98]

为什么不再设一个Tparameter型变量n3
s:=s:='select * from t1 where (nowdate = n3) and (zhudian >=n1) and (zhudian<=:n2)';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('n1').asdatetime:=strtodate('9:00:00');
Parameters.parambyname('n2').asdatetime:=strtodate('18:00:00');
Parameters.parambyName('n3').asdatetime:=date;
open;
end;

[johnsonrao]

s:='select * from t1 where (nowdate=:n0) and (zhudian >=:n1) and (zhudian<=:n2)';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('n1').asdatetime:=strtoTime('9:00:00');
Parameters.parambyname('n2').asdatetime:=strtoTime('18:00:00');
Parameters.parambyName('n3').asdatetime:=date;
open;
end;

[johnsonrao]

s:='select * from t1 where (nowdate=:n3) and (zhudian >=:n1) and (zhudian<=:n2)';
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add(s);
Parameters.parambyname('n1').asdatetime:=strtoTime('9:00:00');
Parameters.parambyname('n2').asdatetime:=strtoTime('18:00:00');
Parameters.parambyName('n3').asdatetime:=date;
open;
end;