Re: SQL Runs in Access and not in ASP: 0x80040E10 Too few parameters

OJ wrote:
> I fear my naivity is betraying me...is that not what my statement is
> saying?

No. Your expression is saying the equivalent of

x <= (y <= z)

which in English is:
x is less than or equal to the result of the comparison between y and z. So
if y is less than or equal to z, then the expression becomes:

x <= true

or

x <= -1

if y is grater than z, then you get:

x <= false
or
x <= 0


> I shall try to expand.....
> These elements of my SQL string will come from variables in the
> VBscript of my ASP:

This is irrelevant to the point I am trying to make.

>
> The SQL response.write works in Access and was generated from an
> original access query....I'm not sure what more to add!
>
Do you get the results you intend to get? Do some testing with just this
comparison in your sql. I've just run some tests of my own and in my tests,
this type of comparison did not return the correct results.
I'd be surprised if you are getting your expected results. Access must be
rewriting your logic if it is returning your intended results. I do not
think Jet and ADO will be so forgiving.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages