UPDATE atividade SET at1s='150', at1e='150', at1m='', at2s='150', at2e='150', at2m='150', hora1s='15:19', hora1e='15:19', hora1m='', hora2s='15:19', hora2e='15:19', hora2m='15:19' WHERE id=1
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/alexct/ativ_online2005/controle_geral.asp, line 403
SQL = "UPDATE atividade SET at1s='"&at1s&"', at1e='"&at1e&"', at1m='"&at1m&"', at2s='"&at2s&"', at2e='"&at2e&"', at2m='"&at2m&"', hora1s='"&hora1s&"', hora1e='"&hora1e&"', hora1m='"&hora1m&"', hora2s='"&hora2s&"', hora2e='"&hora2e&"', hora2m='"&hora2m&"' WHERE id=1"
Set RS = Conn.Execute(SQL)
Tô Com Este Erro!
Started By AlexCT, 12/12/2004, 14:07
1 reply to this topic
#2
felipecm
-
- Usuários
-
- 541 posts
Expert
- Sexo:Não informado
- Localidade:ABC / SP
Posted 12/12/2004, 15:02
Quando o campo for numérico não se faz necessario o uso de apostrofes.. e , no caso, vc terá que alterar os valores vazios para 0..UPDATE atividade SET at1s='150', at1e='150', at1m='', at2s='150', at2e='150', at2m='150', hora1s='15:19', hora1e='15:19', hora1m='', hora2s='15:19', hora2e='15:19', hora2m='15:19' WHERE id=1
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/alexct/ativ_online2005/controle_geral.asp, line 403
SQL = "UPDATE atividade SET at1s='"&at1s&"', at1e='"&at1e&"', at1m='"&at1m&"', at2s='"&at2s&"', at2e='"&at2e&"', at2m='"&at2m&"', hora1s='"&hora1s&"', hora1e='"&hora1e&"', hora1m='"&hora1m&"', hora2s='"&hora2s&"', hora2e='"&hora2e&"', hora2m='"&hora2m&"' WHERE id=1"
Set RS = Conn.Execute(SQL)
MCAD, MCP
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)
