RE: date format problem

[Zabach, Elke]

fabio freddi wrote:   > I have same problem with date format >  > If i use sql studio > 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   You believe to have some problem with date although the error tells you that  there is an      Invalid numeric constant ?!   If anyone knew how your statement looks like when those &... will be changed to the appropriate value, then we could try to help.   Please check the vtrace and look if at position 133 the number does not look correct (me be a mixture of '.' and ',' ?)   see http://sapdb.2scale.net/moin.cgi/VTrace for a description how to produce a vtrace. (but please change vtrace default to vtrace order in step 1 and 6)   Elke SAP Labs Berlin