|
if I use
<%
da_data=request.form("da_data") nome=request.form("nome") password=request.form("password") Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DSN=serverdb", "test", "test" sqlString = "update utentiall set da_data='20003-01-01' where nome='"&nome&"' and pw='"&password&"'" Con.Execute( sqlString ) %>
sql work properly if I use sintax
<%
da_data=request.form("da_data") nome=request.form("nome") password=request.form("password") Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DSN=serverdb", "test", "test" sqlString = "update utentiall set da_data='20'||substr('"&da_data&"',5,2)||'-'||substr('"&da_data&"',3,2)||'-'||substr('"&da_data&"',1,2) where nome='"&nome&"' and pw='"&password&"'" Con.Execute( sqlString ) %> where
da_date value is '010103'
and datatype of da_date field on table utentiall is date
I have
error message Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[SAP AG][SQLOD32 DLL][SAP DB]Datetime field overflow;-3048 POS(1) Invalid date format:ISO. /GEST_SAP/DB/contabilita/altusrdate.asp, line 18 what is the problem ???
tank's Fabio |
- Re: update whith date fied ing. fabio freddi
- Re: update whith date fied Daniel Dittmar
