UPDATE UTENTIALL SET
DA_DATA='2003-02-01'
work properly
in this sql
<%
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"
%>
I have this message
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[SAP AG][SQLOD32
DLL][SAP DB]Error in assignment;-3016 POS(133) Invalid numeric
constant.
/gest_sap/db/pianoc/alterutenti0.asp, line 44
What's the problem ???
Thanks Fabio
