Re: date format problem

[Sven K�hler]

<%
NOME=REQUEST.FORM("NOME")
PW=REQUEST.FORM("PW") TELEFONO=REQUEST.FORM("TELEFONO")
EMAIL=REQUEST.FORM("EMAIL") VIA=REQUEST.FORM("VIA") CAP=REQUEST.FORM("CAP") LUOGO=REQUEST.FORM("LUOGO")
PROVINCIA=REQUEST.FORM("PROVINCIA")
STATO=REQUEST.FORM("STATO")
TIPO_PAG=REQUEST.FORM("TIPO_PAG") NCARTA=REQUEST.FORM("NCARTA")
SCACARTA=REQUEST.FORM("SCACARTA")
LIVELLO=REQUEST.FORM("LIVELLO")
DA_DATA=REQUEST.FORM("DA_DATA")
A_DATA=REQUEST.FORM("A_DATA")

Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "DSN=serverdb", "test", "test"
sqlString = "UPDATE UTENTIALL SET "&_
"NOME='"&NOME&"', "&_
"PW='"&PW&"', "&_
"TELEFONO='"&TELEFONO&"', "&_ "EMAIL='"&EMAIL&"', "&_ "VIA='"&VIA&"', "&_ "CAP='"&CAP&"', "&_ "LUOGO='"&LUOGO&"', "&_ "PROVINCIA='"&PROVINCIA&"', "&_ "STATO='"&STATO&"', "&_ "TIPOPAG='"&TIPOPAG&"', "&_ "NCARTA='"&NCARTA&"', "&_ "SCADCARTA='"&SCADCARTA&"', "&_
"DA_DATA='2003-02-01', "&_
"A_DATA='2003-02-01', "&_
"LIVELLO='"&LIVELLO&"' "&_ "WHERE NOME='"&NOME&"' AND PW='"&PW&"'"
Con.execute sqlString
response.redirect "utenti0.asp"
%>

The above is an example how you should _not_ build your queries.
It's safer to use "?" in your query and bind parameters.

Altough i was once an ASP programmer too, i'm not firm enough to tell you how the code should look like, but this might solve your problem.
You should also try to parse the Date first with some ASP/VBScript-Code. That should produce Date-Object or something than can be easily bound to a query.


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general