MD
Wed Feb 08 13:29:03 CST 2006
Is the column n_persevere an int or char? If int don't use '331'
--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
FrontPage Add-in
"Licass" <l.r.m.d@sapo.pt> wrote in message news:%231CYRuNLGHA.3944@tk2msftngp13.phx.gbl...
> it return the error
> Microsoft JET Database Engine error '80040e07'
>
> Data type mismatch in criteria expression.
>
> /retorna_pay.asp, line 185
>
>
>
> "Stefan B Rusynko" <sbr_enjoy@hotmail.com> escreveu na mensagem
> news:Oq5fKBJLGHA.380@TK2MSFTNGP10.phx.gbl...
>> See
http://www.w3schools.com/ado/ado_update.asp
>> Missing delimiters
>> mySQL= "UPDATE prereserva SET situacao='leo' WHERE n_prereserva='331'"
>>
>> --
>>
>> _____________________________________________
>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> "Warning - Using the F1 Key will not break anything!" (-;
>> To find the best Newsgroup for FrontPage support see:
>>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
>> _____________________________________________
>>
>>
>> "Licass" <l.r.m.d@sapo.pt> wrote in message
> news:%23wuJ7NELGHA.3064@TK2MSFTNGP10.phx.gbl...
>> | this is the error code
>> | Microsoft JET Database Engine error '80040e10'
>> |
>> | No value given for one or more required parameters.
>> |
>> | /retorna_pay.asp, line 185
>> |
>> | and this the code
>> | mySQL= "UPDATE prereserva SET situacao=leo WHERE n_prereserva=331 "
>> |
>> |
>> | "MD Websunlimited" <none@none.com> escreveu na mensagem
>> | news:ucRmaUDLGHA.500@TK2MSFTNGP15.phx.gbl...
>> | > Hi Licass,
>> | >
>> | > The question is to generic but asking for a soluation specific
> response.
>> | >
>> | > --
>> | > Mike -- FrontPage MVP '97 - '02
>> | >
http://www.websunlimited.com
>> | > FrontPage Add-in
>> | >
>> | >
>> | > "Licass" <l.r.m.d@sapo.pt> wrote in message
>> | news:%23YqWDIDLGHA.2336@TK2MSFTNGP12.phx.gbl...
>> | > > hi
>> | > > i have this page where the user return after pay , that receives
> values
>> | that
>> | > > i store in variables. i would like to store this variables in a
> table in
>> | my
>> | > > db. how to write that code.
>> | > >
>> | > >
>> | > >
>> | > >
>> | >
>> | >
>> |
>> |
>>
>>
>
>