Hi,

I wrote a code:

 for hh = 1 to 20
SQL2= "select * from mega where sta_1 <= '"&hh&"' and stp_1 >= '"&hh&"' "
set ts = conn.execute(SQL2)

 do while not ts.eof

 b = b + 1

ts.movenext

The problem is that the code will execute perfect for hh= 1 to 9, but recognises 10, 11, 12... as values less than 2. Hence the over all result will not be perfect.

Can anyone help me force the machine to recognise 10, 11, 12 etc as their true values i.e greater than 9. It seems that the code is interpreting them as a text and not as a number. I tried changing the field value in the Acces DB to "number" from "text" but it will return an error of "data type mismatch in criteria expression"

As a string, those numbers are less than 2.

Change your database field to a number and try this:

SQL2 = "select * from mega where sta_1 <= {0} and stp_1 >= {0}"
for hh = 1 to 20
    set ts = conn.execute(string.format(SQL2, hh))
...

-Peter

Peter,
I tried it and it gave me this error:
Wrong number of arguments or invalid property assignment: 'string'
 on the line set ts = conn.execute(string.format(SQL2, hh))

Regards,
Safiyyu

What language are you working in? I realize after re-reading the post that your use of "conn.execute" and ".eof" lead me to believe you are not in a .NET language.

-Peter

Yes, Im using ASP with VBscript.

Safiyyu

This is an ASP.NET forum. If you have specific ASP or VBScript questions there are forums dedicated to those.

Just remove the single quotes from your original query.

-Peter

Ok thnx a lot n bye.