Raphael Moraes Posted March 7, 2012 Report Share Posted March 7, 2012 Boa tarde,Estou com um problema do qual não consigo resolver,faço uma query no meu asp e ele retorna um type mismatch, porém quando tento via sql, funciona normal,Alguém poderia me ajudar?Segue,count_query = "SELECT COUNT(pkni_id) as qty_log FROM DOCOWN.tb_qm_log WHERE atsf_dev ='" & atsf_dev & "' AND atsf_line = '" & atsf_line & "' AND atsf_pn ='" & atsf_pn & "' AND atsf_machine ='" & atsf_machine & "' AND atsf_product = '" & atsf_product & "'" Set recLogTemp = conDB.Execute(count_query) qty = recLogTemp.Fields("qty_log") If recLogTemp.Fields("qty_log") > 2 OR recLogTemp.Fields("qty_log") = 2 Then Quote Link to comment Share on other sites More sharing options...
0 bareta Posted March 9, 2012 Report Share Posted March 9, 2012 tem certeza que todos os campos são do tipo texto no banco? Quote Link to comment Share on other sites More sharing options...
Question
Raphael Moraes
Boa tarde,
Estou com um problema do qual não consigo resolver,
faço uma query no meu asp e ele retorna um type mismatch, porém quando tento via sql, funciona normal,
Alguém poderia me ajudar?
Segue,
count_query = "SELECT COUNT(pkni_id) as qty_log FROM DOCOWN.tb_qm_log WHERE atsf_dev ='" & atsf_dev & "' AND atsf_line = '" & atsf_line & "' AND atsf_pn ='" & atsf_pn & "' AND atsf_machine ='" & atsf_machine & "' AND atsf_product = '" & atsf_product & "'" Set recLogTemp = conDB.Execute(count_query) qty = recLogTemp.Fields("qty_log") If recLogTemp.Fields("qty_log") > 2 OR recLogTemp.Fields("qty_log") = 2 ThenLink to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.