Data Type mismatch

[dodge20]

I keep getting a datatype mismatch when I try to run this query. It is when I try to use the = with the variable. College name is a list/menu on my form, and idnumber is an autonumber in the database. Can someone help me out?

SELECT iname, college_name, idnumber
FROM college, student
WHERE college.ipassword = student.ipassword and (isort like '%varlast_name%' or college_name = 'varcollege' or idnumber = 'varidnumber')

varlast_name % Request("isort")
varcollege % Request("college_name")
varidnumber % Request("idnumber")

Dodge20

 

[carstar]

Try removing the single quotes from around varidnumber in your WHERE statement.

 

[dodge20]

Without the quotes, I get a syntax error.

I am curious if I don't want a % for the default when I use an =. If not, what would I use?

Dodge20

 

[Cheech]

sql = "SELECT iname, college_name, idnumber
FROM college, student
WHERE college.ipassword = student.ipassword and (isort like '%" & varlast_name& "%' or college_name = '" & varcollege & "' or idnumber = '" & varidnumber & "')"

Cheech

[Peace][Pipe]

 

[dodge20]

That gave me a data type mismatch also. What I ended up doing is changing the or's to and's and using like instead of the equal sign. I don't understand the syntax with the quotes and &'s.

Dodge20

 

[carstar]

Dodge- where are you entering this SQL statement? Are you in "Code View" directly editing an asp script or is this from a wizard?

 

[dodge20]

I am entering it as a record set on the server behaviors. I am not doing it in code view.

Dodge20