What's wrong with my SELECT statement?

[ElEye]

Here's what I wrote:

strsql = ""
strsql = "SELECT * from [Table1] WHERE "
strsql = strsql & " [Column1] NOT in ('abc','def','ghi')"
strsql = strsql & " AND [Column2] = " & variable1
strsql = strsql & " OR [Column3] = " & variable1
strsql = strsql & " OR [Column4] = " & variable1
strsql = strsql & " ORDER BY [Column5] ASC"

The results I get are as if the statement said:

strsql = ""
strsql = "SELECT * from [Table1] WHERE "
strsql = strsql & " [Column2] = " & variable1
strsql = strsql & " OR [Column3] = " & variable1
strsql = strsql & " OR [Column4] = " & variable1
strsql = strsql & " ORDER BY [Column5] ASC"

What am I doing wrong?

TIA,

Dave
[

http://flashspot.com

]

 

[Tarwn]

Have you tried Response.Write'ing the statment to the screen and then pasting it into your database query analyzer to see what it does in there?

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[ElEye]

I'm sorry, I should have done so. Here's the response:

SELECT * from [Table1] WHERE [Column1] NOT in ('abc','def','ghi') AND [Column2] = 'variable1 result' OR [Column3] = 'variable1 result' OR [Column4] = 'variable1 result' ORDER BY [Column5] ASC

It sure looks like it's doing what I want, but the data is not.

TIA,

Dave
[

http://flashspot.com

]

 

[ElEye]

SOLVED!

Please note the parans:

strsql = ""
strsql = "SELECT * from [Table1] WHERE"
strsql = strsql & " ([Column1] NOT in ('abc','def','ghi'))"
strsql = strsql & " AND ([Column2] = " & tkey
strsql = strsql & " OR [Column3] = " & tkey
strsql = strsql & " OR [Column4] = " & tkey
strsql = strsql & &quot ORDER BY [Column4] ASC"

Dave
[

http://flashspot.com

]

 

[Tarwn]

Ah...see now if I had asked about that we would have had it solved earlier, but I didnt make the connection earlier

Sorry about that,
-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/