1
I’m getting this error when I try to update with mysql in Asp.
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/postos/reg.asp, line 525
set ins_regenf1 = conn.Execute("UPDATE reg SET hemo ='"&hemo &"' WHERE id_reg='"&id_ficha&"';")
-------------------------------------------------------^
I know it seems obvious but the values are correct as well as the defects in the comic is correct.
Does anyone have any idea what’s going on? Thank you
Ricardo, here only questions should be posted in Portuguese.
– Jéf Bueno
I did not think I was in the pt, I will change. thanks
– Ricardo Simoes
What is the content of
hemo?– Jéf Bueno
text, and this in the comic as varchar
– Ricardo Simoes
Conteúdo. What is the text?– Jéf Bueno
try to get the ";" out of parentheses !
– Elkin
I’ve taken it off and do the same :/
– Ricardo Simoes
is test.. type "fdjklshfldhs"
– Ricardo Simoes
You can run an update exactly like this on
mysql?– Jéf Bueno
Give me this error "Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and Reconnect." but has no logic the only key field is id which is of automatic numbering
– Ricardo Simoes
check the type of field in mysql and if it is varchar(5) see the number of characters allowed if it is inside the one configured, check if the field names are correct in the query according to the one created in the database.
– Wilson Rosa Gomes