Re: update db

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@xxxxxxxxxxx> escreveu na mensagem
news:Oq5fKBJLGHA.380@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxx> wrote in message
news:%23wuJ7NELGHA.3064@xxxxxxxxxxxxxxxxxxxxxxx
| 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@xxxxxxxx> escreveu na mensagem
| news:ucRmaUDLGHA.500@xxxxxxxxxxxxxxxxxxxxxxx
| > 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@xxxxxxx> wrote in message
| news:%23YqWDIDLGHA.2336@xxxxxxxxxxxxxxxxxxxxxxx
| > > 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.
| > >
| > >
| > >
| > >
| >
| >
|
|




.

Relevant Pages

  • Dragonfly Shopping Cart Multiple vulnerabilities
    ... Microsoft JET Database Engine error '80040e07' ... Data type mismatch in criteria expression. ...
    (Bugtraq)
  • Dreaded Jet DB error 80004005 help needed. What causes this???
    ... I'm trying to understand what causes this error message: ... Microsoft JET Database Engine error '80004005' ... The Microsoft Jet database engine cannot open the file ...
    (microsoft.public.inetserver.asp.db)
  • Re: Humans are lazy.
    ... routines properly, LOL. ... Microsoft JET Database Engine error '80040e14' ...
    (alt.2600)
  • Re: Humans are lazy.
    ... routines properly, LOL. ... Microsoft JET Database Engine error '80040e14' ...
    (alt.2600)
  • Re: update db
    ... To find the best Newsgroup for FrontPage support see: ... | Microsoft JET Database Engine error '80040e10' ... |>> i store in variables. ...
    (microsoft.public.frontpage.programming)