data type incorrect - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

data type incorrect

everytime when I try to use "autonumber" field in SQL statements, it always give this error:

Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression

I'm trying this expression:

set rsproj = conexao.execute("select * from projetos where id = '" & rs("projeto") & "'")

---
id-> is an autonumber field of a table called "projetos"
rs("projeto") -> is a number that is caught of another table called projs


anything wrong ?

Comments

  • faustinegeorgefaustinegeorge Posts: 351Member
    You don't need single quotes around numbers in an sql query
    [code]
    set rsproj = conexao.execute("select * from projetos where id = " & rs("projeto") & "")

    [/code]

    HTH
    Faustine
    --------
    : everytime when I try to use "autonumber" field in SQL statements, it always give this error:
    :
    : Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression
    :
    : I'm trying this expression:
    :
    : set rsproj = conexao.execute("select * from projetos where id = '" & rs("projeto") & "'")
    :
    : ---
    : id-> is an autonumber field of a table called "projetos"
    : rs("projeto") -> is a number that is caught of another table called projs
    :
    :
    : anything wrong ?
    :

Sign In or Register to comment.