Conn.execute - update

[erez222]

hi ther

when i try this !!!

<%
tst = 1
Conn.execute (" update qpopup set mi1=" & tst & " Where loop=true ")
..... %>

it ok
olso if
tst = "1"
it ok

bat if

tst = "bla"

i gut err
i try this

Conn.execute (" update qpopup set mi1= ' " & tst &" ' Where loop=true ")

bat stil i gut err

pls help my
tanks erez

[lmf232s]

whats the error that you get

[Terrorke]

I think your datatype of the database field mi1 expects a numeric value.

What is the datatype of this field? And what is the max lenght for this field?

And what error do you get??

[erez222]

hi Terrorke
u jast right
that whas the problem , i cheng the filde type to string
and and the problem solvd
tanks to u all

[chrismartz]

It was most likely set to be an integer data type for that column and the integet data type doesn't allow text.