asp运行sql 语句的问题

[weilixya]

beforecount=(trim(request("page")-1))*pagesize

StrSQL="select top 20 * from xxxx where item_id not in (select top "&beforecount&" item_id from xxxx)"

在第二条语句"&beforecount&" 出错！将"&beforecount&" 换成数字则运行通过

在线等

[cqfeng]

try:

StrSQL="select top 20 * from xxxx where item_id not in (select top "&cstr(beforecount)&" item_id from xxxx)"

[jzywh]

Cint(request("page"))

把字符串转换成整型

[weilixya]

StrSQL="select top 20 * from xxxx where item_id not in (select top "&cstr(beforecount)&" item_id from xxxx)"

我式过了不行！

[peering08cn]

学习

[bananasmiling]

beforecount=(cint(request("page"))-1)*pagesize

StrSQL="select top 20 * from xxxx where item_id not in (select top "&beforecount&" item_id from xxxx)"

[weilixya]

Cint(request("page"))我式了一下，还是不行，晕了

[不老书生]

beforecount打印出来看看是什么！

beforecount＝Cint(beforecount）

[weilixya]

beforecount＝Cint(beforecount）

还是不行，我哭啊

[alan815]

beforecount=(cint(trim(request("page")))-1)*cint(pagesize)

[weilixya]

狂晕ing

response.write(beforcecount)

-20

上面一条语句有问题，7456，小白了一回。。。。汗~~~~~~