|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 11th, 2004, 11:06 PM
|
|||
|
|||
|
Wt wrong with my recordset??
<html>
<%set cn = server.createobject("adodb.connection") 'set rs = server.createobject("adodb.recordset") cn.open "driver={microsoft access driver (*.mdb)}; dbq=d:\nnid\hgc\rocbo\rocbo\new1\cost.mdb" set rs = cn.execute "Select count(*) as reccount from [non residential 2004] where (cancel is null or cancel <> '1') and BB Rollout='Yes'" response.write(rs("reccount")) %> </html> Microsoft VBScript compilation error '800a0401' Expected end of statement /rocbo/rocbo/count.asp, line 21 set rs = cn.execute "Select count(*) as reccount from [non residential 2004] where (cancel is null or --------------------^ cancel <> '1') and BB Rollout='Yes'"
|
|
#2
August 12th, 2004, 07:56 AM
|
|||
|
|||
|
Hi,
Perhaps if you enclose it with ( and ) like this: Code:
set rs = cn.execute("Select count(*) as reccount from [non residential 2004] where (cancel is null or cancel <> '1') and BB Rollout='Yes'")
Grtz.© M.
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > Wt wrong with my recordset?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
