update db

[Licass]

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.

 

[MD Websunlimited]

Hi Licass,

The question is to generic but asking for a soluation specific response.

 

[Licass]

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 "

 

[Stefan B Rusynko]

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
_____________________________________________


| 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" <[email protected]> escreveu na mensagem
| | > 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
| >
| >
| | > > 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.
| > >
| > >
| > >
| > >
| >
| >
|
|

 

[Licass]

it return the error
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/retorna_pay.asp, line 185

 

[MD Websunlimited]

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

it return the error
Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/retorna_pay.asp, line 185

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
_____________________________________________


| 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" <[email protected]> escreveu na mensagem
| | > 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
| >
| >
| | > > 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.
| > >
| > >
| > >
| > >
| >
| >
|
|