Webmaster Forum / ASP / Database Access / October 2005

([ss_ResSeasonsT]![SeasonStartDate]<=#01/11/2005#<=[ss_ResSeasonsT]![SeasonS
tartDate]+[ss_ResSeasonsT]![SeasonDays])

You need to remove the entire expression? What if you remove either

[ActivityID]=2

or

[ss_CentActsT]![CentActSkillCode] Like "*B*"

instead of removing them both?

I'm unclear about what you are showing us here? Is this sql the result of a
response.write satatement in your vbscript code? Or are you simply copying
and pasting it from the code itself? Best practice is to assign your sql
statement to a variable:

sSQL = "Select ... "

So you can response.write it to verify it contains what you expect it to
contain in the event of errors:

Response.Write sSQL

Are you using dynamic sql? if so you should consiter using parameters,
either via saved parameter queiries:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=eHYxOyvaDHA.402
0%40tk2msftngp13.phx.gbl

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=ukS%246S%247CHA
.2464%40TK2MSFTNGP11.phx.gbl

http://www.google.com/groups?selm=eETTdnvFDHA.1660%40TK2MSFTNGP10.phx.gbl&oe=UTF
-8&output=gplain

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=e6lLVvOcDHA.1204%4
0TK2MSFTNGP12.phx.gbl

or via using a Command object to pass data to  a sql string containing odbc
parameter markers:
http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36
562fee7804e

I'm surprised it runs at all from ASP given the exclamation points. Are
ss_CentActsT and  ss_ResSeasonsT tables in your database? f so, you should
be using a period in your sql to qualify the field names, not an exclamation
point, which is usually reserved for form and recordset objects.

The following points have nothing to do with your problem, but keep them in
mind:

When running a query using ADO from ASP, you need to use the ODBC wildcards
(% and _) instead of the jet wildcards (* and ?)

You should also supply dates in a non-ambiguous format: yyyy-mm-dd, instead
of whichever format you are using (is it mm/dd/yyyy?)

Your object names have no unusual characters, so there is no need to
surround them with brackets unless they are parameters.

OJ wrote on 26 okt 2005 in microsoft.public.inetserver.asp.db:

! is a unary operator

<=[ss_ResSeasonsT]![SeasonStartDate]+[ss_ResSeasonsT]![SeasonDays])

Also, I'm not sure this is doing what you think it is doing. What you are
meaning to say is:

#01/11/2005# BETWEEN ss_ResSeasonsT.SeasonStartDate AND
ss_ResSeasonsT.SeasonStartDate + ss_ResSeasonsT.SeasonDays

Some people prefer this style:
ss_ResSeasonsT.SeasonStartDate < = #01/11/2005# AND
ss_ResSeasonsT.SeasonStartDate + ss_ResSeasonsT.SeasonDays >= #01/11/2005#

Bob Barrows